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 222: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'

218: savepoint create_event;
219:
220: --Log Message
221: IF l_debug_mode = 'Y' THEN
222: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
223: ,x_msg => ' Calling mandatory input parameters-2'
224: ,x_log_level => 5);
225: END IF;
226:

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

248: End If;
249:
250: --Log Message
251: IF l_debug_mode = 'Y' THEN
252: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
253: ,x_msg => 'Calling check_valid_project '
254: ,x_log_level => 5);
255: END IF;
256:

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

278: End If;
279:
280: --Log Message
281: IF l_debug_mode = 'Y' THEN
282: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
283: ,x_msg =>'Calling get_project_defaults to get defaulting currencies'
284: ,x_log_level =>5);
285: END IF;
286:

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

326: End If;
327:
328: --Log Message
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
331: ,x_msg => 'Calling check_create_event_ok'
332: ,x_log_level => 5);
333: END IF;
334:

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

362: End If;
363:
364: --Log Message
365: IF l_debug_mode = 'Y' THEN
366: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
367: ,x_msg => 'Beginning Validate Flexfields'
368: ,x_log_level => 5);
369: END IF;
370:

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

422: END IF;
423:
424: --Log Message
425: IF l_debug_mode = 'Y' THEN
426: pa_debug.write_log ( x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
427: ,x_msg => 'Validating or generating event number'
428: ,x_log_level => 5);
429: END IF;
430:

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

501:
502:
503: --Log Message
504: IF l_debug_mode = 'Y' THEN
505: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
506: ,x_msg => 'Beginning defaulting mcb parameters'
507: ,x_log_level => 5);
508: END IF;
509:

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

786: p_event_in_rec.p_event_id:=NULL;
787:
788: --Log Message
789: IF l_debug_mode = 'Y' THEN
790: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CREATE_EVENT.begin'
791: ,x_msg => 'Beginning Insert event. '
792: ,x_log_level => 5);
793: END IF;
794:

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

1018: p_event_out_tbl(tot_out_rec).Return_status := P_return_status;
1019: -- tot_out_rec := tot_out_rec + 1; --Commented for bug#12964074
1020: tot_in_rec := p_event_in_tbl.next(tot_in_rec);
1021:
1022: pa_debug.reset_err_stack; -- Reset error stack
1023: END LOOP; -- End of loop
1024:
1025:
1026: --Setting the return status to false even if one record fails the validation.

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

1209:
1210: BEGIN
1211:
1212: -- Initialize the Error Stack
1213: pa_debug.set_err_stack('PA_EVENT_PUB.UPDATE_EVENT');
1214:
1215: --Log Message
1216: IF l_debug_mode = 'Y' THEN
1217: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'

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

1213: pa_debug.set_err_stack('PA_EVENT_PUB.UPDATE_EVENT');
1214:
1215: --Log Message
1216: IF l_debug_mode = 'Y' THEN
1217: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1218: ,x_msg => 'Beginning of Update Event'
1219: ,x_log_level => 5);
1220: END IF;
1221:

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

1223: p_return_status := FND_API.G_RET_STS_SUCCESS;
1224:
1225: --Log Message
1226: IF l_debug_mode = 'Y' THEN
1227: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1228: ,x_msg => 'Calling mandatory input parameters-1'
1229: ,x_log_level => 5);
1230: END IF;
1231:

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

1321: Savepoint Update_event;
1322:
1323: --Log Message
1324: IF l_debug_mode = 'Y' THEN
1325: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1326: ,x_msg => ' Calling mandatory input parameters-2'
1327: ,x_log_level => 5);
1328: END IF;
1329:

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

1351: End If;
1352: End of comment for 3118781*/
1353: --Log Message
1354: IF l_debug_mode = 'Y' THEN
1355: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1356: ,x_msg => 'Calling conv_event_ref_to_id'
1357: ,x_log_level => 5);
1358: END IF;
1359:

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

1403: End If;
1404:
1405: --Log Message
1406: IF l_debug_mode = 'Y' THEN
1407: pa_debug.write_log (x_module =>'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1408: ,x_msg =>'Defaulting currency from pa_events for the given event'
1409: ,x_log_level =>5);
1410: END IF;
1411:

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

