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_EVENT_PUB

Line 1: PACKAGE BODY PA_EVENT_PUB AS

1: PACKAGE BODY PA_EVENT_PUB AS
2: /* $Header: PAEVAPBB.pls 120.6.12010000.3 2008/11/30 19:32:25 arbandyo ship $ */
3:
4: /* Global Constants */
5: G_PKG_NAME VARCHAR2(30) := 'PA_EVENT_PUB';

Line 5: G_PKG_NAME VARCHAR2(30) := 'PA_EVENT_PUB';

1: PACKAGE BODY PA_EVENT_PUB AS
2: /* $Header: PAEVAPBB.pls 120.6.12010000.3 2008/11/30 19:32:25 arbandyo ship $ */
3:
4: /* Global Constants */
5: G_PKG_NAME VARCHAR2(30) := 'PA_EVENT_PUB';
6:
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;

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 956: PA_EVENT_PUB.PACKAGE_NAME

952: WHEN pa_event_pvt.pub_excp
953: THEN
954: ROLLBACK TO create_event;
955: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: PA_EVENT_PUB.PACKAGE_NAME
957: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
959:
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 957: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

953: THEN
954: ROLLBACK TO create_event;
955: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: PA_EVENT_PUB.PACKAGE_NAME
957: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
959:
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN

Line 958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';

954: ROLLBACK TO create_event;
955: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: PA_EVENT_PUB.PACKAGE_NAME
957: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
959:
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: FND_MSG_PUB.add_exc_msg

Line 973: PA_EVENT_PUB.PACKAGE_NAME

969: WHEN OTHERS
970: THEN
971: ROLLBACK TO create_event;
972: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: PA_EVENT_PUB.PACKAGE_NAME
974: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
976:
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 974: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

970: THEN
971: ROLLBACK TO create_event;
972: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: PA_EVENT_PUB.PACKAGE_NAME
974: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
976:
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN

Line 975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';

971: ROLLBACK TO create_event;
972: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: PA_EVENT_PUB.PACKAGE_NAME
974: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
976:
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.add_exc_msg

Line 1029: PA_EVENT_PUB.PACKAGE_NAME

1025:
1026: WHEN pa_event_pvt.pub_excp
1027: THEN
1028: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: PA_EVENT_PUB.PACKAGE_NAME
1030: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1032:
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1030: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

1026: WHEN pa_event_pvt.pub_excp
1027: THEN
1028: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: PA_EVENT_PUB.PACKAGE_NAME
1030: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1032:
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN

Line 1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';

1027: THEN
1028: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: PA_EVENT_PUB.PACKAGE_NAME
1030: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1032:
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.add_exc_msg

Line 1050: PA_EVENT_PUB.PACKAGE_NAME

1046:
1047: WHEN OTHERS
1048: THEN
1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: PA_EVENT_PUB.PACKAGE_NAME
1051: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1053:
1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1051: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

1047: WHEN OTHERS
1048: THEN
1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: PA_EVENT_PUB.PACKAGE_NAME
1051: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1053:
1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN

Line 1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';

1048: THEN
1049: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: PA_EVENT_PUB.PACKAGE_NAME
1051: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1053:
1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.add_exc_msg

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 2792: PA_EVENT_PUB.PACKAGE_NAME

2788: WHEN pa_event_pvt.pub_excp
2789: THEN
2790: ROLLBACK TO Update_event;
2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792: PA_EVENT_PUB.PACKAGE_NAME
2793: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2795:
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2793: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

2789: THEN
2790: ROLLBACK TO Update_event;
2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792: PA_EVENT_PUB.PACKAGE_NAME
2793: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2795:
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN

Line 2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';

2790: ROLLBACK TO Update_event;
2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792: PA_EVENT_PUB.PACKAGE_NAME
2793: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2795:
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.add_exc_msg

Line 2809: PA_EVENT_PUB.PACKAGE_NAME

2805: WHEN OTHERS
2806: THEN
2807: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2808: ROLLBACK TO Update_event;
2809: PA_EVENT_PUB.PACKAGE_NAME
2810: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2812:
2813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2810: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

2806: THEN
2807: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2808: ROLLBACK TO Update_event;
2809: PA_EVENT_PUB.PACKAGE_NAME
2810: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2812:
2813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2814: THEN

Line 2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';

2807: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2808: ROLLBACK TO Update_event;
2809: PA_EVENT_PUB.PACKAGE_NAME
2810: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2812:
2813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2814: THEN
2815: FND_MSG_PUB.add_exc_msg

Line 2864: PA_EVENT_PUB.PACKAGE_NAME

2860:
2861: WHEN pa_event_pvt.pub_excp
2862: THEN
2863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864: PA_EVENT_PUB.PACKAGE_NAME
2865: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2867:
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2865: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

2861: WHEN pa_event_pvt.pub_excp
2862: THEN
2863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864: PA_EVENT_PUB.PACKAGE_NAME
2865: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2867:
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2869: THEN

Line 2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';

2862: THEN
2863: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864: PA_EVENT_PUB.PACKAGE_NAME
2865: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2867:
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2869: THEN
2870: FND_MSG_PUB.add_exc_msg

Line 2885: PA_EVENT_PUB.PACKAGE_NAME

2881: WHEN OTHERS
2882: THEN
2883: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884:
2885: PA_EVENT_PUB.PACKAGE_NAME
2886: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2888:
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2886: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

2882: THEN
2883: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884:
2885: PA_EVENT_PUB.PACKAGE_NAME
2886: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2888:
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2890: THEN

Line 2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';

2883: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884:
2885: PA_EVENT_PUB.PACKAGE_NAME
2886: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2888:
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2890: THEN
2891: FND_MSG_PUB.add_exc_msg

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 3129: PA_EVENT_PUB.PACKAGE_NAME

