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.GMS_POR_API dependencies on GMS_ERROR_PKG

Line 60: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_number','C');

56: g_error_procedure_name := 'get_award_number';
57:
58: --Added debug messages for the bug 12901042
59: IF g_debug = 'Y' THEN
60: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_number','C');
61: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
62: END IF;
63:
64: --End for the bug 12901042

Line 61: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

57:
58: --Added debug messages for the bug 12901042
59: IF g_debug = 'Y' THEN
60: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_number','C');
61: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
62: END IF;
63:
64: --End for the bug 12901042
65: -- ==============================================================

Line 75: gms_error_pkg.gms_debug (g_error_procedure_name||' Finding Award_number based on award_id','C');

71: END IF ;
72:
73: --Added debug messages for the bug 12901042
74: IF g_debug = 'Y' THEN
75: gms_error_pkg.gms_debug (g_error_procedure_name||' Finding Award_number based on award_id','C');
76: END IF;
77: --End for the bug 12901042
78:
79: IF X_award_id is not NULL THEN

Line 123: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

119:
120: END IF ;
121:
122: IF g_debug = 'Y' THEN
123: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
124: END IF;
125:
126: return(l_award_number) ;
127: END get_award_number ;

Line 175: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_ID','C');

171: g_error_procedure_name := 'get_award_ID';
172:
173: --Added debug messages for the bug 12901042
174: IF g_debug = 'Y' THEN
175: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_ID','C');
176: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
177: END IF;
178: --End for the bug 12901042
179:

Line 176: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

172:
173: --Added debug messages for the bug 12901042
174: IF g_debug = 'Y' THEN
175: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_ID','C');
176: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
177: END IF;
178: --End for the bug 12901042
179:
180: -- ==============================================================

Line 190: gms_error_pkg.gms_debug (g_error_procedure_name||' Finding award_id based on Award_number','C');

186: END IF ;
187:
188: --Added debug messages for the bug 12901042
189: IF g_debug = 'Y' THEN
190: gms_error_pkg.gms_debug (g_error_procedure_name||' Finding award_id based on Award_number','C');
191: END IF;
192: --End for the bug 12901042
193:
194: IF X_award_number is not NULL THEN

Line 242: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

238:
239: END IF ;
240:
241: IF g_debug = 'Y' THEN
242: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
243: END IF;
244:
245: return (l_award_id) ;
246: end get_award_ID ;

Line 269: gms_error_pkg.gms_debug ('Inside GMS_POR_API.IS_SPONSORED_PROJECT','C');

265: g_error_procedure_name := 'IS_SPONSORED_PROJECT';
266:
267: --Added debug messages for the bug 12901042
268: IF g_debug = 'Y' THEN
269: gms_error_pkg.gms_debug ('Inside GMS_POR_API.IS_SPONSORED_PROJECT','C');
270: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
271: END IF;
272: --End for the bug 12901042
273:

Line 270: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

266:
267: --Added debug messages for the bug 12901042
268: IF g_debug = 'Y' THEN
269: gms_error_pkg.gms_debug ('Inside GMS_POR_API.IS_SPONSORED_PROJECT','C');
270: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
271: END IF;
272: --End for the bug 12901042
273:
274: x_return := FALSE ;

Line 285: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

281: x_return := TRUE ;
282: END IF ;
283:
284: IF g_debug = 'Y' THEN
285: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
286: END IF;
287:
288: return x_return ;
289:

Line 349: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_award','C');

345: g_error_procedure_name := 'validate_award';
346:
347: --Added debug messages for the bug 12901042
348: IF g_debug = 'Y' THEN
349: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_award','C');
350: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
351: END IF;
352: --End for the bug 12901042
353:

Line 350: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

346:
347: --Added debug messages for the bug 12901042
348: IF g_debug = 'Y' THEN
349: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_award','C');
350: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
351: END IF;
352: --End for the bug 12901042
353:
354: l_status := X_status ;

Line 520: gms_error_pkg.gms_debug (g_error_procedure_name||' Before calling gms_transactions_pub.validate_transaction','C');

516: -- gms_transaction_pub.
517:
518: --Added debug messages for the bug 12901042
519: IF g_debug = 'Y' THEN
520: gms_error_pkg.gms_debug (g_error_procedure_name||' Before calling gms_transactions_pub.validate_transaction','C');
521: END IF;
522: --End for the bug 12901042
523:
524: gms_transactions_pub.validate_transaction(p_project_id => X_project_id,

Line 534: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling gms_transactions_pub.validate_transaction','C');

530: p_outcome => X_err_msg );
531:
532: --Added debug messages for the bug 12901042
533: IF g_debug = 'Y' THEN
534: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling gms_transactions_pub.validate_transaction','C');
535: END IF;
536: --End for the bug 12901042
537:
538: if X_err_msg is NOT NULL then

Line 548: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

544:
545: x_status := l_status ;
546:
547: IF g_debug = 'Y' THEN
548: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
549: END IF;
550: return ;
551:
552: END validate_award ;

Line 607: gms_error_pkg.gms_debug ('Inside GMS_POR_API.account_generator_ADL','C');

603: g_error_procedure_name := 'account_generator_ADL';
604:
605: --Added debug messages for the bug 12901042
606: IF g_debug = 'Y' THEN
607: gms_error_pkg.gms_debug ('Inside GMS_POR_API.account_generator_ADL','C');
608: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
609: END IF;
610: --End for the bug 12901042
611:

Line 608: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

604:
605: --Added debug messages for the bug 12901042
606: IF g_debug = 'Y' THEN
607: gms_error_pkg.gms_debug ('Inside GMS_POR_API.account_generator_ADL','C');
608: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
609: END IF;
610: --End for the bug 12901042
611:
612: l_status := X_status ;

Line 673: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

669: l_award_set_id := x_adl_rec.award_set_id ;
670: --db_pack_message('Account Gen : awsid '||X_event||' asid :'||NVL(X_award_set_id,0)) ;
671:
672: IF g_debug = 'Y' THEN
673: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
674: END IF;
675:
676: EXCEPTION
677: When others then

Line 681: gms_error_pkg.gms_debug ('In When OTHERS Exception of account_generator_ADL'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

677: When others then
678:
679: --Added debug messages for the bug 12901042
680: IF g_debug = 'Y' THEN
681: gms_error_pkg.gms_debug ('In When OTHERS Exception of account_generator_ADL'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
682: END IF;
683: --End for the bug 12901042
684:
685: X_status := SQLCODE ;

Line 709: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_req_dist_AwardSetID','C');

705: g_error_procedure_name := 'get_req_dist_AwardSetID';
706:
707: --Added debug messages for the bug 12901042
708: IF g_debug = 'Y' THEN
709: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_req_dist_AwardSetID','C');
710: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
711: END IF;
712: --End for the bug 12901042
713:

Line 710: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

706:
707: --Added debug messages for the bug 12901042
708: IF g_debug = 'Y' THEN
709: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_req_dist_AwardSetID','C');
710: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
711: END IF;
712: --End for the bug 12901042
713:
714: -- ==============================================================

Line 730: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

726: X_award_set_id := l_award_set_id ;
727: X_status := 'S' ;
728:
729: IF g_debug = 'Y' THEN
730: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
731: END IF;
732:
733: EXCEPTION
734: When Others THEN

Line 738: gms_error_pkg.gms_debug ('In When OTHERS Exception of get_req_dist_AwardSetID'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

734: When Others THEN
735:
736: --Added debug messages for the bug 12901042
737: IF g_debug = 'Y' THEN
738: gms_error_pkg.gms_debug ('In When OTHERS Exception of get_req_dist_AwardSetID'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
739: END IF;
740: --End for the bug 12901042
741:
742: X_status := SQLCODE ;

Line 772: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_insert_line','C');

768: g_error_procedure_name := 'when_insert_line';
769:
770: --Added debug messages for the bug 12901042
771: IF g_debug = 'Y' THEN
772: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_insert_line','C');
773: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
774: END IF;
775: --End for the bug 12901042
776:

Line 773: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

769:
770: --Added debug messages for the bug 12901042
771: IF g_debug = 'Y' THEN
772: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_insert_line','C');
773: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
774: END IF;
775: --End for the bug 12901042
776:
777: -- ==============================================================

Line 814: gms_error_pkg.gms_debug (g_error_procedure_name||' Calling gms_awards_dist_pkg.create_adls','C');

810: --db_pack_message('When Insert Line Test :'||X_distribution_id) ;
811:
812: --Added debug messages for the bug 12901042
813: IF g_debug = 'Y' THEN
814: gms_error_pkg.gms_debug (g_error_procedure_name||' Calling gms_awards_dist_pkg.create_adls','C');
815: END IF;
816: --End for the bug 12901042
817:
818: gms_awards_dist_pkg.create_adls(X_adl_rec);

Line 822: gms_error_pkg.gms_debug (g_error_procedure_name||' Updating PO_REQ_DISTRIBUTIONS_ALL table','C');

818: gms_awards_dist_pkg.create_adls(X_adl_rec);
819:
820: --Added debug messages for the bug 12901042
821: IF g_debug = 'Y' THEN
822: gms_error_pkg.gms_debug (g_error_procedure_name||' Updating PO_REQ_DISTRIBUTIONS_ALL table','C');
823: END IF;
824: --End for the bug 12901042
825:
826: UPDATE PO_REQ_DISTRIBUTIONS_ALL

Line 833: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

829:
830: x_award_set_id := x_adl_rec.award_set_id ;
831:
832: IF g_debug = 'Y' THEN
833: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
834: END IF;
835:
836: return ;
837: END when_insert_line ;

Line 865: gms_error_pkg.gms_debug ('Inside parent GMS_POR_API.when_update_line','C');

861: BEGIN
862:
863: --Added debug messages for the bug 12901042
864: IF g_debug = 'Y' THEN
865: gms_error_pkg.gms_debug ('Inside parent GMS_POR_API.when_update_line','C');
866: END IF;
867: --End for the bug 12901042
868:
869: when_update_line ( X_distribution_id,

Line 888: gms_error_pkg.gms_debug ('In When OTHERS Exception of parent when_update_line'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

884: WHEN OTHERS THEN
885:
886: --Added debug messages for the bug 12901042
887: IF g_debug = 'Y' THEN
888: gms_error_pkg.gms_debug ('In When OTHERS Exception of parent when_update_line'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
889: END IF;
890: --End for the bug 12901042
891:
892: X_status := SQLCODE ;

Line 928: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_update_line','C');

924: BEGIN
925:
926: --Added debug messages for the bug 12901042
927: IF g_debug = 'Y' THEN
928: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_update_line','C');
929: END IF;
930: --End for the bug 12901042
931:
932: -- ==============================================================

Line 993: gms_error_pkg.gms_debug ('In When OTHERS Exception of when_update_line'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

989: WHEN OTHERS THEN
990:
991: --Added debug messages for the bug 12901042
992: IF g_debug = 'Y' THEN
993: gms_error_pkg.gms_debug ('In When OTHERS Exception of when_update_line'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
994: END IF;
995: --End for the bug 12901042
996: X_status := SQLCODE ;
997: RAISE ;

Line 1018: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_delete_line','C');

1014: BEGIN
1015:
1016: --Added debug messages for the bug 12901042
1017: IF g_debug = 'Y' THEN
1018: gms_error_pkg.gms_debug ('Inside GMS_POR_API.when_delete_line','C');
1019: END IF;
1020: --End for the bug 12901042
1021:
1022: -- ==============================================================

Line 1074: gms_error_pkg.gms_debug ('Inside GMS_POR_API.delete_adl','C');

1070: BEGIN
1071:
1072: --Added debug messages for the bug 12901042
1073: IF g_debug = 'Y' THEN
1074: gms_error_pkg.gms_debug ('Inside GMS_POR_API.delete_adl','C');
1075: END IF;
1076: --End for the bug 12901042
1077:
1078: -- ==============================================================

Line 1111: gms_error_pkg.gms_debug ('In When OTHERS Exception of delete_adl'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

1107: When Others THEN
1108:
1109: --Added debug messages for the bug 12901042
1110: IF g_debug = 'Y' THEN
1111: gms_error_pkg.gms_debug ('In When OTHERS Exception of delete_adl'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
1112: END IF;
1113: --End for the bug 12901042
1114:
1115: l_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1148: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_dist_param','C');

1144: BEGIN
1145:
1146: --Added debug messages for the bug 12901042
1147: IF g_debug = 'Y' THEN
1148: gms_error_pkg.gms_debug ('Inside GMS_POR_API.get_award_dist_param','C');
1149: END IF;
1150: --End for the bug 12901042
1151:
1152: OPEN c_default_award;

Line 1230: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_dist_award','C');

1226: g_error_procedure_name := 'validate_dist_award';
1227:
1228: --Added debug messages for the bug 12901042
1229: IF g_debug = 'Y' THEN
1230: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_dist_award','C');
1231: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
1232: END IF;
1233: --End for the bug 12901042
1234:

Line 1231: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

1227:
1228: --Added debug messages for the bug 12901042
1229: IF g_debug = 'Y' THEN
1230: gms_error_pkg.gms_debug ('Inside GMS_POR_API.validate_dist_award','C');
1231: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
1232: END IF;
1233: --End for the bug 12901042
1234:
1235: l_status := 'S';

Line 1292: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

1288: P_err_msg_label :=l_msg_label;
1289: END IF;
1290:
1291: IF g_debug = 'Y' THEN
1292: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
1293: END IF;
1294:
1295: EXCEPTION
1296: WHEN OTHERS THEN

Line 1300: gms_error_pkg.gms_debug (g_error_procedure_name||' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

1296: WHEN OTHERS THEN
1297:
1298: --Added debug messages for the bug 12901042
1299: IF g_debug = 'Y' THEN
1300: gms_error_pkg.gms_debug (g_error_procedure_name||' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
1301: END IF;
1302: --End for the bug 12901042
1303:
1304: p_status :='U';

Line 1367: gms_error_pkg.gms_debug ('Inside GMS_POR_API.distribute_award','C');

1363: g_error_procedure_name := 'distribute_award';
1364:
1365: --Added debug messages for the bug 12901042
1366: IF g_debug = 'Y' THEN
1367: gms_error_pkg.gms_debug ('Inside GMS_POR_API.distribute_award','C');
1368: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
1369: END IF;
1370: --End for the bug 12901042
1371:

Line 1368: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');

1364:
1365: --Added debug messages for the bug 12901042
1366: IF g_debug = 'Y' THEN
1367: gms_error_pkg.gms_debug ('Inside GMS_POR_API.distribute_award','C');
1368: gms_error_pkg.gms_debug (g_error_procedure_name||': START','C');
1369: END IF;
1370: --End for the bug 12901042
1371:
1372: -- Initilaize the Object

Line 1419: gms_error_pkg.gms_debug (g_error_procedure_name||' Before Calling GMS_POR_API.validate_dist_award','C');

1415: -- End for the bug 12426747
1416:
1417: --Added debug messages for the bug 12901042
1418: IF g_debug = 'Y' THEN
1419: gms_error_pkg.gms_debug (g_error_procedure_name||' Before Calling GMS_POR_API.validate_dist_award','C');
1420: END IF;
1421: --End for the bug 12901042
1422:
1423: GMS_POR_API.validate_dist_award(P_project_id,

Line 1432: gms_error_pkg.gms_debug (g_error_procedure_name||' After Calling GMS_POR_API.validate_dist_award','C');

1428: l_msg_label ) ;
1429:
1430: --Added debug messages for the bug 12901042
1431: IF g_debug = 'Y' THEN
1432: gms_error_pkg.gms_debug (g_error_procedure_name||' After Calling GMS_POR_API.validate_dist_award','C');
1433: gms_error_pkg.gms_debug (g_error_procedure_name||' l_status='||l_status,'C');
1434: gms_error_pkg.gms_debug (g_error_procedure_name||' l_msg_label='||l_msg_label,'C');
1435: END IF;
1436: --End for the bug 12901042

Line 1433: gms_error_pkg.gms_debug (g_error_procedure_name||' l_status='||l_status,'C');

1429:
1430: --Added debug messages for the bug 12901042
1431: IF g_debug = 'Y' THEN
1432: gms_error_pkg.gms_debug (g_error_procedure_name||' After Calling GMS_POR_API.validate_dist_award','C');
1433: gms_error_pkg.gms_debug (g_error_procedure_name||' l_status='||l_status,'C');
1434: gms_error_pkg.gms_debug (g_error_procedure_name||' l_msg_label='||l_msg_label,'C');
1435: END IF;
1436: --End for the bug 12901042
1437:

Line 1434: gms_error_pkg.gms_debug (g_error_procedure_name||' l_msg_label='||l_msg_label,'C');

1430: --Added debug messages for the bug 12901042
1431: IF g_debug = 'Y' THEN
1432: gms_error_pkg.gms_debug (g_error_procedure_name||' After Calling GMS_POR_API.validate_dist_award','C');
1433: gms_error_pkg.gms_debug (g_error_procedure_name||' l_status='||l_status,'C');
1434: gms_error_pkg.gms_debug (g_error_procedure_name||' l_msg_label='||l_msg_label,'C');
1435: END IF;
1436: --End for the bug 12901042
1437:
1438: IF l_status <> 'S' THEN

Line 1464: gms_error_pkg.gms_debug (g_error_procedure_name||' Inserting records in gms_distributions','C');

1460: END IF ;
1461:
1462: --Added debug messages for the bug 12901042
1463: IF g_debug = 'Y' THEN
1464: gms_error_pkg.gms_debug (g_error_procedure_name||' Inserting records in gms_distributions','C');
1465: END IF;
1466: --End for the bug 12901042
1467:
1468: --===========================================

Line 1503: gms_error_pkg.gms_debug (g_error_procedure_name||' Before calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');

1499: SYSDATE );
1500:
1501: --Added debug messages for the bug 12901042
1502: IF g_debug = 'Y' THEN
1503: gms_error_pkg.gms_debug (g_error_procedure_name||' Before calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');
1504: END IF;
1505: --End for the bug 12901042
1506:
1507: GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS(l_doc_header_id, 'REQ',l_recs_processed,l_recs_rejected);

Line 1512: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');

1508: --process the results of PROC_DISTRIBUTE_RECORDS
1509:
1510: --Added debug messages for the bug 12901042
1511: IF g_debug = 'Y' THEN
1512: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');
1513: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_processed='||l_recs_processed,'C');
1514: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_rejected='||l_recs_rejected,'C');
1515: END IF;
1516: --End for the bug 12901042

Line 1513: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_processed='||l_recs_processed,'C');

1509:
1510: --Added debug messages for the bug 12901042
1511: IF g_debug = 'Y' THEN
1512: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');
1513: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_processed='||l_recs_processed,'C');
1514: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_rejected='||l_recs_rejected,'C');
1515: END IF;
1516: --End for the bug 12901042
1517:

Line 1514: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_rejected='||l_recs_rejected,'C');

1510: --Added debug messages for the bug 12901042
1511: IF g_debug = 'Y' THEN
1512: gms_error_pkg.gms_debug (g_error_procedure_name||' After calling GMS_AWARD_DIST_ENG.PROC_DISTRIBUTE_RECORDS','C');
1513: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_processed='||l_recs_processed,'C');
1514: gms_error_pkg.gms_debug (g_error_procedure_name||' l_recs_rejected='||l_recs_rejected,'C');
1515: END IF;
1516: --End for the bug 12901042
1517:
1518: IF NVL(l_recs_processed,0) > 0 THEN

Line 1567: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');

1563: P_error_msg_label :=l_msg_label;
1564: END IF;
1565:
1566: IF g_debug = 'Y' THEN
1567: gms_error_pkg.gms_debug (g_error_procedure_name||': END','C');
1568: END IF;
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN

Line 1575: gms_error_pkg.gms_debug ('In When OTHERS Exception distribute_award'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');

1571: WHEN OTHERS THEN
1572:
1573: --Added debug messages for the bug 12901042
1574: IF g_debug = 'Y' THEN
1575: gms_error_pkg.gms_debug ('In When OTHERS Exception distribute_award'|| ' SQLCODE:'|| SQLCODE|| ' SQLERRM:'|| SQLERRM,'C');
1576: END IF;
1577: --End for the bug 12901042
1578:
1579: p_status :='U';