1494:
1495:
1496: --Log Message
1497: IF l_debug_mode = 'Y' THEN
1498: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1499: ,x_msg => 'Calling check_update_event_ok'
1500: ,x_log_level => 5);
1501: END IF;
1502:

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

1531: End If;
1532:
1533: --Log Message
1534: IF l_debug_mode = 'Y' THEN
1535: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1536: ,x_msg => 'Beginning Validate Flexfields'
1537: ,x_log_level => 5);
1538: END IF;
1539:

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

1649: END IF;
1650:
1651: --Log Message
1652: IF l_debug_mode = 'Y' THEN
1653: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1654: ,x_msg => 'Beginning defaulting mcb parameters'
1655: ,x_log_level => 5);
1656: END IF;
1657:

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

1896:
1897:
1898: --Log Message
1899: IF l_debug_mode = 'Y' THEN
1900: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
1901: ,x_msg => 'Beginning defaulting parameters before updating table'
1902: ,x_log_level => 5);
1903: END IF;
1904:

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

2122: End If;
2123:
2124: --Log Message
2125: IF l_debug_mode = 'Y' THEN
2126: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.UPDATE_EVENT.begin'
2127: ,x_msg => 'Begin Updating event. '
2128: ,x_log_level => 5);
2129: END IF;
2130:

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

2869: p_event_out_tbl(tot_out_rec).Return_status := P_return_status;
2870: -- tot_out_rec := tot_out_rec + 1; -- Commented for bug#12964074
2871: tot_in_rec := p_event_in_tbl.next(tot_in_rec);
2872:
2873: pa_debug.reset_err_stack; -- Reset error stack
2874:
2875: END LOOP; --End of loop
2876:
2877: --Setting the return status to false even if one record fails the validation.

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

2980: l_pm_event_reference VARCHAR2(25);
2981: BEGIN
2982:
2983: -- Initialize the Error Stack
2984: pa_debug.set_err_stack('PA_EVENT_PUB.DELETE_EVENT');
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'

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

2984: pa_debug.set_err_stack('PA_EVENT_PUB.DELETE_EVENT');
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 => 'Beginning of Delete Event'
2990: ,x_log_level => 5);
2991: END IF;
2992:

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

2996: p_msg_count := 0;
2997: p_return_status := FND_API.G_RET_STS_SUCCESS;
2998: --Log Message
2999: IF l_debug_mode = 'Y' THEN
3000: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3001: ,x_msg => 'Calling mandatory input parameters-1'
3002: ,x_log_level => 5);
3003: END IF;
3004:

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

3026: End If;
3027:
3028: --Log Message
3029: IF l_debug_mode = 'Y' THEN
3030: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3031: ,x_msg => ' Calling mandatory input parameters-2'
3032: ,x_log_level => 5);
3033: END IF;
3034:

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

3056: End If;
3057: End of comment for 3118781 */
3058: --Log Message
3059: IF l_debug_mode = 'Y' THEN
3060: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3061: ,x_msg => 'Calling conv_event_ref_to_id'
3062: ,x_log_level => 5);
3063: END IF;
3064: l_pm_event_reference :=p_pm_event_reference;

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

3076: End If;
3077:
3078: --Log Message
3079: IF l_debug_mode = 'Y' THEN
3080: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3081: ,x_msg => 'Calling check_delete_event_ok'
3082: ,x_log_level => 5);
3083: END IF;
3084:

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

3117:
3118:
3119: --Log Message
3120: IF l_debug_mode = 'Y' THEN
3121: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.DELETE_EVENT.begin'
3122: ,x_msg => 'Calling table handler to delete event'
3123: ,x_log_level => 5);
3124: END IF;
3125:

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

3140: ( p_encoded => l_encoded
3141: ,p_count => p_msg_count
3142: ,p_data => p_msg_data );
3143:
3144: pa_debug.reset_err_stack; -- Reset error stack
3145:
3146:
3147: EXCEPTION
3148: WHEN FND_API.G_EXC_ERROR

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

3327: p_msg_data VARCHAR2(2000);
3328: BEGIN
3329:
3330: -- Initialize the Error Stack
3331: pa_debug.set_err_stack('PA_EVENT_PUB.LOAD_EVENT');
3332:
3333: --Log Message
3334: IF l_debug_mode = 'Y' THEN
3335: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'

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

3331: pa_debug.set_err_stack('PA_EVENT_PUB.LOAD_EVENT');
3332:
3333: --Log Message
3334: IF l_debug_mode = 'Y' THEN
3335: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3336: ,x_msg => 'Beginning of Load_Event'
3337: ,x_log_level => 5);
3338: End If;
3339:

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

3339:
3340:
3341: --Log Message
3342: IF l_debug_mode = 'Y' THEN
3343: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3344: ,x_msg => 'Beginning of api compatibility check '
3345: ,x_log_level => 5);
3346: End If;
3347:

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

3355: END IF;
3356:
3357: --Log Message
3358: IF l_debug_mode = 'Y' THEN
3359: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.LOAD_EVENT.begin'
3360: ,x_msg => 'Beginning of Loading the global tables'
3361: ,x_log_level => 5);
3362: End If;
3363:

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

3419: G_event_in_tbl(G_event_tbl_count).P_event_id :=P_event_id;
3420:
3421: G_event_tbl_count := G_event_tbl_count+1;
3422:
3423: pa_debug.reset_err_stack; -- Reset error stack
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR
3426: THEN
3427: p_return_status := FND_API.G_RET_STS_ERROR;

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

3485: p_api_name VARCHAR2(100):='EXECUTE_CREATE_EVENT';
3486: l_encoded varchar2(1):='F';
3487: BEGIN
3488: -- Initialize the Error Stack
3489: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_CREATE_EVENT');
3490:
3491: --Log Message
3492: IF l_debug_mode = 'Y' THEN
3493: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'

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

3489: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_CREATE_EVENT');
3490:
3491: --Log Message
3492: IF l_debug_mode = 'Y' THEN
3493: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3494: ,x_msg => 'Beginning of Execute_Create_Event'
3495: ,x_log_level => 5);
3496: End If;
3497:

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

3498:
3499:
3500: --Log Message
3501: IF l_debug_mode = 'Y' THEN
3502: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3503: ,x_msg => 'Beginning of api compatibility check '
3504: ,x_log_level => 5);
3505: End If;
3506:

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

3514: END IF;
3515:
3516: --Log Message
3517: IF l_debug_mode = 'Y' THEN
3518: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_CREATE_EVENT.begin'
3519: ,x_msg => 'Calling Create_event '
3520: ,x_log_level => 5);
3521: End If;
3522:

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

3553:
3554: -- Call fetch_event API in case of multiple events creation
3555: -- to get the event id of new events created
3556:
3557: pa_debug.reset_err_stack; -- Reset error stack
3558:
3559:
3560: EXCEPTION
3561: WHEN FND_API.G_EXC_ERROR

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

3631:
3632: BEGIN
3633:
3634: -- Initialize the Error Stack
3635: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_UPDATE_EVENT');
3636:
3637: --Log Message
3638: IF l_debug_mode = 'Y' THEN
3639: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'

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

3635: pa_debug.set_err_stack('PA_EVENT_PUB.EXECUTE_UPDATE_EVENT');
3636:
3637: --Log Message
3638: IF l_debug_mode = 'Y' THEN
3639: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3640: ,x_msg => 'Beginning of Execute_Update_Event'
3641: ,x_log_level => 5);
3642: End If;
3643:

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

3643:
3644:
3645: --Log Message
3646: IF l_debug_mode = 'Y' THEN
3647: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3648: ,x_msg => 'Beginning of api compatibility check '
3649: ,x_log_level => 5);
3650: End If;
3651:

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

3660: END IF;
3661:
3662: --Log Message
3663: IF l_debug_mode = 'Y' THEN
3664: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.EXECUTE_UPDATE_EVENT.begin'
3665: ,x_msg => 'Calling Update_event '
3666: ,x_log_level => 5);
3667: End If;
3668:

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