3125: THEN
3126: ROLLBACK to delete_event;
3127: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3128:
3129: PA_EVENT_PUB.PACKAGE_NAME
3130: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3132:
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3130: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3126: ROLLBACK to delete_event;
3127: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3128:
3129: PA_EVENT_PUB.PACKAGE_NAME
3130: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3132:
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN

Line 3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';

3127: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3128:
3129: PA_EVENT_PUB.PACKAGE_NAME
3130: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3132:
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.add_exc_msg

Line 3152: PA_EVENT_PUB.PACKAGE_NAME

3148: THEN
3149: ROLLBACK to delete_event;
3150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3151:
3152: PA_EVENT_PUB.PACKAGE_NAME
3153: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3155:
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3153: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3149: ROLLBACK to delete_event;
3150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3151:
3152: PA_EVENT_PUB.PACKAGE_NAME
3153: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3155:
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3157: THEN

Line 3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';

3150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3151:
3152: PA_EVENT_PUB.PACKAGE_NAME
3153: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3155:
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3157: THEN
3158: FND_MSG_PUB.add_exc_msg

Line 3195: PA_EVENT_PUB.PACKAGE_NAME

3191: EXCEPTION
3192: WHEN OTHERS
3193: THEN
3194:
3195: PA_EVENT_PUB.PACKAGE_NAME
3196: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3197: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3198:
3199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3196: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3192: WHEN OTHERS
3193: THEN
3194:
3195: PA_EVENT_PUB.PACKAGE_NAME
3196: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3197: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3198:
3199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3200: THEN

Line 3197: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';

3193: THEN
3194:
3195: PA_EVENT_PUB.PACKAGE_NAME
3196: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3197: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3198:
3199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3200: THEN
3201: FND_MSG_PUB.add_exc_msg

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 3401: PA_EVENT_PUB.PACKAGE_NAME

3397: WHEN OTHERS
3398: THEN
3399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3400:
3401: PA_EVENT_PUB.PACKAGE_NAME
3402: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3404:
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3402: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3398: THEN
3399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3400:
3401: PA_EVENT_PUB.PACKAGE_NAME
3402: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3404:
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN

Line 3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';

3399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3400:
3401: PA_EVENT_PUB.PACKAGE_NAME
3402: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3404:
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN
3407: FND_MSG_PUB.add_exc_msg

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 3542: PA_EVENT_PUB.PACKAGE_NAME

3538: THEN
3539: p_event_id_out := NULL; -- NOCOPY
3540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3541:
3542: PA_EVENT_PUB.PACKAGE_NAME
3543: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3545:
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3543: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3539: p_event_id_out := NULL; -- NOCOPY
3540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3541:
3542: PA_EVENT_PUB.PACKAGE_NAME
3543: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3545:
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3547: THEN

Line 3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';

3540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3541:
3542: PA_EVENT_PUB.PACKAGE_NAME
3543: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3545:
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3547: THEN
3548: FND_MSG_PUB.add_exc_msg

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 3676: PA_EVENT_PUB.PACKAGE_NAME

3672: WHEN OTHERS
3673: THEN
3674: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3675:
3676: PA_EVENT_PUB.PACKAGE_NAME
3677: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3679:
3680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3677: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3673: THEN
3674: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3675:
3676: PA_EVENT_PUB.PACKAGE_NAME
3677: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3679:
3680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3681: THEN

Line 3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';

3674: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3675:
3676: PA_EVENT_PUB.PACKAGE_NAME
3677: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3679:
3680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3681: THEN
3682: FND_MSG_PUB.add_exc_msg

Line 3718: PA_EVENT_PUB.PACKAGE_NAME

3714: EXCEPTION
3715: WHEN OTHERS
3716: THEN
3717:
3718: PA_EVENT_PUB.PACKAGE_NAME
3719: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3721:
3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3719: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3715: WHEN OTHERS
3716: THEN
3717:
3718: PA_EVENT_PUB.PACKAGE_NAME
3719: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3721:
3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3723: THEN

Line 3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';

3716: THEN
3717:
3718: PA_EVENT_PUB.PACKAGE_NAME
3719: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3721:
3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3723: THEN
3724: FND_MSG_PUB.add_exc_msg

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 3891: PA_EVENT_PUB.PACKAGE_NAME

3887: ROLLBACK to fetch_event;
3888: p_event_id_out := NULL; -- NOCOPY
3889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3890:
3891: PA_EVENT_PUB.PACKAGE_NAME
3892: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3894:
3895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3892: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

3888: p_event_id_out := NULL; -- NOCOPY
3889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3890:
3891: PA_EVENT_PUB.PACKAGE_NAME
3892: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3894:
3895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3896: THEN

Line 3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';

3889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3890:
3891: PA_EVENT_PUB.PACKAGE_NAME
3892: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3894:
3895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3896: THEN
3897: FND_MSG_PUB.add_exc_msg

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 4068: PA_EVENT_PUB.PACKAGE_NAME

4064: THEN
4065: ROLLBACK to check_delete_event_ok;
4066: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067:
4068: PA_EVENT_PUB.PACKAGE_NAME
4069: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4071:
4072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4069: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';

4065: ROLLBACK to check_delete_event_ok;
4066: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067:
4068: PA_EVENT_PUB.PACKAGE_NAME
4069: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4071:
4072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4073: THEN

Line 4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';

4066: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067:
4068: PA_EVENT_PUB.PACKAGE_NAME
4069: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4071:
4072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4073: THEN
4074: FND_MSG_PUB.add_exc_msg

Line 4089: END PA_EVENT_PUB;

4085:
4086:
4087: END CHECK_DELETE_EVENT_OK;
4088:
4089: END PA_EVENT_PUB;