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_ADVERTISEMENTS_PVT dependencies on PA_ADVERTISEMENTS_PVT

Line 1: PACKAGE BODY PA_ADVERTISEMENTS_PVT AS

1: PACKAGE BODY PA_ADVERTISEMENTS_PVT AS
2: --$Header: PARAVPVB.pls 120.9.12010000.3 2010/03/24 09:42:12 sugupta ship $
3: --
4:
5: ----------------------------------------------------------------------

Line 62: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines');

58:
59: BEGIN
60:
61: -- Initialize the Error Stack
62: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines');
63:
64: -- 4537865 : Initiliaze x_return_status
65: x_return_status := FND_API.G_RET_STS_SUCCESS ;
66:

Line 69: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines.begin'

65: x_return_status := FND_API.G_RET_STS_SUCCESS ;
66:
67: --Log Message
68: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
69: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines.begin'
70: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines'
71: ,x_log_level => 5);
72: END IF;
73:

Line 70: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines'

66:
67: --Log Message
68: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
69: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines.begin'
70: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Order_Adv_Action_Lines'
71: ,x_log_level => 5);
72: END IF;
73:
74: -- Initialize the return status to success

Line 293: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

289: -- 4537865 : Included Exception Block
290: EXCEPTION
291: WHEN OTHERS THEN
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
293: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
294: , p_procedure_name => 'Order_Adv_Action_Lines'
295: , p_error_text => SUBSTRB(SQLERRM,1,240));
296: RAISE ;
297: END Order_Adv_Action_Lines;

Line 323: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_All');

319:
320: BEGIN
321:
322: -- Initialize the Error Stack
323: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_All');
324:
325: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');
326:
327: --Log Message

Line 325: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');

321:
322: -- Initialize the Error Stack
323: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_All');
324:
325: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');
326:
327: --Log Message
328: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
329: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_All.begin'

Line 329: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_All.begin'

325: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');
326:
327: --Log Message
328: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
329: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_All.begin'
330: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_All'
331: ,x_log_level => 5);
332: END IF;
333:

Line 330: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_All'

326:
327: --Log Message
328: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
329: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_All.begin'
330: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_All'
331: ,x_log_level => 5);
332: END IF;
333:
334: -- Initialize the return status to success

Line 358: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

354: -- 4537865 : Included Exception Block
355: EXCEPTION
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
359: , p_procedure_name => 'Publish_To_All'
360: , p_error_text => SUBSTRB(SQLERRM,1,240));
361: RAISE ;
362: END Publish_To_All;

Line 411: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');

407: AND pa_org_use_type = 'EXPENDITURES';
408:
409: BEGIN
410:
411: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');
412:
413: -- Initialize the Error Stack
414: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');
415:

Line 414: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');

410:
411: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');
412:
413: -- Initialize the Error Stack
414: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');
415:
416: --Log Message
417: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
418: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'

Line 418: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'

414: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Organizations');
415:
416: --Log Message
417: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
418: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'
419: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'
420: ,x_log_level => 5);
421: END IF;
422:

Line 419: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'

415:
416: --Log Message
417: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
418: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'
419: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Organizations'
420: ,x_log_level => 5);
421: END IF;
422:
423: -- Initialize the return status to success

Line 492: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

488: -- 4537865 : Included Exception Block
489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
493: , p_procedure_name => 'Publish_To_Organizations'
494: , p_error_text => SUBSTRB(SQLERRM,1,240));
495: RAISE ;
496: END Publish_To_Organizations;

Line 572: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');

568: AND asla.action_set_type_code = 'ADVERTISEMENT';
569:
570: BEGIN
571:
572: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');
573:
574: -- Initialize the Error Stack
575: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level');
576:

Line 575: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level');

571:
572: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to all');
573:
574: -- Initialize the Error Stack
575: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level');
576:
577: --Log Message
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'

Line 579: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'

575: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level');
576:
577: --Log Message
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'
580: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'
581: ,x_log_level => 5);
582: END IF;
583:

Line 580: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'

576:
577: --Log Message
578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
579: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'
580: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Escalate_to_Next_Level'
581: ,x_log_level => 5);
582: END IF;
583:
584: -- Initialize the return status to success

Line 706: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

702: -- 4537865 : Included Exception Block
703: EXCEPTION
704: WHEN OTHERS THEN
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
706: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
707: , p_procedure_name => 'Escalate_To_Next_Level'
708: , p_error_text => SUBSTRB(SQLERRM,1,240));
709: RAISE ;
710: END Escalate_To_Next_Level;

Line 767: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to staffing manager');

763: */
764:
765: BEGIN
766:
767: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to staffing manager');
768:
769: -- Initialize the Error Stack
770: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers');
771:

Line 770: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers');

766:
767: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.publish to staffing manager');
768:
769: -- Initialize the Error Stack
770: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers');
771:
772: --Log Message
773: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
774: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'

Line 774: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'

770: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers');
771:
772: --Log Message
773: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
774: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'
775: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'
776: ,x_log_level => 5);
777: END IF;
778:

Line 775: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'

771:
772: --Log Message
773: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
774: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'
775: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Publish_To_Staffing_Managers'
776: ,x_log_level => 5);
777: END IF;
778:
779: -- Initialize the return status to success

Line 843: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

839: -- 4537865 : Included Exception Block
840: EXCEPTION
841: WHEN OTHERS THEN
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
843: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
844: , p_procedure_name => 'Publish_To_Staffing_Managers'
845: , p_error_text => SUBSTRB(SQLERRM,1,240));
846: RAISE ;
847: END Publish_To_Staffing_Managers;

Line 889: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send email');

885: i NUMBER := 0;
886: --end for 4701745
887:
888: BEGIN
889: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send email');
890:
891: -- Initialize the Error Stack
892: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Email');
893:

Line 892: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Email');

888: BEGIN
889: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send email');
890:
891: -- Initialize the Error Stack
892: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Email');
893:
894: --Log Message
895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
896: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Email'

Line 896: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Email'

892: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Email');
893:
894: --Log Message
895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
896: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Email'
897: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Email'
898: ,x_log_level => 5);
899: END IF;
900:

Line 897: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Email'

893:
894: --Log Message
895: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
896: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Email'
897: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Email'
898: ,x_log_level => 5);
899: END IF;
900:
901: -- Initialize the return status to success

Line 982: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

978: -- 4537865 : Included Exception Block
979: EXCEPTION
980: WHEN OTHERS THEN
981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
982: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
983: , p_procedure_name => 'Send_Email'
984: , p_error_text => SUBSTRB(SQLERRM,1,240));
985: RAISE ;
986: END Send_Email;

Line 1068: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send notification');

1064: l_action_status_code VARCHAR2(30);
1065:
1066: BEGIN
1067:
1068: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send notification');
1069:
1070: -- Initialize the Error Stack
1071: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Notification');
1072:

Line 1071: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Notification');

1067:
1068: --dbms_output.put_line('PA_ADVERTISEMENTS_PVT.send notification');
1069:
1070: -- Initialize the Error Stack
1071: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Notification');
1072:
1073: --Log Message
1074: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1075: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Notification'

Line 1075: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Notification'

1071: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Send_Notification');
1072:
1073: --Log Message
1074: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1075: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Notification'
1076: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Notification'
1077: ,x_log_level => 5);
1078: END IF;
1079:

Line 1076: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Notification'

1072:
1073: --Log Message
1074: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1075: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Send_Notification'
1076: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Send_Notification'
1077: ,x_log_level => 5);
1078: END IF;
1079:
1080: -- Initialize the return status to success

Line 1178: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

1174: -- 4537865 : Included Exception Block
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
1179: , p_procedure_name => 'Send_Notification'
1180: , p_error_text => SUBSTRB(SQLERRM,1,240));
1181: RAISE ;
1182: END Send_Notification;

Line 1333: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF');

1329:
1330: BEGIN
1331:
1332: -- Initialize the Error Stack
1333: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF');
1334:
1335: --Log Message
1336: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1337: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'

Line 1337: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'

1333: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF');
1334:
1335: --Log Message
1336: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1337: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'
1338: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'
1339: ,x_log_level => 5);
1340: END IF;
1341:

Line 1338: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'

1334:
1335: --Log Message
1336: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1337: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'
1338: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Start_Adv_Notification_WF'
1339: ,x_log_level => 5);
1340: END IF;
1341:
1342: -- Initialize the return status to success

Line 1611: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

1607: -- 4537865 : Included Exception Block
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1611: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
1612: , p_procedure_name => 'Start_Adv_Notification_WF'
1613: , p_error_text => SUBSTRB(SQLERRM,1,240));
1614: RAISE ;
1615: END Start_Adv_Notification_WF;

Line 1646: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');

1642:
1643: --dbms_output.put_line('update staffing priority');
1644:
1645: -- Initialize the Error Stack
1646: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');
1647:
1648: --Log Message
1649: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1650: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'

Line 1650: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'

1646: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');
1647:
1648: --Log Message
1649: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1650: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'
1651: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'
1652: ,x_log_level => 5);
1653: END IF;
1654:

Line 1651: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'

1647:
1648: --Log Message
1649: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1650: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'
1651: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority'
1652: ,x_log_level => 5);
1653: END IF;
1654:
1655: -- Initialize the return status to success

Line 1742: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

1738: -- 4537865 : Included Exception Block
1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1742: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
1743: , p_procedure_name => 'Update_Staffing_Priority'
1744: , p_error_text => SUBSTRB(SQLERRM,1,240));
1745: RAISE ;
1746: END Update_Staffing_Priority;

Line 1841: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Remove_Advertisement');

1837: AND asl.action_set_line_id <> p_action_set_line_id;
1838:
1839: BEGIN
1840:
1841: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Remove_Advertisement');
1842:
1843: -- Initialize the Error Stack
1844: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');
1845:

Line 1844: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');

1840:
1841: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PVT.Remove_Advertisement');
1842:
1843: -- Initialize the Error Stack
1844: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');
1845:
1846: --Log Message
1847: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1848: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Remove_Advertisement'

Line 1848: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Remove_Advertisement'

1844: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PVT.Update_Staffing_Priority');
1845:
1846: --Log Message
1847: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1848: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Remove_Advertisement'
1849: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Remove_Advertisement'
1850: ,x_log_level => 5);
1851: END IF;
1852:

Line 1849: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Remove_Advertisement'

1845:
1846: --Log Message
1847: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1848: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ADVERTISEMENTS_PVT.Remove_Advertisement'
1849: ,x_msg => 'Beginning of PA_ADVERTISEMENTS_PVT.Remove_Advertisement'
1850: ,x_log_level => 5);
1851: END IF;
1852:
1853: -- Initialize the return status to success

Line 2240: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

2236: -- 4537865 : Included Exception Block
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2240: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
2241: , p_procedure_name => 'Remove_Advertisement'
2242: , p_error_text => SUBSTRB(SQLERRM,1,240));
2243: RAISE ;
2244: END Remove_Advertisement;

Line 2281: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'

2277:
2278: Exception
2279: when others then
2280: resultout := wf_engine.eng_completed||':'||'F';
2281: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PVT'
2282: , p_procedure_name => 'Check_Assignment_Open'
2283: , p_error_text => SUBSTRB(SQLERRM,1,240));
2284: --RAISE ; // commented for 7134435
2285: END check_assignment_open;

Line 2288: END PA_ADVERTISEMENTS_PVT;

2284: --RAISE ; // commented for 7134435
2285: END check_assignment_open;
2286: -- End changes for Bug 4777149
2287:
2288: END PA_ADVERTISEMENTS_PVT;
2289: