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_BILLING_ADJUSTMENTS dependencies on GMS_ERROR_PKG

Line 160: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

156: X_Err_Code := 0;
157:
158: Exception
159: WHEN OTHERS THEN
160: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
161: 'SQLCODE',
162: SQLCODE,
163: 'SQLERRM',
164: SQLERRM,

Line 213: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',

209: End if;
210:
211: If SQL%NOTFOUND THEN
212:
213: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',
214: 'PRJ',
215: X_Actual_Project_Id,
216: 'TASK',
217: X_Actual_Task_Id,

Line 312: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EVT_INST',

308: write_off_amount = nvl(write_off_amount,0) + F_prorate_amt
309: where rowid = event_attribute.rowid;
310:
311: If SQL%NOTFOUND THEN
312: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EVT_INST',
313: 'PRJ',
314: X_Award_Project_Id,
315: 'EVT',
316: Invoice_line.event_num,

Line 360: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

356: End loop;
357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
361: 'SQLCODE',
362: SQLCODE,
363: 'SQLERRM',
364: F_Stage||SQLERRM,

Line 442: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

438: X_Err_Code := 0;
439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
443: 'SQLCODE',
444: SQLCODE,
445: 'SQLERRM',
446: SQLERRM,

Line 483: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT_INST',

479: where rowid = F_rowid;
480:
481:
482: If SQL%NOTFOUND THEN
483: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT_INST',
484: 'PRJ',
485: F_Project_Id,
486: 'EVT',
487: F_event_num,

Line 547: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EVT',

543: AND event_num=X_Event_Num
544: AND event_calling_process= x_calling_process ; -- Bug 2979125 : added filter calling_process
545:
546: If SQL%ROWCOUNT = 0 then
547: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EVT',
548: 'PRJ',
549: X_Award_Project_id,
550: 'EVT',
551: X_Event_Num,

Line 594: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',

590: X_Err_Code := 0;
591:
592: EXCEPTION
593: WHEN NO_DATA_FOUND THEN
594: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',
595: 'PRJ',
596: X_Act_Project_Id,
597: 'TASK',
598: X_Act_Task_Id,

Line 606: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

602: X_Err_Code => X_Err_Code,
603: X_Err_Buff => X_Err_Buff);
604: RAISE_APPLICATION_ERROR(-20207,X_Err_Buff);
605: WHEN OTHERS THEN
606: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
607: 'SQLCODE',
608: SQLCODE,
609: 'SQLERRM',
610: SQLERRM,

Line 708: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',

704:
705: End If;
706:
707: IF SQL%NOTFOUND then
708: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_TASK_INST',
709: 'PRJ',
710: F_actual_project_id,
711: 'TASK',
712: F_Actual_Task_Id,

Line 756: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',

752: and event_type = 'INVOICE';
753:
754: If SQL%ROWCOUNT = 0 then
755:
756: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',
757: 'PRJ',
758: X_Award_Project_Id,
759: 'EVT',
760: X_Event_Num,

Line 786: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',

782: and burden_cost_code = X_Burden_Cost_Code -- Bug 1193080
783: and event_type = 'REVENUE';
784:
785: If SQL%ROWCOUNT = 0 then
786: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',
787: 'PRJ',
788: X_Award_Project_Id,
789: 'EVT',
790: X_Event_Num,

Line 831: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',

827: and event_type = 'INVOICE';
828:
829: If SQL%ROWCOUNT = 0 then
830:
831: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',
832: 'PRJ',
833: X_Award_Project_Id,
834: 'EVT',
835: X_Event_Num,

Line 860: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',

856: and event_type = 'REVENUE';
857:
858: If SQL%ROWCOUNT = 0 then
859:
860: gms_error_pkg.gms_message('GMS_NO_DEL_PRJ_EVT_EXP_ADL',
861: 'PRJ',
862: X_Award_Project_Id,
863: 'EVT',
864: X_Event_Num,

Line 909: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EXP_ADL',

905: and document_type='EXP'
906: and adl_status = 'A';
907:
908: If SQL%NOTFOUND THEN
909: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EXP_ADL',
910: 'PRJ',
911: X_Award_Project_Id,
912: 'EXP',
913: X_Expenditure_Item_Id,

Line 970: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EXP_ADL',

966: and document_type='EXP'
967: and adl_status = 'A';
968:
969: If SQL%NOTFOUND THEN
970: gms_error_pkg.gms_message('GMS_NO_UPD_PRJ_EXP_ADL',
971: 'PRJ',
972: X_Award_Project_Id,
973: 'EXP',
974: X_Expenditure_Item_Id,

Line 1028: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT',

1024: End If;
1025:
1026: EXCEPTION
1027: WHEN NO_DATA_FOUND THEN
1028: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT',
1029: 'PRJ',
1030: X_Award_Project_Id,
1031: 'EVT',
1032: X_Event_Num,

Line 1038: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1034: X_Err_Code => X_Err_Code,
1035: X_Err_Buff => X_Err_Buff);
1036: RAISE_APPLICATION_ERROR(-20216,X_Err_Buff);
1037: WHEN OTHERS THEN
1038: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1039: 'SQLCODE',
1040: SQLCODE,
1041: 'SQLERRM',
1042: SQLERRM,

Line 1093: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT',

1089: X_Err_Code := 0;
1090:
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: gms_error_pkg.gms_message('GMS_NO_DATA_PRJ_EVT',
1094: 'PRJ',
1095: X_Award_Project_Id,
1096: 'EVT',
1097: X_Event_Num,

Line 1103: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1099: X_Err_Code => X_Err_Code,
1100: X_Err_Buff => X_Err_Buff);
1101: RAISE_APPLICATION_ERROR(-20218,X_Err_Buff);
1102: WHEN OTHERS THEN
1103: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1104: 'SQLCODE',
1105: SQLCODE,
1106: 'SQLERRM',
1107: SQLERRM,

Line 1139: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1135: and draft_invoice_num = X_Draft_Invoice_Num;
1136: X_Err_Code := 0;
1137: EXCEPTION
1138: WHEN NO_DATA_FOUND THEN
1139: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1140: 'SQLCODE',
1141: SQLCODE,
1142: 'SQLERRM',
1143: SQLERRM,

Line 2186: gms_error_pkg.gms_message('GMS_DRAFT_INV_NUM_NULL',

2182: Begin
2183: If X_Adj_Action = 'CANCEL' then
2184: Begin
2185: If X_Draft_Invoice_Num is NULL then
2186: gms_error_pkg.gms_message('GMS_DRAFT_INV_NUM_NULL',
2187: X_Exec_Type => 'C',
2188: X_Err_Code => X_Err_Code,
2189: X_Err_Buff => X_Err_Buff);
2190: RETCODE := 'E';

Line 2210: gms_error_pkg.gms_message('GMS_INV_FOR_CANCEL_LOCKED',

2206: and project_id = X_Award_Project_Id
2207: FOR UPDATE NOWAIT;
2208: EXCEPTION
2209: WHEN ROW_LOCKED THEN
2210: gms_error_pkg.gms_message('GMS_INV_FOR_CANCEL_LOCKED',
2211: 'INVOICE_NUM',
2212: X_Draft_Invoice_Num,
2213: X_Exec_Type => 'C',
2214: X_Err_Code => X_Err_Code,

Line 2226: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

2222:
2223: RETURN;
2224: WHEN OTHERS THEN
2225: RETCODE := 'U';
2226: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
2227: 'SQLCODE',
2228: SQLCODE,
2229: 'SQLERRM',
2230: SQLERRM,

Line 2310: gms_error_pkg.gms_message('GMS_INV_FOR_WRITE_OFF_LOCK',

2306: FOR UPDATE NOWAIT;
2307: EXCEPTION
2308: WHEN ROW_LOCKED THEN
2309: RETCODE := 'E';
2310: gms_error_pkg.gms_message('GMS_INV_FOR_WRITE_OFF_LOCK',
2311: 'INVOICE_NUM',
2312: X_Draft_Invoice_Num,
2313: 'AWARD_NUMBER',
2314: X_Award_Number,

Line 2322: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

2318: --RAISE_APPLICATION_ERROR(-20224,X_Err_Buff);
2319: RETURN;
2320: WHEN OTHERS THEN
2321: RETCODE := 'U';
2322: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
2323: 'SQLCODE',
2324: SQLCODE,
2325: 'SQLERRM',
2326: SQLERRM,

Line 2487: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

2483: X_errbuf VARCHAR2(2000);
2484:
2485: Begin
2486:
2487: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2488:
2489: IF L_DEBUG = 'Y' THEN
2490: gms_error_pkg.gms_debug('DELINV - Start GMS process for Invoice Deletion','C');
2491: END IF;

Line 2490: gms_error_pkg.gms_debug('DELINV - Start GMS process for Invoice Deletion','C');

2486:
2487: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2488:
2489: IF L_DEBUG = 'Y' THEN
2490: gms_error_pkg.gms_debug('DELINV - Start GMS process for Invoice Deletion','C');
2491: END IF;
2492: /* GMS INSTALLATION CHECK */
2493: If gms_install.enabled then
2494:

Line 2516: gms_error_pkg.gms_debug('DELINV - End GMS process for Invoice Deletion','C');

2512: End If;
2513:
2514: End if;
2515: IF L_DEBUG = 'Y' THEN
2516: gms_error_pkg.gms_debug('DELINV - End GMS process for Invoice Deletion','C');
2517: END IF;
2518:
2519: End DELINV;
2520:

Line 2542: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

2538: X_Err_Buff VARCHAR2(2000);
2539:
2540: Begin
2541:
2542: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2543:
2544: IF L_DEBUG = 'Y' THEN
2545: gms_error_pkg.gms_debug('CANINV - Start GMS process for Invoice Cancellation','C');
2546: END IF;

Line 2545: gms_error_pkg.gms_debug('CANINV - Start GMS process for Invoice Cancellation','C');

2541:
2542: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2543:
2544: IF L_DEBUG = 'Y' THEN
2545: gms_error_pkg.gms_debug('CANINV - Start GMS process for Invoice Cancellation','C');
2546: END IF;
2547:
2548: /* GMS INSTALLATION CHECK */
2549: If gms_install.enabled then

Line 2565: gms_error_pkg.gms_message('GMS_NO_INV_FOR_CANCEL',

2561: and b.draft_invoice_num = a.draft_invoice_num;
2562:
2563: EXCEPTION
2564: WHEN NO_DATA_FOUND THEN
2565: gms_error_pkg.gms_message('GMS_NO_INV_FOR_CANCEL',
2566: 'PRJ',
2567: X_Project_Id,
2568: X_Exec_Type => 'C',
2569: X_Err_Code => X_Err_Code,

Line 2605: gms_error_pkg.gms_debug('CANINV - End GMS process for Invoice Cancellation','C');

2601: End If;
2602:
2603: End if;
2604: IF L_DEBUG = 'Y' THEN
2605: gms_error_pkg.gms_debug('CANINV - End GMS process for Invoice Cancellation','C');
2606: END IF;
2607: End CANINV;
2608:
2609:

Line 2631: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

2627: X_Err_Buff VARCHAR2(2000);
2628:
2629: Begin
2630:
2631: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2632:
2633: /* GMS INSTALLATION CHECK */
2634: If gms_install.enabled then
2635:

Line 2680: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

2676: ,x_message => 'Failure - When Others'
2677: ,x_error_message => X_Err_Msg
2678: ,x_status => X_Status);
2679: */
2680: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
2681: 'SQLCODE',
2682: SQLCODE,
2683: 'SQLERRM',
2684: SQLERRM,

Line 2717: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

2713: X_Err_Buff VARCHAR2(2000);
2714:
2715: Begin
2716:
2717: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2718:
2719: IF L_DEBUG = 'Y' THEN
2720: gms_error_pkg.gms_debug('DELREV - Start GMS process for Revenue Deletion','C');
2721: END IF;

Line 2720: gms_error_pkg.gms_debug('DELREV - Start GMS process for Revenue Deletion','C');

2716:
2717: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2718:
2719: IF L_DEBUG = 'Y' THEN
2720: gms_error_pkg.gms_debug('DELREV - Start GMS process for Revenue Deletion','C');
2721: END IF;
2722:
2723: /* GMS INSTALLATION CHECK */
2724: If gms_install.enabled then

Line 2748: gms_error_pkg.gms_debug('DELREV - End GMS process for Revenue Deletion','C');

2744: End If;
2745:
2746: End if;
2747: IF L_DEBUG = 'Y' THEN
2748: gms_error_pkg.gms_debug('DELREV - End GMS process for Revenue Deletion','C');
2749: END IF;
2750:
2751: End DELREV;
2752: