DBA Data[Home] [Help]

APPS.GMD_ACTIVITIES_PUB dependencies on FND_MSG_PUB

Line 75: fnd_msg_pub.initialize;

71: END IF;
72:
73: /* Initialize message list and count if needed */
74: IF p_init_msg_list THEN
75: fnd_msg_pub.initialize;
76: END IF;
77:
78: /* Initially let us assign the return status to success */
79: x_return_status := FND_API.g_ret_sts_success;

Line 110: FND_MSG_PUB.ADD;

106: gmd_debug.put_line('activity required');
107: END IF;
108: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
109: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');
110: FND_MSG_PUB.ADD;
111: x_return_status := FND_API.g_ret_sts_error;
112: END IF;
113:
114: /* Cost Analysis Code Validations - Must be passed, otherwise give error */

Line 123: FND_MSG_PUB.ADD;

119: END IF;
120:
121: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
122: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.g_ret_sts_error;
125: ELSE
126: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_activity_tbl(i).cost_analysis_code) <> 0 THEN
127: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');

Line 128: FND_MSG_PUB.ADD;

124: x_return_status := FND_API.g_ret_sts_error;
125: ELSE
126: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_activity_tbl(i).cost_analysis_code) <> 0 THEN
127: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
128: FND_MSG_PUB.ADD;
129: x_return_status := FND_API.g_ret_sts_error;
130: END IF;
131: END IF;
132:

Line 140: FND_MSG_PUB.ADD;

136: gmd_debug.put_line('activity desc required');
137: END IF;
138: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
139: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.g_ret_sts_error;
142: END IF;
143:
144: END LOOP;

Line 163: FND_MSG_PUB.count_and_get(p_count => x_message_count

159: /* Adding message to stack indicating the success of the routine */
160: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
161: END IF;
162:
163: FND_MSG_PUB.count_and_get(p_count => x_message_count
164: ,p_data => x_message_list);
165:
166: EXCEPTION
167: WHEN setup_failure OR invalid_version THEN

Line 170: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

166: EXCEPTION
167: WHEN setup_failure OR invalid_version THEN
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: ROLLBACK TO SAVEPOINT insert_activity;
170: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
171: P_data => x_message_list);
172: WHEN ins_activity_err THEN
173: x_return_status := l_retn_status;
174: ROLLBACK TO SAVEPOINT insert_activity;

Line 175: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

171: P_data => x_message_list);
172: WHEN ins_activity_err THEN
173: x_return_status := l_retn_status;
174: ROLLBACK TO SAVEPOINT insert_activity;
175: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
176: P_data => x_message_list);
177: WHEN OTHERS THEN
178: ROLLBACK TO SAVEPOINT insert_activity;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 182: FND_MSG_PUB.ADD;

178: ROLLBACK TO SAVEPOINT insert_activity;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
184: P_data => x_message_list);
185: END Insert_Activity;
186:

Line 183: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
184: P_data => x_message_list);
185: END Insert_Activity;
186:
187:

Line 228: fnd_msg_pub.initialize;

224: END IF;
225:
226: /* Initialize message list and count if needed */
227: IF p_init_msg_list THEN
228: fnd_msg_pub.initialize;
229: END IF;
230:
231: IF NOT gmd_api_grp.setup_done THEN
232: gmd_api_grp.setup_done := gmd_api_grp.setup;

Line 260: FND_MSG_PUB.ADD;

256: gmd_debug.put_line('activity required');
257: END IF;
258: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
259: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');
260: FND_MSG_PUB.ADD;
261: x_return_status := FND_API.g_ret_sts_error;
262: ELSE
263: /* Check for the existense of activity */
264: OPEN Cur_check_activity(p_activity);

Line 279: FND_MSG_PUB.ADD;

275: /* Col_to_update and value must be passed, otherwise give error */
276: IF p_update_table(i).p_col_to_update IS NULL THEN
277: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
278: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
279: FND_MSG_PUB.ADD;
280: x_return_status := FND_API.g_ret_sts_error;
281: ELSIF p_update_table(i).p_value IS NULL THEN
282: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
283: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');

Line 284: FND_MSG_PUB.ADD;

280: x_return_status := FND_API.g_ret_sts_error;
281: ELSIF p_update_table(i).p_value IS NULL THEN
282: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
283: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
284: FND_MSG_PUB.ADD;
285: x_return_status := FND_API.g_ret_sts_error;
286: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN
287: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,
288: x_return_status => l_retn_status);

Line 291: FND_MSG_PUB.ADD;

287: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,
288: x_return_status => l_retn_status);
289: IF l_retn_status <> 'S' THEN /* it indicates that invalid value has been passed */
290: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
291: FND_MSG_PUB.ADD;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: END IF;
294: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'ACTIVITY_DESC' THEN
295: IF p_update_table(i).p_value IS NULL THEN

Line 298: FND_MSG_PUB.ADD;

294: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'ACTIVITY_DESC' THEN
295: IF p_update_table(i).p_value IS NULL THEN
296: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
297: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');
298: FND_MSG_PUB.ADD;
299: x_return_status := FND_API.g_ret_sts_error;
300: END IF;
301: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
302: IF p_update_table(i).p_value IS NULL THEN

Line 305: FND_MSG_PUB.ADD;

301: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
302: IF p_update_table(i).p_value IS NULL THEN
303: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
304: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');
305: FND_MSG_PUB.ADD;
306: x_return_status := FND_API.g_ret_sts_error;
307: ELSE
308: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_update_table(i).p_value) <> 0 THEN
309: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');

Line 310: FND_MSG_PUB.ADD;

306: x_return_status := FND_API.g_ret_sts_error;
307: ELSE
308: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_update_table(i).p_value) <> 0 THEN
309: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
310: FND_MSG_PUB.ADD;
311: x_return_status := FND_API.g_ret_sts_error;
312: END IF;
313: END IF;
314: END IF;

Line 335: FND_MSG_PUB.count_and_get(p_count => x_message_count

331: /* Adding message to stack indicating the success of the routine */
332: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
333: END IF;
334:
335: FND_MSG_PUB.count_and_get(p_count => x_message_count
336: ,p_data => x_message_list);
337:
338: EXCEPTION
339: WHEN setup_failure OR invalid_version THEN

Line 342: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

338: EXCEPTION
339: WHEN setup_failure OR invalid_version THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: ROLLBACK to SAVEPOINT update_activity;
342: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
343: P_data => x_message_list);
344: WHEN upd_activity_err THEN
345: x_return_status := l_retn_status;
346: ROLLBACK to SAVEPOINT update_activity;

Line 347: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

343: P_data => x_message_list);
344: WHEN upd_activity_err THEN
345: x_return_status := l_retn_status;
346: ROLLBACK to SAVEPOINT update_activity;
347: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
348: P_data => x_message_list);
349: WHEN OTHERS THEN
350: ROLLBACK to SAVEPOINT update_activity;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 354: FND_MSG_PUB.ADD;

350: ROLLBACK to SAVEPOINT update_activity;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
353: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
354: FND_MSG_PUB.ADD;
355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
356: P_data => x_message_list);
357:
358: END update_activity;

Line 355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
353: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
354: FND_MSG_PUB.ADD;
355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
356: P_data => x_message_list);
357:
358: END update_activity;
359:

Line 407: FND_MSG_PUB.count_and_get(p_count => x_message_count

403: IF p_commit THEN
404: COMMIT;
405: END IF;
406:
407: FND_MSG_PUB.count_and_get(p_count => x_message_count
408: ,p_data => x_message_list);
409:
410: EXCEPTION
411: WHEN del_activity_err THEN

Line 414: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

410: EXCEPTION
411: WHEN del_activity_err THEN
412: x_return_status := l_retn_status;
413: ROLLBACK to SAVEPOINT delete_activity;
414: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
415: P_data => x_message_list);
416: WHEN OTHERS THEN
417: ROLLBACK to SAVEPOINT delete_activity;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 421: FND_MSG_PUB.ADD;

417: ROLLBACK to SAVEPOINT delete_activity;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
420: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
421: FND_MSG_PUB.ADD;
422: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
423: P_data => x_message_list);
424:
425: END delete_activity;

Line 422: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
420: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
421: FND_MSG_PUB.ADD;
422: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
423: P_data => x_message_list);
424:
425: END delete_activity;
426: