eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMP_APS_WRITER dependencies on FND_MSG_PUB

Line 229: fnd_msg_pub.initialize;

225: -- find out the last collection
226: orig_last_update_date := p_creation_date;
227:
228: -- Initialize message list
229: fnd_msg_pub.initialize;
230:
231: /* Set the savepoint before proceeding */
232: SAVEPOINT Before_Main_Program ;
233:

Line 243: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

239: AND header_id = p_header_id ;
240: EXCEPTION
241: WHEN OTHERS THEN
242: gmp_debug_message(' gmp_aps_writer failed at firm_flag selection ');
243: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
244: e_msg := e_msg || ' Main Porgam Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
245: return_status := -131 ;
246: return_msg := e_msg ;
247: END;

Line 272: fnd_msg_pub.add ;

268:
269: IF (batch_last_update > orig_last_update_date) AND
270: (p_action_type <> 1) THEN
271: fnd_message.set_name('GMP','GMP_BATCH_HEADER_CHANGED');
272: fnd_msg_pub.add ;
273: e_msg := e_msg || ' Batch header is changed.';
274: breturn_status := -1 ;
275: ELSIF (p_start_date < sysdate AND p_action_type = 1) THEN
276: fnd_message.set_name('GMP','GMP_BATCH_START_DATE_PAST_DUE');

Line 277: fnd_msg_pub.add ;

273: e_msg := e_msg || ' Batch header is changed.';
274: breturn_status := -1 ;
275: ELSIF (p_start_date < sysdate AND p_action_type = 1) THEN
276: fnd_message.set_name('GMP','GMP_BATCH_START_DATE_PAST_DUE');
277: fnd_msg_pub.add ;
278: e_msg := e_msg || ' New Batch start date is past due.' ;
279: breturn_status := -1 ;
280: ELSIF (t_batch_status > 2 OR t_batch_status <= 0) AND
281: (p_action_type <> 1) THEN

Line 283: fnd_msg_pub.add ;

279: breturn_status := -1 ;
280: ELSIF (t_batch_status > 2 OR t_batch_status <= 0) AND
281: (p_action_type <> 1) THEN
282: fnd_message.set_name('GMP','GMP_BATCH_STATUS_NOT_PENDING');
283: fnd_msg_pub.add ;
284: e_msg := e_msg || ' Batch is not in pending.' ;
285: breturn_status := -1 ;
286: ELSE
287: update_batch_header(

Line 374: fnd_msg_pub.add ;

370: IF p_action_type <> 1 THEN
371:
372: IF operation_tab(oper_cnt).batchstep_id = 0 THEN
373: fnd_message.set_name('GMP','GMP_OPER_DELETED');
374: fnd_msg_pub.add ;
375: e_msg := e_msg || ' Operation deleted.';
376: sreturn_status := -1 ;
377: EXIT ;
378: ELSIF (operation_tab(oper_cnt).gme_oper_count <>

Line 381: fnd_msg_pub.add ;

377: EXIT ;
378: ELSIF (operation_tab(oper_cnt).gme_oper_count <>
379: operation_tab(oper_cnt).aps_oper_count) THEN
380: fnd_message.set_name('GMP','GMP_NUMBER_OF_OPER_MISMATCH');
381: fnd_msg_pub.add ;
382: e_msg := e_msg || ' Number of operation does not match.';
383: sreturn_status := -1 ;
384: EXIT ;
385: ELSIF (operation_tab(oper_cnt).bo_last_update < 0) AND

Line 390: fnd_msg_pub.add ;

386: (operation_tab(oper_cnt).step_status = 1) THEN
387: -- If step is in pending and last update changed, We are not
388: -- Updating the batch
389: fnd_message.set_name('GMP','GMP_BATCH_STEP_CHANGED');
390: fnd_msg_pub.add ;
391: e_msg := e_msg || ' Pending Step/Operation is changed.' ;
392: sreturn_status := -1 ;
393: EXIT;
394: ELSIF (operation_tab(oper_cnt).first_unit_start_date < sysdate) AND

Line 399: fnd_msg_pub.add ;

395: (operation_tab(oper_cnt).step_status = 1) AND t_batch_status = 2 THEN
396: -- For WIP batch, step is pending and step start date is past due,
397: -- We are not Updating the batch
398: fnd_message.set_name('GMP','GMP_STEP_PAST_DUE');
399: fnd_msg_pub.add ;
400: e_msg := e_msg || ' WIP batch, Pending Step is past due.' ;
401: sreturn_status := -1 ;
402: EXIT;
403: ELSE

Line 442: fnd_msg_pub.add ;

438: END IF;
439:
440: IF sreturn_status < 0 THEN
441: fnd_message.set_name('GMP','GMP_STEP_UPDATE_FAILED');
442: fnd_msg_pub.add ;
443: e_msg := e_msg || ' Failed: Update to Step/Operation' ;
444: EXIT;
445: END IF ;
446: ELSE

Line 460: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

456: AND group_id = p_group_id
457: AND parent_header_id = p_header_id ;
458: EXCEPTION
459: WHEN OTHERS THEN
460: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
461: e_msg := e_msg || ' WIP/completed step: '||TO_CHAR(SQLCODE)||': '||SQLERRM ;
462: sreturn_status := -1 ;
463: EXIT;
464: END;

Line 495: fnd_msg_pub.add ;

491: breturn_status);
492:
493: IF breturn_status < 0 THEN
494: fnd_message.set_name('GMP','GMP_STEP_UPDATE_FAILED');
495: fnd_msg_pub.add ;
496: e_msg := e_msg || ' Failed: Update to Batch End Date' ;
497: sreturn_status := -1 ;
498: ELSE
499: log_message(' SET Batch End Date to Maximum of Step End Date ');

Line 538: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

534: EXCEPTION
535: WHEN NO_DATA_FOUND THEN
536: null;
537: WHEN OTHERS THEN
538: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
539: e_msg := e_msg || ' Attribute9: '||TO_CHAR(SQLCODE)||': '||SQLERRM ;
540: sreturn_status := -1 ;
541: END ;
542:

Line 818: fnd_msg_pub.add ;

814: or_tab(or_cnt).aps_rsrc_count);
815:
816: IF or_tab(or_cnt).Aoperation_seq_num = 0 THEN
817: fnd_message.set_name('GMP','GMP_OPERATION_CHANGED');
818: fnd_msg_pub.add ;
819: e_msg := e_msg || ' Operation Changed. ';
820: batch_valid := -1 ;
821: EXIT ;
822: ELSIF or_tab(or_cnt).Aschedule_seq_num = 0 THEN -- For R12.0

Line 824: fnd_msg_pub.add ;

820: batch_valid := -1 ;
821: EXIT ;
822: ELSIF or_tab(or_cnt).Aschedule_seq_num = 0 THEN -- For R12.0
823: fnd_message.set_name('GMP','GMP_ACTIVITY_CHANGED');
824: fnd_msg_pub.add ;
825: e_msg := e_msg || ' Activity Changed.';
826: batch_valid := -1 ;
827: EXIT ;
828: ELSIF or_tab(or_cnt).gme_actv_count <>

Line 831: fnd_msg_pub.add ;

827: EXIT ;
828: ELSIF or_tab(or_cnt).gme_actv_count <>
829: or_tab(or_cnt).aps_actv_count THEN
830: fnd_message.set_name('GMP','GMP_ACTV_CNT_MISMATCH');
831: fnd_msg_pub.add ;
832: e_msg := e_msg || ' Number of activities does not match.';
833: batch_valid := -1 ;
834: EXIT ;
835:

Line 839: fnd_msg_pub.add ;

835:
836: ELSIF or_tab(or_cnt).gme_rsrc_count <>
837: or_tab(or_cnt).aps_rsrc_count THEN
838: fnd_message.set_name('GMP','GMP_RSRC_CNT_MISMATCH');
839: fnd_msg_pub.add ;
840: e_msg := e_msg || ' Number of resources does not match.';
841: batch_valid := -1 ;
842: EXIT ;
843: ELSIF or_tab(or_cnt).bsa_lup < 0 THEN

Line 845: fnd_msg_pub.add ;

841: batch_valid := -1 ;
842: EXIT ;
843: ELSIF or_tab(or_cnt).bsa_lup < 0 THEN
844: fnd_message.set_name('GMP','GMP_ACTIVITY_CHANGED');
845: fnd_msg_pub.add ;
846: e_msg := e_msg || ' Activity updated.';
847: batch_valid := -1 ;
848: EXIT ;
849: ELSIF or_tab(or_cnt).bsr_lup < 0 THEN

Line 851: fnd_msg_pub.add ;

847: batch_valid := -1 ;
848: EXIT ;
849: ELSIF or_tab(or_cnt).bsr_lup < 0 THEN
850: fnd_message.set_name('GMP','GMP_ACT_RSRC_CHANGED');
851: fnd_msg_pub.add ;
852: e_msg := e_msg || ' Activity Resource changed.';
853: batch_valid := -1 ;
854: EXIT ;
855: ELSE

Line 1035: fnd_msg_pub.add ;

1031: rreturn_status );
1032:
1033: IF rreturn_status < 0 THEN
1034: fnd_message.set_name('GMP','GMP_STEP_RESOURCE_FAILED');
1035: fnd_msg_pub.add ;
1036: e_msg := e_msg || ' Step Resource failed: GME way' ;
1037: log_message(e_msg) ;
1038: EXIT;
1039: END IF ; /* rreturn_status */

Line 1070: fnd_msg_pub.add ;

1066: rreturn_status );
1067:
1068: IF rreturn_status < 0 THEN
1069: fnd_message.set_name('GMP','GMP_STEP_RESOURCE_FAILED');
1070: fnd_msg_pub.add ;
1071: e_msg := e_msg || ' Step Resource failed:APS Way' ;
1072: log_message(e_msg) ;
1073: EXIT;
1074: ELSE

Line 1124: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

1120: END IF; /* action type */
1121:
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
1125: e_msg := e_msg || ' Transactions: '||TO_CHAR(SQLCODE)||': '||SQLERRM;
1126: rreturn_status := -13 ;
1127: EXIT;
1128: END;

Line 1155: fnd_msg_pub.add ;

1151: areturn_status);
1152:
1153: IF areturn_status < 0 THEN
1154: fnd_message.set_name('GMP','GMP_ACTIVITY_UPDATE_FAIL');
1155: fnd_msg_pub.add ;
1156: e_msg := e_msg || ' Update to Activities is failed' ;
1157: log_message(e_msg) ;
1158: EXIT;
1159: END IF ;

Line 1194: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN
1192: NULL ;
1193: WHEN OTHERS THEN
1194: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
1195: e_msg := e_msg || ' WIP/completed step: '||TO_CHAR(SQLCODE)||': '||SQLERRM ;
1196: areturn_status := -1 ;
1197: END;
1198:

Line 1303: fnd_msg_pub.add ;

1299: rtran_cnt := rtran_cnt + 1;
1300:
1301: IF treturn_status < 0 THEN
1302: fnd_message.set_name('GMP','GMP_RSRC_TRANS_UPDATE_FAIL');
1303: fnd_msg_pub.add ;
1304: e_msg := e_msg || ' Update to Resource Transaction is failed' ;
1305: EXIT;
1306: END IF ;
1307:

Line 1324: fnd_msg_pub.add ;

1320: mreturn_status) ;
1321:
1322: IF mreturn_status < 0 THEN
1323: fnd_message.set_name('GMP','GMP_MATL_UPDATE_FAIL');
1324: fnd_msg_pub.add ;
1325: e_msg := e_msg || ' Materail Update is failed' ;
1326: END IF ;
1327: END IF ;
1328:

Line 1337: fnd_msg_pub.add ;

1333: xreturn_status) ;
1334:
1335: IF xreturn_status < 0 THEN
1336: fnd_message.set_name('GMP','GMP_RSRC_CHRGS_UPDATE_FAIL');
1337: fnd_msg_pub.add ;
1338: e_msg := e_msg || ' Charges Insert is failed' ;
1339: END IF ;
1340:
1341: END IF; /* end if for areturn_status */

Line 1392: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');

1388: return_msg := e_msg ;
1389:
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_msg_pub.add_exc_msg('gmp_aps_writer','main_process');
1393: e_msg := e_msg || ' Main Porgam Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
1394: return_status := -99 ;
1395: return_msg := e_msg ;
1396: END main_process ;

Line 1585: fnd_msg_pub.add ;

1581: --Bug # 12814212 vkinduri end
1582: IF (temp_date > v_end_date) THEN
1583: return_status := -3;
1584: fnd_message.set_name('GMP','GMP_SEND_GREATER_START');
1585: fnd_msg_pub.add ;
1586: e_msg := e_msg || ' Step End date greater than start date.';
1587:
1588: END IF;
1589:

Line 1636: fnd_msg_pub.add ;

1632: tran_status );
1633:
1634: IF tran_status < 0 THEN
1635: fnd_message.set_name('GMP','GMP_RSRC_TRANS_UPDATE_FAIL');
1636: fnd_msg_pub.add ;
1637: e_msg := e_msg || ' Failed: Resource Transaction' ;
1638: return_status := -6 ;
1639: EXIT;
1640: ELSE

Line 1650: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_step_resources');

1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: return_status := -96;
1650: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_step_resources');
1651: e_msg := e_msg || ' Update Step Resources Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
1652: END update_step_resources;
1653:
1654: /*

Line 1733: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_resource_transactions');

1729:
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: return_status := -97;
1733: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_resource_transactions');
1734: e_msg := e_msg || ' Update SResource Transaction Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
1735: END update_resource_transactions;
1736:
1737: /*

Line 1948: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_activities');

1944: END IF; /* Not found */
1945: EXCEPTION
1946: WHEN OTHERS THEN
1947: return_status := -98;
1948: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_activities');
1949: e_msg := e_msg || ' Update Step Activities Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
1950: END update_batch_activities;
1951:
1952: /*

Line 2025: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_materails');

2021: CLOSE get_step_material;
2022: EXCEPTION
2023: WHEN OTHERS THEN
2024: return_status := -89;
2025: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_materails');
2026: e_msg := e_msg || ' Update Materails Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2027: END update_materails;
2028:
2029: /*

Line 2076: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_steps');

2072: WHEN NO_DATA_FOUND THEN
2073: v_plan_charges := 0;
2074: WHEN OTHERS THEN
2075: return_status := -995;
2076: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_steps');
2077: e_msg := e_msg || ' CHARGE in Step Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2078: END;
2079:
2080: IF pdue_date IS NOT NULL THEN

Line 2149: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_steps');

2145:
2146: EXCEPTION
2147: WHEN OTHERS THEN
2148: return_status := -95;
2149: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_steps');
2150: e_msg := e_msg || ' Update Batch Step Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2151: END update_batch_steps;
2152:
2153: /*

Line 2223: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_header');

2219:
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: return_status := -94;
2223: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_batch_header');
2224: e_msg := e_msg || ' Update Batch Header Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2225: END update_batch_header;
2226:
2227: /*

Line 2355: fnd_msg_pub.add_exc_msg('gmp_aps_writer','lock_batch_details');

2351:
2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: return_status := -92;
2355: fnd_msg_pub.add_exc_msg('gmp_aps_writer','lock_batch_details');
2356: e_msg := e_msg || ' Loocking Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2357: END lock_batch_details;
2358:
2359: /*

Line 2580: fnd_msg_pub.add ;

2576: gmp_debug_message(' Inside validate_structure Loop '||structure_size||' aps_resource_seq_num '||structure_tab(structure_size).aps_resource_seq_num|| ' aps_resource_seq_num '|| structure_tab(structure_size).aps_resource_seq_num );
2577:
2578: IF structure_tab(structure_size).recipe_change < 0 THEN
2579: fnd_message.set_name('GMP','GMP_RECIPE_CHANGED');
2580: fnd_msg_pub.add ;
2581: e_msg := e_msg || ' Recipe is Changed';
2582: return_status := -1 ;
2583: EXIT ;
2584:

Line 2587: fnd_msg_pub.add ;

2583: EXIT ;
2584:
2585: ELSIF structure_tab(structure_size).validity_rule_change < 0 THEN
2586: fnd_message.set_name('GMP','GMP_RECIPE_VR_CHANGED');
2587: fnd_msg_pub.add ;
2588: e_msg := e_msg || ' Recipe/Validity Rule changed' ;
2589: return_status := -1 ;
2590: EXIT ;
2591:

Line 2594: fnd_msg_pub.add ;

2590: EXIT ;
2591:
2592: ELSIF structure_tab(structure_size).formula_header_change < 0 THEN
2593: fnd_message.set_name('GMP','GMP_FORMULA_CHANGED');
2594: fnd_msg_pub.add ;
2595: e_msg := e_msg || ' Formula Header/detail is Changed ';
2596: return_status := -1 ;
2597: EXIT ;
2598:

Line 2601: fnd_msg_pub.add ;

2597: EXIT ;
2598:
2599: ELSIF structure_tab(structure_size).formula_detail_change < 0 THEN
2600: fnd_message.set_name('GMP','GMP_FORMULA_CHANGED');
2601: fnd_msg_pub.add ;
2602: e_msg := e_msg || ' Formula Header/detail is Changed ';
2603: return_status := -1 ;
2604: EXIT ;
2605:

Line 2608: fnd_msg_pub.add ;

2604: EXIT ;
2605:
2606: ELSIF structure_tab(structure_size).routing_header_change < 0 THEN
2607: fnd_message.set_name('GMP','GMP_ROUTING_CHANGED');
2608: fnd_msg_pub.add ;
2609: e_msg := e_msg || ' Routing Header is changed';
2610: return_status := -1 ;
2611: EXIT ;
2612:

Line 2615: fnd_msg_pub.add ;

2611: EXIT ;
2612:
2613: ELSIF structure_tab(structure_size).routingstep_no IS NULL THEN
2614: fnd_message.set_name('GMP','GMP_ROUTING_ACT_CHANGED');
2615: fnd_msg_pub.add ;
2616: e_msg := e_msg || ' Routing Opeartion/Activity deleted';
2617: return_status := -1 ;
2618: EXIT ;
2619: ELSIF (structure_tab(structure_size).opm_resource_change <>

Line 2622: fnd_msg_pub.add ;

2618: EXIT ;
2619: ELSIF (structure_tab(structure_size).opm_resource_change <>
2620: structure_tab(structure_size).aps_resource_sum) THEN
2621: fnd_message.set_name('GMP','GMP_RSRC_MISMATCH');
2622: fnd_msg_pub.add ;
2623: e_msg := e_msg || ' Routing resources added or deleted. Details of the batch will NOT be synchronized.' ;
2624: return_status := -1 ;
2625: EXIT ;
2626: ELSIF (structure_tab(structure_size).opm_oper_sum <>

Line 2629: fnd_msg_pub.add ;

2625: EXIT ;
2626: ELSIF (structure_tab(structure_size).opm_oper_sum <>
2627: structure_tab(structure_size).aps_oper_sum ) THEN
2628: fnd_message.set_name('GMP','GMP_OPERATION_MISMATCH');
2629: fnd_msg_pub.add ;
2630: e_msg := e_msg || ' Routing steps added or deleted. Details of the batch will NOT be synchronized.' ;
2631: return_status := -1 ;
2632: EXIT ;
2633: ELSIF (structure_tab(structure_size).opm_activity_sum <>

Line 2636: fnd_msg_pub.add ;

2632: EXIT ;
2633: ELSIF (structure_tab(structure_size).opm_activity_sum <>
2634: structure_tab(structure_size).aps_activity_sum) THEN
2635: fnd_message.set_name('GMP','GMP_ACTIVITY_MISMATCH');
2636: fnd_msg_pub.add ;
2637: e_msg := e_msg || ' Routing activity added or deleted. Details of the batch will NOT be synchronized.' ;
2638: return_status := -1 ;
2639: EXIT ;
2640: ELSIF (structure_tab(structure_size).rtg_detail_change < 0) THEN

Line 2642: fnd_msg_pub.add ;

2638: return_status := -1 ;
2639: EXIT ;
2640: ELSIF (structure_tab(structure_size).rtg_detail_change < 0) THEN
2641: fnd_message.set_name('GMP','GMP_OPERATION_CHANGED');
2642: fnd_msg_pub.add ;
2643: e_msg := e_msg || ' Details of a step have changed. Details of the batch will NOT be synchronized.' ;
2644: return_status := -1 ;
2645: EXIT ;
2646: ELSIF (structure_tab(structure_size).rtg_oper_change < 0) THEN

Line 2648: fnd_msg_pub.add ;

2644: return_status := -1 ;
2645: EXIT ;
2646: ELSIF (structure_tab(structure_size).rtg_oper_change < 0) THEN
2647: fnd_message.set_name('GMP','GMP_OPERATION_CHANGED');
2648: fnd_msg_pub.add ;
2649: e_msg := e_msg || ' Details of a step have changed. Details of the batch will NOT be synchronized.' ;
2650: return_status := -1 ;
2651: EXIT ;
2652: ELSIF (structure_tab(structure_size).rtg_activity_change < 0) THEN

Line 2654: fnd_msg_pub.add ;

2650: return_status := -1 ;
2651: EXIT ;
2652: ELSIF (structure_tab(structure_size).rtg_activity_change < 0) THEN
2653: fnd_message.set_name('GMP','GMP_ROUTING_ACT_CHANGED');
2654: fnd_msg_pub.add ;
2655: e_msg := e_msg || ' An activity in the routing has changed. Details of the batch will NOT be synchronized.';
2656: return_status := -1 ;
2657: EXIT ;
2658: ELSIF (structure_tab(structure_size).opm_resource_change < 0) THEN

Line 2661: fnd_msg_pub.add ;

2657: EXIT ;
2658: ELSIF (structure_tab(structure_size).opm_resource_change < 0) THEN
2659: -- MEssage is OK
2660: fnd_message.set_name('GMP','GMP_ROUTING_CHANGED2');
2661: fnd_msg_pub.add ;
2662: e_msg := e_msg || ' Routing resources have changed. Details of the batch will NOT be synchronized.' ;
2663: return_status := -1 ;
2664: EXIT ;
2665: ELSE

Line 2681: fnd_msg_pub.add_exc_msg('gmp_aps_writer','valildate_structure');

2677: struc_size := structure_size ; /*B3583620 */
2678: EXCEPTION
2679: WHEN OTHERS THEN
2680: return_status := -91;
2681: fnd_msg_pub.add_exc_msg('gmp_aps_writer','valildate_structure');
2682: e_msg := e_msg || ' Validation Failure '||TO_CHAR(SQLCODE) || ': '||SQLERRM;
2683: END validate_structure ;
2684:
2685: /*

Line 2724: fnd_msg_pub.add_exc_msg('gmp_aps_writer','time_stamp');

2720:
2721: log_message(cur_time);
2722: EXCEPTION
2723: WHEN OTHERS THEN
2724: fnd_msg_pub.add_exc_msg('gmp_aps_writer','time_stamp');
2725: e_msg := e_msg || ' time_stamp Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2726: END time_stamp ;
2727:
2728: /*

Line 2853: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_activity_offsets');

2849: COMMIT;
2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: fnd_msg_pub.add_exc_msg('gmp_aps_writer','update_activity_offsets');
2854: e_msg := e_msg || ' update_activity_offsets Failure '|| TO_CHAR(SQLCODE)
2855: ||': '||SQLERRM;
2856:
2857: END update_activity_offsets;

Line 2932: fnd_msg_pub.add_exc_msg('gmp_aps_writer','Insert_charges');

2928: WHEN NO_DATA_FOUND THEN
2929: NULL ;
2930: WHEN OTHERS THEN
2931: return_status := -90;
2932: fnd_msg_pub.add_exc_msg('gmp_aps_writer','Insert_charges');
2933: e_msg := e_msg || ' Delete Charge Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
2934: END ;
2935:
2936: -- WIP steps needs to be populated with activity_seq Number

Line 3011: fnd_msg_pub.add_exc_msg('gmp_aps_writer','Insert_charges');

3007: WHEN NO_DATA_FOUND THEN
3008: return_status := 1 ;
3009: WHEN OTHERS THEN
3010: return_status := -90;
3011: fnd_msg_pub.add_exc_msg('gmp_aps_writer','Insert_charges');
3012: e_msg := e_msg || ' Insert_charges Failure '||TO_CHAR(SQLCODE)||': '||SQLERRM;
3013: END Insert_charges ;
3014:
3015: /*