DBA Data[Home] [Help]

APPS.GMD_ACTIVITIES_PUB dependencies on FND_MESSAGE

Line 108: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

104: IF p_activity_tbl(i).activity IS NULL THEN
105: IF (l_debug = 'Y') THEN
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;

Line 109: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');

105: IF (l_debug = 'Y') THEN
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:

Line 121: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

117: IF (l_debug = 'Y') THEN
118: gmd_debug.put_line('cost analysis required');
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

Line 122: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');

118: gmd_debug.put_line('cost analysis required');
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

Line 127: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_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');
128: FND_MSG_PUB.ADD;
129: x_return_status := FND_API.g_ret_sts_error;
130: END IF;
131: END IF;

Line 138: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

134: IF p_activity_tbl(i).activity_desc IS NULL THEN
135: IF (l_debug = 'Y') THEN
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;

Line 139: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');

135: IF (l_debug = 'Y') THEN
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:

Line 180: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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;
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);

Line 181: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

177: WHEN OTHERS THEN
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;

Line 258: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

254: IF p_activity IS NULL THEN
255: IF (l_debug = 'Y') THEN
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

Line 259: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');

255: IF (l_debug = 'Y') THEN
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 */

Line 277: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

273: /* Loop thru cols to be updated - verify col and value are present */
274: FOR i in 1 .. p_update_table.count LOOP
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

Line 278: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');

274: FOR i in 1 .. p_update_table.count LOOP
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');

Line 282: 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');
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

Line 283: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');

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');
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,

Line 290: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');

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);
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

Line 296: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

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
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;

Line 297: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');

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
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

Line 303: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

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
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

Line 304: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');

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
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

Line 309: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_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');
310: FND_MSG_PUB.ADD;
311: x_return_status := FND_API.g_ret_sts_error;
312: END IF;
313: END IF;

Line 352: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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;
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);

Line 353: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

349: WHEN OTHERS THEN
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:

Line 419: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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;
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);

Line 420: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

416: WHEN OTHERS THEN
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: