APPS.GMO_PURGE dependencies on FND_MSG_PUB

Line 15: FND_MSG_PUB.ADD;

11: BEGIN
12:
13: IF (P_END_DATE > sysdate) THEN
14: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
15: FND_MSG_PUB.ADD;
16: RAISE INVALID_DATE_EXCEPTION;
17: END IF;
18:
19: /* Validate if end data is null and request is not for truncate */

Line 22: FND_MSG_PUB.ADD;

18:
19: /* Validate if end data is null and request is not for truncate */
20: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE= GMO_CONSTANTS_GRP.NO) THEN
21: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
22: FND_MSG_PUB.ADD;
23: RAISE INVALID_PARAM_EXCEPTION;
24: END IF ;
25:
26: IF(P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.YES) THEN

Line 49: FND_MSG_PUB.ADD;

45: WHEN OTHERS THEN
46: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_DEVICE_DB_ERR');
47: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
48: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
49: FND_MSG_PUB.ADD;
50: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
51: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_device_data', FALSE);
52: end if;
53: RAISE;

Line 69: FND_MSG_PUB.ADD;

65: BEGIN
66:
67: IF (P_END_DATE > sysdate) THEN
68: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
69: FND_MSG_PUB.ADD;
70: RAISE INVALID_DATE_EXCEPTION;
71: END IF;
72:
73: /* Validate if end data is null and request is not for truncate */

Line 76: FND_MSG_PUB.ADD;

72:
73: /* Validate if end data is null and request is not for truncate */
74: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.NO) THEN
75: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
76: FND_MSG_PUB.ADD;
77: RAISE INVALID_PARAM_EXCEPTION;
78: END IF ;
79:
80: IF(P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.YES) THEN

Line 118: FND_MSG_PUB.ADD;

114: WHEN OTHERS THEN
115: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_INSTR_DB_ERR');
116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
118: FND_MSG_PUB.ADD;
119: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
120: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_instruction_data', FALSE);
121: end if;
122: RAISE;

Line 136: FND_MSG_PUB.ADD;

132: BEGIN
133:
134: IF (P_END_DATE > sysdate) THEN
135: fnd_message.set_name('GMO', 'GMO_PURGE_FUTURE_END_DATE');
136: FND_MSG_PUB.ADD;
137: RAISE INVALID_DATE_EXCEPTION;
138: END IF;
139:
140: /* Validate if end data is null and request is not for truncate */

Line 143: FND_MSG_PUB.ADD;

139:
140: /* Validate if end data is null and request is not for truncate */
141: IF(P_END_DATE IS NULL AND P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.NO) THEN
142: fnd_message.set_name('GMO', 'GMO_INVALID_INPUT_PARAM');
143: FND_MSG_PUB.ADD;
144: RAISE INVALID_PARAM_EXCEPTION;
145: END IF ;
146:
147:

Line 166: FND_MSG_PUB.ADD;

162: WHEN OTHERS THEN
163: FND_MESSAGE.SET_NAME('GMO','GMO_PURGE_ALL_DB_ERR');
164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
166: FND_MSG_PUB.ADD;
167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_purge.purge_all', FALSE);
169: end if;
170: RAISE;