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.14 2011/09/28 07:17:43 pstawar 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.14 2011/09/28 07:17:43 pstawar 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 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 982: PA_EVENT_PUB.PACKAGE_NAME

978: WHEN pa_event_pvt.pub_excp
979: THEN
980: ROLLBACK TO create_event;
981: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: PA_EVENT_PUB.PACKAGE_NAME
983: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
984: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
985:
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

979: THEN
980: ROLLBACK TO create_event;
981: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: PA_EVENT_PUB.PACKAGE_NAME
983: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
984: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
985:
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN

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

980: ROLLBACK TO create_event;
981: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: PA_EVENT_PUB.PACKAGE_NAME
983: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
984: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
985:
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: FND_MSG_PUB.add_exc_msg

Line 999: PA_EVENT_PUB.PACKAGE_NAME

995: WHEN OTHERS
996: THEN
997: ROLLBACK TO create_event;
998: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: PA_EVENT_PUB.PACKAGE_NAME
1000: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1001: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1002:
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

996: THEN
997: ROLLBACK TO create_event;
998: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: PA_EVENT_PUB.PACKAGE_NAME
1000: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1001: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1002:
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN

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

997: ROLLBACK TO create_event;
998: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: PA_EVENT_PUB.PACKAGE_NAME
1000: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1001: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1002:
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.add_exc_msg

Line 1056: PA_EVENT_PUB.PACKAGE_NAME

1052:
1053: WHEN pa_event_pvt.pub_excp
1054: THEN
1055: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: PA_EVENT_PUB.PACKAGE_NAME
1057: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1058: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1059:
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1053: WHEN pa_event_pvt.pub_excp
1054: THEN
1055: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: PA_EVENT_PUB.PACKAGE_NAME
1057: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1058: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1059:
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1061: THEN

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

1054: THEN
1055: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: PA_EVENT_PUB.PACKAGE_NAME
1057: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1058: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1059:
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1061: THEN
1062: FND_MSG_PUB.add_exc_msg

Line 1077: PA_EVENT_PUB.PACKAGE_NAME

1073:
1074: WHEN OTHERS
1075: THEN
1076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: PA_EVENT_PUB.PACKAGE_NAME
1078: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1079: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1080:
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1074: WHEN OTHERS
1075: THEN
1076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: PA_EVENT_PUB.PACKAGE_NAME
1078: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1079: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1080:
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN

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

1075: THEN
1076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: PA_EVENT_PUB.PACKAGE_NAME
1078: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1079: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1080:
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.add_exc_msg

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

2829: WHEN pa_event_pvt.pub_excp
2830: THEN
2831: ROLLBACK TO Update_event;
2832: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833: PA_EVENT_PUB.PACKAGE_NAME
2834: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2835: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2836:
2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2830: THEN
2831: ROLLBACK TO Update_event;
2832: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833: PA_EVENT_PUB.PACKAGE_NAME
2834: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2835: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2836:
2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2838: THEN

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

2831: ROLLBACK TO Update_event;
2832: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833: PA_EVENT_PUB.PACKAGE_NAME
2834: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2835: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2836:
2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2838: THEN
2839: FND_MSG_PUB.add_exc_msg

Line 2850: PA_EVENT_PUB.PACKAGE_NAME

2846: WHEN OTHERS
2847: THEN
2848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: ROLLBACK TO Update_event;
2850: PA_EVENT_PUB.PACKAGE_NAME
2851: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2852: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2853:
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2847: THEN
2848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: ROLLBACK TO Update_event;
2850: PA_EVENT_PUB.PACKAGE_NAME
2851: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2852: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2853:
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2855: THEN

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

2848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: ROLLBACK TO Update_event;
2850: PA_EVENT_PUB.PACKAGE_NAME
2851: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2852: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2853:
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2855: THEN
2856: FND_MSG_PUB.add_exc_msg

Line 2906: PA_EVENT_PUB.PACKAGE_NAME

2902:
2903: WHEN pa_event_pvt.pub_excp
2904: THEN
2905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2906: PA_EVENT_PUB.PACKAGE_NAME
2907: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2908: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2909:
2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2903: WHEN pa_event_pvt.pub_excp
2904: THEN
2905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2906: PA_EVENT_PUB.PACKAGE_NAME
2907: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2908: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2909:
2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2911: THEN

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

2904: THEN
2905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2906: PA_EVENT_PUB.PACKAGE_NAME
2907: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2908: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2909:
2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2911: THEN
2912: FND_MSG_PUB.add_exc_msg

Line 2927: PA_EVENT_PUB.PACKAGE_NAME

2923: WHEN OTHERS
2924: THEN
2925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2926:
2927: PA_EVENT_PUB.PACKAGE_NAME
2928: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2929: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2930:
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2924: THEN
2925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2926:
2927: PA_EVENT_PUB.PACKAGE_NAME
2928: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2929: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2930:
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2932: THEN

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

2925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2926:
2927: PA_EVENT_PUB.PACKAGE_NAME
2928: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2929: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2930:
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2932: THEN
2933: FND_MSG_PUB.add_exc_msg

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

3167: THEN
3168: ROLLBACK to delete_event;
3169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3170:
3171: PA_EVENT_PUB.PACKAGE_NAME
3172: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3173: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3174:
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3168: ROLLBACK to delete_event;
3169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3170:
3171: PA_EVENT_PUB.PACKAGE_NAME
3172: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3173: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3174:
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3176: THEN

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

3169: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3170:
3171: PA_EVENT_PUB.PACKAGE_NAME
3172: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3173: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3174:
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3176: THEN
3177: FND_MSG_PUB.add_exc_msg

Line 3194: PA_EVENT_PUB.PACKAGE_NAME

3190: THEN
3191: ROLLBACK to delete_event;
3192: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3193:
3194: PA_EVENT_PUB.PACKAGE_NAME
3195: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3196: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3191: ROLLBACK to delete_event;
3192: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3193:
3194: PA_EVENT_PUB.PACKAGE_NAME
3195: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3196: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN

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

3192: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3193:
3194: PA_EVENT_PUB.PACKAGE_NAME
3195: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3196: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN
3200: FND_MSG_PUB.add_exc_msg

Line 3237: PA_EVENT_PUB.PACKAGE_NAME

3233: EXCEPTION
3234: WHEN OTHERS
3235: THEN
3236:
3237: PA_EVENT_PUB.PACKAGE_NAME
3238: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3239: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3240:
3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3234: WHEN OTHERS
3235: THEN
3236:
3237: PA_EVENT_PUB.PACKAGE_NAME
3238: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3239: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3240:
3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3242: THEN

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

3235: THEN
3236:
3237: PA_EVENT_PUB.PACKAGE_NAME
3238: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3239: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3240:
3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3242: THEN
3243: FND_MSG_PUB.add_exc_msg

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

3439: WHEN OTHERS
3440: THEN
3441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442:
3443: PA_EVENT_PUB.PACKAGE_NAME
3444: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3445: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3446:
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3440: THEN
3441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442:
3443: PA_EVENT_PUB.PACKAGE_NAME
3444: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3445: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3446:
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN

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

3441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442:
3443: PA_EVENT_PUB.PACKAGE_NAME
3444: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3445: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3446:
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN
3449: FND_MSG_PUB.add_exc_msg

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

3580: THEN
3581: p_event_id_out := NULL; -- NOCOPY
3582: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3583:
3584: PA_EVENT_PUB.PACKAGE_NAME
3585: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3586: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3581: p_event_id_out := NULL; -- NOCOPY
3582: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3583:
3584: PA_EVENT_PUB.PACKAGE_NAME
3585: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3586: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3589: THEN

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

3582: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3583:
3584: PA_EVENT_PUB.PACKAGE_NAME
3585: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3586: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3589: THEN
3590: FND_MSG_PUB.add_exc_msg

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

3714: WHEN OTHERS
3715: THEN
3716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)||'EXECUTE_UPDATE_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: THEN
3716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)||'EXECUTE_UPDATE_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)||'EXECUTE_UPDATE_EVENT';

3716: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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)||'EXECUTE_UPDATE_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 3760: PA_EVENT_PUB.PACKAGE_NAME

3756: EXCEPTION
3757: WHEN OTHERS
3758: THEN
3759:
3760: PA_EVENT_PUB.PACKAGE_NAME
3761: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3762: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3763:
3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3757: WHEN OTHERS
3758: THEN
3759:
3760: PA_EVENT_PUB.PACKAGE_NAME
3761: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3762: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3763:
3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN

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

3758: THEN
3759:
3760: PA_EVENT_PUB.PACKAGE_NAME
3761: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3762: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3763:
3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.add_exc_msg

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

3929: ROLLBACK to fetch_event;
3930: p_event_id_out := NULL; -- NOCOPY
3931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3932:
3933: PA_EVENT_PUB.PACKAGE_NAME
3934: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3935: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3936:
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3930: p_event_id_out := NULL; -- NOCOPY
3931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3932:
3933: PA_EVENT_PUB.PACKAGE_NAME
3934: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3935: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3936:
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN

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

3931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3932:
3933: PA_EVENT_PUB.PACKAGE_NAME
3934: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3935: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3936:
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN
3939: FND_MSG_PUB.add_exc_msg

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

4106: THEN
4107: ROLLBACK to check_delete_event_ok;
4108: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4109:
4110: PA_EVENT_PUB.PACKAGE_NAME
4111: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4112: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4113:
4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

4107: ROLLBACK to check_delete_event_ok;
4108: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4109:
4110: PA_EVENT_PUB.PACKAGE_NAME
4111: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4112: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4113:
4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4115: THEN

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

4108: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4109:
4110: PA_EVENT_PUB.PACKAGE_NAME
4111: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4112: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4113:
4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4115: THEN
4116: FND_MSG_PUB.add_exc_msg

Line 4131: END PA_EVENT_PUB;

4127:
4128:
4129: END CHECK_DELETE_EVENT_OK;
4130:
4131: END PA_EVENT_PUB;