APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_MESSAGE

Line 185: FND_MESSAGE.SET_NAME('GMA', 'GMA_NO_PARAGRAPH_EXIST');

181:
182: If NOT(l_Paragraph_exists) AND (l_para_count = 0) Then
183:
184: -- When no pragraph exists insert the following message
185: FND_MESSAGE.SET_NAME('GMA', 'GMA_NO_PARAGRAPH_EXIST');
186: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_attach_form_short_name,FALSE);
187: FND_MESSAGE.SET_TOKEN('TABLE_NAME',p_sy_para_cds_table_name,FALSE);
188: FND_MSG_PUB.ADD;
189:

Line 186: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_attach_form_short_name,FALSE);

182: If NOT(l_Paragraph_exists) AND (l_para_count = 0) Then
183:
184: -- When no pragraph exists insert the following message
185: FND_MESSAGE.SET_NAME('GMA', 'GMA_NO_PARAGRAPH_EXIST');
186: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_attach_form_short_name,FALSE);
187: FND_MESSAGE.SET_TOKEN('TABLE_NAME',p_sy_para_cds_table_name,FALSE);
188: FND_MSG_PUB.ADD;
189:
190: End if;

Line 187: FND_MESSAGE.SET_TOKEN('TABLE_NAME',p_sy_para_cds_table_name,FALSE);

183:
184: -- When no pragraph exists insert the following message
185: FND_MESSAGE.SET_NAME('GMA', 'GMA_NO_PARAGRAPH_EXIST');
186: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_attach_form_short_name,FALSE);
187: FND_MESSAGE.SET_TOKEN('TABLE_NAME',p_sy_para_cds_table_name,FALSE);
188: FND_MSG_PUB.ADD;
189:
190: End if;
191:

Line 194: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

190: End if;
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
195: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
197: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
198: FND_MSG_PUB.ADD;

Line 195: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
195: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
197: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
198: FND_MSG_PUB.ADD;
199:

Line 196: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
195: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
197: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
198: FND_MSG_PUB.ADD;
199:
200: RAISE;

Line 197: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
195: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
197: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
198: FND_MSG_PUB.ADD;
199:
200: RAISE;
201:

Line 248: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACHMENT_NOT_EXISTS');

244: WHEN NO_DATA_FOUND THEN
245: -- if no attachment functionality is assigned, then stop further text migration processing
246: p_attachment_function_id:=-1;
247:
248: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACHMENT_NOT_EXISTS');
249: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
250: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_attachment_function_id,FALSE);
251: FND_MSG_PUB.ADD;
252:

Line 249: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);

245: -- if no attachment functionality is assigned, then stop further text migration processing
246: p_attachment_function_id:=-1;
247:
248: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACHMENT_NOT_EXISTS');
249: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
250: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_attachment_function_id,FALSE);
251: FND_MSG_PUB.ADD;
252:
253: Raise;

Line 250: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_attachment_function_id,FALSE);

246: p_attachment_function_id:=-1;
247:
248: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACHMENT_NOT_EXISTS');
249: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
250: FND_MESSAGE.SET_TOKEN('ATTACHMENT_ID',p_attachment_function_id,FALSE);
251: FND_MSG_PUB.ADD;
252:
253: Raise;
254:

Line 256: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

252:
253: Raise;
254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
258: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
259: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
260: FND_MSG_PUB.ADD;

Line 257: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

253: Raise;
254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
258: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
259: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
260: FND_MSG_PUB.ADD;
261:

Line 258: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
258: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
259: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
260: FND_MSG_PUB.ADD;
261:
262: RAISE;

Line 259: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
258: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
259: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
260: FND_MSG_PUB.ADD;
261:
262: RAISE;
263:

Line 376: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

372: p_document_exist:=l_flag;
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
377: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
378: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
379: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
380: FND_MSG_PUB.ADD;

Line 377: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
377: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
378: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
379: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
380: FND_MSG_PUB.ADD;
381: RAISE;

Line 378: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

374: EXCEPTION
375: WHEN OTHERS THEN
376: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
377: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
378: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
379: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
380: FND_MSG_PUB.ADD;
381: RAISE;
382:

Line 379: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

375: WHEN OTHERS THEN
376: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
377: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
378: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
379: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
380: FND_MSG_PUB.ADD;
381: RAISE;
382:
383: End Check_Fnd_Document_Exists;

Line 435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');

431: EXCEPTION
432: WHEN NO_DATA_FOUND THEN
433:
434: -- if no PK columns defined for attachment functionality then ignore
435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');
436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);

Line 436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);

432: WHEN NO_DATA_FOUND THEN
433:
434: -- if no PK columns defined for attachment functionality then ignore
435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');
436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);

Line 437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);

433:
434: -- if no PK columns defined for attachment functionality then ignore
435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');
436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);
441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);

Line 438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);

434: -- if no PK columns defined for attachment functionality then ignore
435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');
436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);
441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);
442: FND_MSG_PUB.ADD;

Line 439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);

435: FND_MESSAGE.SET_NAME('GMA','GMA_ATTACH_COL_NOT_EXISTS');
436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);
441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);
442: FND_MSG_PUB.ADD;
443:

Line 440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);

436: FND_MESSAGE.SET_TOKEN('FORM_NAME',p_form_short_name,FALSE);
437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);
441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);
442: FND_MSG_PUB.ADD;
443:
444:

Line 441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);

437: FND_MESSAGE.SET_TOKEN('pk1_value',p_pk1_value,FALSE);
438: FND_MESSAGE.SET_TOKEN('pk2_value',p_pk2_value,FALSE);
439: FND_MESSAGE.SET_TOKEN('pk3_value',p_pk3_value,FALSE);
440: FND_MESSAGE.SET_TOKEN('pk4_value',p_pk4_value,FALSE);
441: FND_MESSAGE.SET_TOKEN('pk5_value',p_pk5_value,FALSE);
442: FND_MSG_PUB.ADD;
443:
444:
445: WHEN OTHERS THEN

Line 446: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

442: FND_MSG_PUB.ADD;
443:
444:
445: WHEN OTHERS THEN
446: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
447: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
448: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
450: FND_MSG_PUB.ADD;

Line 447: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

443:
444:
445: WHEN OTHERS THEN
446: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
447: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
448: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
450: FND_MSG_PUB.ADD;
451:

Line 448: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

444:
445: WHEN OTHERS THEN
446: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
447: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
448: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
450: FND_MSG_PUB.ADD;
451:
452: RAISE;

Line 449: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

445: WHEN OTHERS THEN
446: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
447: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
448: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
449: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
450: FND_MSG_PUB.ADD;
451:
452: RAISE;
453:

Line 549: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

545:
546: Exception
547: WHEN OTHERS THEN
548:
549: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
550: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
551: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
553: FND_MSG_PUB.ADD;

Line 550: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

546: Exception
547: WHEN OTHERS THEN
548:
549: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
550: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
551: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
553: FND_MSG_PUB.ADD;
554:

Line 551: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

547: WHEN OTHERS THEN
548:
549: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
550: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
551: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
553: FND_MSG_PUB.ADD;
554:
555:

Line 552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

548:
549: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
550: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
551: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
552: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
553: FND_MSG_PUB.ADD;
554:
555:
556: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

Line 674: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_CREATED');

670:
671: p_category_exists:=-1;
672: p_category_id:=l_category_id;
673:
674: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_CREATED');
675: FND_MESSAGE.SET_TOKEN('category_name',p_category_name,FALSE);
676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);
677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN

Line 675: FND_MESSAGE.SET_TOKEN('category_name',p_category_name,FALSE);

671: p_category_exists:=-1;
672: p_category_id:=l_category_id;
673:
674: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_CREATED');
675: FND_MESSAGE.SET_TOKEN('category_name',p_category_name,FALSE);
676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);
677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

Line 676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);

672: p_category_id:=l_category_id;
673:
674: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_CREATED');
675: FND_MESSAGE.SET_TOKEN('category_name',p_category_name,FALSE);
676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);
677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

Line 679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

675: FND_MESSAGE.SET_TOKEN('category_name',p_category_name,FALSE);
676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);
677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
682: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
683: FND_MSG_PUB.ADD;

Line 680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

676: FND_MESSAGE.SET_TOKEN('category_id',l_category_id,FALSE);
677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
682: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
683: FND_MSG_PUB.ADD;
684:

Line 681: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

677: FND_MSG_PUB.ADD;
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
682: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
683: FND_MSG_PUB.ADD;
684:
685: RAISE;

Line 682: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
682: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
683: FND_MSG_PUB.ADD;
684:
685: RAISE;
686:

Line 747: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_USAGE_ID_CREATED');

743: l_user_id,
744: l_user_id);
745:
746: p_category_usage_exists:=-1;
747: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_USAGE_ID_CREATED');
748: FND_MESSAGE.SET_TOKEN('category_usage_id',l_doc_category_usage_id,FALSE);
749: FND_MESSAGE.SET_TOKEN('category_id',p_category_id,FALSE);
750: FND_MSG_PUB.ADD;
751:

Line 748: FND_MESSAGE.SET_TOKEN('category_usage_id',l_doc_category_usage_id,FALSE);

744: l_user_id);
745:
746: p_category_usage_exists:=-1;
747: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_USAGE_ID_CREATED');
748: FND_MESSAGE.SET_TOKEN('category_usage_id',l_doc_category_usage_id,FALSE);
749: FND_MESSAGE.SET_TOKEN('category_id',p_category_id,FALSE);
750: FND_MSG_PUB.ADD;
751:
752: WHEN OTHERS THEN

Line 749: FND_MESSAGE.SET_TOKEN('category_id',p_category_id,FALSE);

745:
746: p_category_usage_exists:=-1;
747: FND_MESSAGE.SET_NAME('GMA','GMA_CATEGORY_USAGE_ID_CREATED');
748: FND_MESSAGE.SET_TOKEN('category_usage_id',l_doc_category_usage_id,FALSE);
749: FND_MESSAGE.SET_TOKEN('category_id',p_category_id,FALSE);
750: FND_MSG_PUB.ADD;
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

Line 753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

749: FND_MESSAGE.SET_TOKEN('category_id',p_category_id,FALSE);
750: FND_MSG_PUB.ADD;
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
754: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
755: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
756: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
757: FND_MSG_PUB.ADD;

Line 754: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

750: FND_MSG_PUB.ADD;
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
754: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
755: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
756: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
757: FND_MSG_PUB.ADD;
758:

Line 755: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
754: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
755: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
756: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
757: FND_MSG_PUB.ADD;
758:
759: RAISE;

Line 756: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
754: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
755: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
756: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
757: FND_MSG_PUB.ADD;
758:
759: RAISE;
760:

Line 895: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

891: );
892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
897: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
898: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
899: FND_MSG_PUB.ADD;

Line 896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
897: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
898: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
899: FND_MSG_PUB.ADD;
900:

Line 897: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

893: EXCEPTION
894: WHEN OTHERS THEN
895: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
897: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
898: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
899: FND_MSG_PUB.ADD;
900:
901: RAISE;

Line 898: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

894: WHEN OTHERS THEN
895: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
896: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
897: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
898: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
899: FND_MSG_PUB.ADD;
900:
901: RAISE;
902:

Line 1012: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

1008: end if;
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1014: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1016: FND_MSG_PUB.ADD;

Line 1013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1014: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1016: FND_MSG_PUB.ADD;
1017: RAISE;

Line 1014: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1014: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1016: FND_MSG_PUB.ADD;
1017: RAISE;
1018: End Create_Fnd_Short_Text;

Line 1015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1013: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1014: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1015: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1016: FND_MSG_PUB.ADD;
1017: RAISE;
1018: End Create_Fnd_Short_Text;
1019:

Line 1063: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');

1059:
1060: Exception
1061: WHEN OTHERS THEN
1062:
1063: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1065: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1067: FND_MSG_PUB.ADD;

Line 1064: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);

1060: Exception
1061: WHEN OTHERS THEN
1062:
1063: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1065: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1067: FND_MSG_PUB.ADD;
1068:

Line 1065: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');

1061: WHEN OTHERS THEN
1062:
1063: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1065: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1067: FND_MSG_PUB.ADD;
1068:
1069: RAISE;

Line 1066: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);

1062:
1063: FND_MESSAGE.SET_NAME('FND', 'FND_AS_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
1065: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GMA_EDITEXT_ATTACH_MIG');
1066: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', l_api_name);
1067: FND_MSG_PUB.ADD;
1068:
1069: RAISE;
1070: