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.PA_EVENT_PUB dependencies on PA_DEBUG

Line 11: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG.MODE'),'Y');

7: --PACKAGE GLOBAL to be used during updates ---------------------------
8: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_id;
9: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
10:
11: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG.MODE'),'Y');
12:
13: /*==================================================================
14: --
15: --Name: create_event

Line 90: pa_debug.set_err_stack('PA_EVENT_PUB.CREATE_EVENT');

86: l_encoded varchar2(1):='F';
87: l_return_status varchar2(1):= FND_API.G_RET_STS_SUCCESS;
88: BEGIN
89: -- Initialize the Error Stack
90: pa_debug.set_err_stack('PA_EVENT_PUB.CREATE_EVENT');
91:
92: --Log Message
93: IF l_debug_mode = 'Y' THEN
94: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

Line 94: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

90: pa_debug.set_err_stack('PA_EVENT_PUB.CREATE_EVENT');
91:
92: --Log Message
93: IF l_debug_mode = 'Y' THEN
94: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
95: ,x_msg => 'Beginning of Create Event'
96: ,x_log_level => 5);
97: END IF;
98:

Line 104: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

100: p_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: --Log Message
103: IF l_debug_mode = 'Y' THEN
104: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
105: ,x_msg => 'Calling mandatory input parameters-1'
106: ,x_log_level => 5);
107: END IF;
108:

Line 202: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

198: savepoint create_event;
199:
200: --Log Message
201: IF l_debug_mode = 'Y' THEN
202: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
203: ,x_msg => ' Calling mandatory input parameters-2'
204: ,x_log_level => 5);
205: END IF;
206:

Line 232: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

228: End If;
229:
230: --Log Message
231: IF l_debug_mode = 'Y' THEN
232: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
233: ,x_msg => 'Calling check_valid_project '
234: ,x_log_level => 5);
235: END IF;
236:

Line 262: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

258: End If;
259:
260: --Log Message
261: IF l_debug_mode = 'Y' THEN
262: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
263: ,x_msg =>'Calling get_project_defaults to get defaulting currencies'
264: ,x_log_level =>5);
265: END IF;
266:

Line 310: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

306: End If;
307:
308: --Log Message
309: IF l_debug_mode = 'Y' THEN
310: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
311: ,x_msg => 'Calling check_create_event_ok'
312: ,x_log_level => 5);
313: END IF;
314:

Line 346: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

342: End If;
343:
344: --Log Message
345: IF l_debug_mode = 'Y' THEN
346: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
347: ,x_msg => 'Beginning Validate Flexfields'
348: ,x_log_level => 5);
349: END IF;
350:

Line 406: pa_debug.write_log ( x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

402: END IF;
403:
404: --Log Message
405: IF l_debug_mode = 'Y' THEN
406: pa_debug.write_log ( x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
407: ,x_msg => 'Validating or generating event number'
408: ,x_log_level => 5);
409: END IF;
410:

Line 485: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

481:
482:
483: --Log Message
484: IF l_debug_mode = 'Y' THEN
485: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
486: ,x_msg => 'Beginning defaulting mcb parameters'
487: ,x_log_level => 5);
488: END IF;
489:

Line 770: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

766: p_event_in_rec.p_event_id:=NULL;
767:
768: --Log Message
769: IF l_debug_mode = 'Y' THEN
770: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
771: ,x_msg => 'Beginning Insert event. '
772: ,x_log_level => 5);
773: END IF;
774:

Line 995: pa_debug.reset_err_stack; -- Reset error stack

991: p_event_out_tbl(tot_out_rec).Return_status := P_return_status;
992: tot_out_rec := tot_out_rec + 1;
993: tot_in_rec := p_event_in_tbl.next(tot_in_rec);
994:
995: pa_debug.reset_err_stack; -- Reset error stack
996: END LOOP; -- End of loop
997:
998:
999: --Setting the return status to false even if one record fails the validation.

Line 1186: pa_debug.set_err_stack('PA_EVENT_PUB.UPDATE_EVENT');

1182:
1183: BEGIN
1184:
1185: -- Initialize the Error Stack
1186: pa_debug.set_err_stack('PA_EVENT_PUB.UPDATE_EVENT');
1187:
1188: --Log Message
1189: IF l_debug_mode = 'Y' THEN
1190: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

Line 1190: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1186: pa_debug.set_err_stack('PA_EVENT_PUB.UPDATE_EVENT');
1187:
1188: --Log Message
1189: IF l_debug_mode = 'Y' THEN
1190: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1191: ,x_msg => 'Beginning of Update Event'
1192: ,x_log_level => 5);
1193: END IF;
1194:

Line 1200: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1196: p_return_status := FND_API.G_RET_STS_SUCCESS;
1197:
1198: --Log Message
1199: IF l_debug_mode = 'Y' THEN
1200: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1201: ,x_msg => 'Calling mandatory input parameters-1'
1202: ,x_log_level => 5);
1203: END IF;
1204:

Line 1298: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1294: Savepoint Update_event;
1295:
1296: --Log Message
1297: IF l_debug_mode = 'Y' THEN
1298: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1299: ,x_msg => ' Calling mandatory input parameters-2'
1300: ,x_log_level => 5);
1301: END IF;
1302:

Line 1328: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1324: End If;
1325: End of comment for 3118781*/
1326: --Log Message
1327: IF l_debug_mode = 'Y' THEN
1328: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1329: ,x_msg => 'Calling conv_event_ref_to_id'
1330: ,x_log_level => 5);
1331: END IF;
1332:

Line 1380: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1376: End If;
1377:
1378: --Log Message
1379: IF l_debug_mode = 'Y' THEN
1380: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1381: ,x_msg =>'Defaulting currency from pa_events for the given event'
1382: ,x_log_level =>5);
1383: END IF;
1384:

Line 1471: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1467:
1468:
1469: --Log Message
1470: IF l_debug_mode = 'Y' THEN
1471: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1472: ,x_msg => 'Calling check_update_event_ok'
1473: ,x_log_level => 5);
1474: END IF;
1475:

Line 1508: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1504: End If;
1505:
1506: --Log Message
1507: IF l_debug_mode = 'Y' THEN
1508: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1509: ,x_msg => 'Beginning Validate Flexfields'
1510: ,x_log_level => 5);
1511: END IF;
1512:

Line 1626: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1622: END IF;
1623:
1624: --Log Message
1625: IF l_debug_mode = 'Y' THEN
1626: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1627: ,x_msg => 'Beginning defaulting mcb parameters'
1628: ,x_log_level => 5);
1629: END IF;
1630:

Line 1873: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

1869:
1870:
1871: --Log Message
1872: IF l_debug_mode = 'Y' THEN
1873: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1874: ,x_msg => 'Beginning defaulting parameters before updating table'
1875: ,x_log_level => 5);
1876: END IF;
1877:

Line 2099: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

2095: End If;
2096:
2097: --Log Message
2098: IF l_debug_mode = 'Y' THEN
2099: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
2100: ,x_msg => 'Begin Updating event. '
2101: ,x_log_level => 5);
2102: END IF;
2103:

Line 2831: pa_debug.reset_err_stack; -- Reset error stack

2827: p_event_out_tbl(tot_out_rec).Return_status := P_return_status;
2828: tot_out_rec := tot_out_rec + 1;
2829: tot_in_rec := p_event_in_tbl.next(tot_in_rec);
2830:
2831: pa_debug.reset_err_stack; -- Reset error stack
2832:
2833: END LOOP; --End of loop
2834:
2835: --Setting the return status to false even if one record fails the validation.

Line 2942: pa_debug.set_err_stack('PA_EVENT_PUB.DELETE_EVENT');

2938: l_pm_event_reference VARCHAR2(25);
2939: BEGIN
2940:
2941: -- Initialize the Error Stack
2942: pa_debug.set_err_stack('PA_EVENT_PUB.DELETE_EVENT');
2943:
2944: --Log Message
2945: IF l_debug_mode = 'Y' THEN
2946: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

Line 2946: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

2942: pa_debug.set_err_stack('PA_EVENT_PUB.DELETE_EVENT');
2943:
2944: --Log Message
2945: IF l_debug_mode = 'Y' THEN
2946: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
2947: ,x_msg => 'Beginning of Delete Event'
2948: ,x_log_level => 5);
2949: END IF;
2950:

Line 2958: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

2954: p_msg_count := 0;
2955: p_return_status := FND_API.G_RET_STS_SUCCESS;
2956: --Log Message
2957: IF l_debug_mode = 'Y' THEN
2958: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
2959: ,x_msg => 'Calling mandatory input parameters-1'
2960: ,x_log_level => 5);
2961: END IF;
2962:

Line 2988: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

2984: End If;
2985:
2986: --Log Message
2987: IF l_debug_mode = 'Y' THEN
2988: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
2989: ,x_msg => ' Calling mandatory input parameters-2'
2990: ,x_log_level => 5);
2991: END IF;
2992:

Line 3018: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

3014: End If;
3015: End of comment for 3118781 */
3016: --Log Message
3017: IF l_debug_mode = 'Y' THEN
3018: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3019: ,x_msg => 'Calling conv_event_ref_to_id'
3020: ,x_log_level => 5);
3021: END IF;
3022: l_pm_event_reference :=p_pm_event_reference;

Line 3038: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

3034: End If;
3035:
3036: --Log Message
3037: IF l_debug_mode = 'Y' THEN
3038: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3039: ,x_msg => 'Calling check_delete_event_ok'
3040: ,x_log_level => 5);
3041: END IF;
3042:

Line 3079: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'

3075:
3076:
3077: --Log Message
3078: IF l_debug_mode = 'Y' THEN
3079: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3080: ,x_msg => 'Calling table handler to delete event'
3081: ,x_log_level => 5);
3082: END IF;
3083:

Line 3102: pa_debug.reset_err_stack; -- Reset error stack

3098: ( p_encoded => l_encoded
3099: ,p_count => p_msg_count
3100: ,p_data => p_msg_data );
3101:
3102: pa_debug.reset_err_stack; -- Reset error stack
3103:
3104:
3105: EXCEPTION
3106: WHEN FND_API.G_EXC_ERROR

Line 3289: pa_debug.set_err_stack('PA_EVENT_PUB.LOAD_EVENT');

3285: p_msg_data VARCHAR2(2000);
3286: BEGIN
3287:
3288: -- Initialize the Error Stack
3289: pa_debug.set_err_stack('PA_EVENT_PUB.LOAD_EVENT');
3290:
3291: --Log Message
3292: IF l_debug_mode = 'Y' THEN
3293: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'

Line 3293: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'

3289: pa_debug.set_err_stack('PA_EVENT_PUB.LOAD_EVENT');
3290:
3291: --Log Message
3292: IF l_debug_mode = 'Y' THEN
3293: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3294: ,x_msg => 'Beginning of Load_Event'
3295: ,x_log_level => 5);
3296: End If;
3297:

Line 3301: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'

3297:
3298:
3299: --Log Message
3300: IF l_debug_mode = 'Y' THEN
3301: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3302: ,x_msg => 'Beginning of api compatibility check '
3303: ,x_log_level => 5);
3304: End If;
3305:

Line 3317: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'

3313: END IF;
3314:
3315: --Log Message
3316: IF l_debug_mode = 'Y' THEN
3317: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3318: ,x_msg => 'Beginning of Loading the global tables'
3319: ,x_log_level => 5);
3320: End If;
3321:

Line 3381: pa_debug.reset_err_stack; -- Reset error stack

3377: G_event_in_tbl(G_event_tbl_count).P_event_id :=P_event_id;
3378:
3379: G_event_tbl_count := G_event_tbl_count+1;
3380:
3381: pa_debug.reset_err_stack; -- Reset error stack
3382: EXCEPTION
3383: WHEN FND_API.G_EXC_ERROR
3384: THEN
3385: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3447: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_CREATE_EVENT');

3443: p_api_name VARCHAR2(100):='EXECUTE_CREATE_EVENT';
3444: l_encoded varchar2(1):='F';
3445: BEGIN
3446: -- Initialize the Error Stack
3447: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_CREATE_EVENT');
3448:
3449: --Log Message
3450: IF l_debug_mode = 'Y' THEN
3451: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'

Line 3451: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'

3447: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_CREATE_EVENT');
3448:
3449: --Log Message
3450: IF l_debug_mode = 'Y' THEN
3451: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3452: ,x_msg => 'Beginning of Execute_Create_Event'
3453: ,x_log_level => 5);
3454: End If;
3455:

Line 3460: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'

3456:
3457:
3458: --Log Message
3459: IF l_debug_mode = 'Y' THEN
3460: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3461: ,x_msg => 'Beginning of api compatibility check '
3462: ,x_log_level => 5);
3463: End If;
3464:

Line 3476: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'

3472: END IF;
3473:
3474: --Log Message
3475: IF l_debug_mode = 'Y' THEN
3476: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3477: ,x_msg => 'Calling Create_event '
3478: ,x_log_level => 5);
3479: End If;
3480:

Line 3515: pa_debug.reset_err_stack; -- Reset error stack

3511:
3512: -- Call fetch_event API in case of multiple events creation
3513: -- to get the event id of new events created
3514:
3515: pa_debug.reset_err_stack; -- Reset error stack
3516:
3517:
3518: EXCEPTION
3519: WHEN FND_API.G_EXC_ERROR

Line 3593: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_UPDATE_EVENT');

3589:
3590: BEGIN
3591:
3592: -- Initialize the Error Stack
3593: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_UPDATE_EVENT');
3594:
3595: --Log Message
3596: IF l_debug_mode = 'Y' THEN
3597: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'

Line 3597: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'

3593: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_UPDATE_EVENT');
3594:
3595: --Log Message
3596: IF l_debug_mode = 'Y' THEN
3597: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3598: ,x_msg => 'Beginning of Execute_Update_Event'
3599: ,x_log_level => 5);
3600: End If;
3601:

Line 3605: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'

3601:
3602:
3603: --Log Message
3604: IF l_debug_mode = 'Y' THEN
3605: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3606: ,x_msg => 'Beginning of api compatibility check '
3607: ,x_log_level => 5);
3608: End If;
3609:

Line 3622: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'

3618: END IF;
3619:
3620: --Log Message
3621: IF l_debug_mode = 'Y' THEN
3622: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3623: ,x_msg => 'Calling Update_event '
3624: ,x_log_level => 5);
3625: End If;
3626:

Line 3652: pa_debug.reset_err_stack; -- Reset error stack

3648: RAISE FND_API.G_EXC_ERROR;
3649: END IF;
3650: End If;
3651:
3652: pa_debug.reset_err_stack; -- Reset error stack
3653:
3654:
3655: EXCEPTION
3656: WHEN FND_API.G_EXC_ERROR

Line 3763: pa_debug.set_err_stack('PA_EVENT_PUB.FETCH_EVENT');

3759: l_encoded VARCHAR2(1):='F';
3760: BEGIN
3761:
3762: -- Initialize the Error Stack
3763: pa_debug.set_err_stack('PA_EVENT_PUB.FETCH_EVENT');
3764:
3765: --Log Message
3766: IF l_debug_mode = 'Y' THEN
3767: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

Line 3767: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

3763: pa_debug.set_err_stack('PA_EVENT_PUB.FETCH_EVENT');
3764:
3765: --Log Message
3766: IF l_debug_mode = 'Y' THEN
3767: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3768: ,x_msg => 'Beginning of Fetch_Event'
3769: ,x_log_level => 5);
3770: End If;
3771:

Line 3780: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

3776: p_return_status := FND_API.G_RET_STS_SUCCESS;
3777:
3778: --Log Message
3779: IF l_debug_mode = 'Y' THEN
3780: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3781: ,x_msg => 'Beginning of api compatibility check '
3782: ,x_log_level => 5);
3783: End If;
3784:

Line 3818: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

3814: END IF;
3815:
3816: --Log Message
3817: IF l_debug_mode = 'Y' THEN
3818: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3819: ,x_msg => 'Begin Fetching event_id from event_reference'
3820: ,x_log_level => 5);
3821: End If;
3822:

Line 3857: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

3853:
3854:
3855: --Log Message
3856: IF l_debug_mode = 'Y' THEN
3857: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3858: ,x_msg => 'End of Fetch_Event'
3859: ,x_log_level => 5);
3860: End If;
3861:

Line 3862: pa_debug.reset_err_stack; -- Reset error stack

3858: ,x_msg => 'End of Fetch_Event'
3859: ,x_log_level => 5);
3860: End If;
3861:
3862: pa_debug.reset_err_stack; -- Reset error stack
3863:
3864: EXCEPTION
3865: WHEN FND_API.G_EXC_ERROR
3866: THEN

Line 3945: pa_debug.set_err_stack('PA_EVENT_PUB.CHECK_DELETE_EVENT_OK');

3941: l_encoded VARCHAR2(1):='F';
3942: l_pm_event_reference VARCHAR2(25);
3943: BEGIN
3944: -- Initialize the Error Stack
3945: pa_debug.set_err_stack('PA_EVENT_PUB.CHECK_DELETE_EVENT_OK');
3946:
3947: --Log Message
3948: IF l_debug_mode = 'Y' THEN
3949: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'

Line 3949: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'

3945: pa_debug.set_err_stack('PA_EVENT_PUB.CHECK_DELETE_EVENT_OK');
3946:
3947: --Log Message
3948: IF l_debug_mode = 'Y' THEN
3949: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
3950: ,x_msg => 'Beginning of Check_Delete_Event_Ok'
3951: ,x_log_level => 5);
3952: END IF;
3953:

Line 3961: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'

3957: p_return_status := FND_API.G_RET_STS_SUCCESS;
3958:
3959: --Log Message
3960: IF l_debug_mode = 'Y' THEN
3961: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
3962: ,x_msg => 'Calling mandatory input parameters-1'
3963: ,x_log_level => 5);
3964: END IF;
3965:

Line 3991: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'

3987: End If;
3988:
3989: --Log Message
3990: IF l_debug_mode = 'Y' THEN
3991: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
3992: ,x_msg => 'Calling conv_event_ref_to_id'
3993: ,x_log_level => 5);
3994: END IF;
3995:

Line 4010: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'

4006: End If;
4007:
4008: --Log Message
4009: IF l_debug_mode = 'Y' THEN
4010: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
4011: ,x_msg => 'Calling Check_Event_Processed'
4012: ,x_log_level => 5);
4013: END IF;
4014:

Line 4041: pa_debug.reset_err_stack; -- Reset error stack

4037: ( p_encoded => l_encoded
4038: , p_count => p_msg_count
4039: , p_data => p_msg_data );
4040:
4041: pa_debug.reset_err_stack; -- Reset error stack
4042:
4043:
4044: EXCEPTION
4045: WHEN FND_API.G_EXC_ERROR