3690: RAISE FND_API.G_EXC_ERROR;
3691: END IF;
3692: End If;
3693:
3694: pa_debug.reset_err_stack; -- Reset error stack
3695:
3696:
3697: EXCEPTION
3698: WHEN FND_API.G_EXC_ERROR

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

3801: l_encoded VARCHAR2(1):='F';
3802: BEGIN
3803:
3804: -- Initialize the Error Stack
3805: pa_debug.set_err_stack('PA_EVENT_PUB.FETCH_EVENT');
3806:
3807: --Log Message
3808: IF l_debug_mode = 'Y' THEN
3809: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'

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

3805: pa_debug.set_err_stack('PA_EVENT_PUB.FETCH_EVENT');
3806:
3807: --Log Message
3808: IF l_debug_mode = 'Y' THEN
3809: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3810: ,x_msg => 'Beginning of Fetch_Event'
3811: ,x_log_level => 5);
3812: End If;
3813:

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

3818: p_return_status := FND_API.G_RET_STS_SUCCESS;
3819:
3820: --Log Message
3821: IF l_debug_mode = 'Y' THEN
3822: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3823: ,x_msg => 'Beginning of api compatibility check '
3824: ,x_log_level => 5);
3825: End If;
3826:

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

3856: END IF;
3857:
3858: --Log Message
3859: IF l_debug_mode = 'Y' THEN
3860: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3861: ,x_msg => 'Begin Fetching event_id from event_reference'
3862: ,x_log_level => 5);
3863: End If;
3864:

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

3895:
3896:
3897: --Log Message
3898: IF l_debug_mode = 'Y' THEN
3899: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.FETCH_EVENT.begin'
3900: ,x_msg => 'End of Fetch_Event'
3901: ,x_log_level => 5);
3902: End If;
3903:

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

3900: ,x_msg => 'End of Fetch_Event'
3901: ,x_log_level => 5);
3902: End If;
3903:
3904: pa_debug.reset_err_stack; -- Reset error stack
3905:
3906: EXCEPTION
3907: WHEN FND_API.G_EXC_ERROR
3908: THEN

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

3983: l_encoded VARCHAR2(1):='F';
3984: l_pm_event_reference VARCHAR2(25);
3985: BEGIN
3986: -- Initialize the Error Stack
3987: pa_debug.set_err_stack('PA_EVENT_PUB.CHECK_DELETE_EVENT_OK');
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'

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

3987: pa_debug.set_err_stack('PA_EVENT_PUB.CHECK_DELETE_EVENT_OK');
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 => 'Beginning of Check_Delete_Event_Ok'
3993: ,x_log_level => 5);
3994: END IF;
3995:

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

3999: p_return_status := FND_API.G_RET_STS_SUCCESS;
4000:
4001: --Log Message
4002: IF l_debug_mode = 'Y' THEN
4003: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
4004: ,x_msg => 'Calling mandatory input parameters-1'
4005: ,x_log_level => 5);
4006: END IF;
4007:

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

4029: End If;
4030:
4031: --Log Message
4032: IF l_debug_mode = 'Y' THEN
4033: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
4034: ,x_msg => 'Calling conv_event_ref_to_id'
4035: ,x_log_level => 5);
4036: END IF;
4037:

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

4048: End If;
4049:
4050: --Log Message
4051: IF l_debug_mode = 'Y' THEN
4052: pa_debug.write_log (x_module => 'pa.plsql.PA_EVENT_PUB.CHECK_DELETE_EVENT_OK.begin'
4053: ,x_msg => 'Calling Check_Event_Processed'
4054: ,x_log_level => 5);
4055: END IF;
4056:

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

4079: ( p_encoded => l_encoded
4080: , p_count => p_msg_count
4081: , p_data => p_msg_data );
4082:
4083: pa_debug.reset_err_stack; -- Reset error stack
4084:
4085:
4086: EXCEPTION
4087: WHEN FND_API.G_EXC_ERROR