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 FND_MSG_PUB

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 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 470: IF FND_MSG_PUB.Count_Msg > 0 THEN

466: END IF; -- l_organization_id_tbl.count = 0
467:
468: -- Insert the error into the audit table
469: -- and return error status if there is error message in the stack
470: IF FND_MSG_PUB.Count_Msg > 0 THEN
471: IF p_insert_audit_flag = 'T' THEN
472: FND_MSG_PUB.get (
473: p_encoded => FND_API.G_TRUE
474: ,p_msg_index => FND_MSG_PUB.Count_Msg

Line 472: FND_MSG_PUB.get (

468: -- Insert the error into the audit table
469: -- and return error status if there is error message in the stack
470: IF FND_MSG_PUB.Count_Msg > 0 THEN
471: IF p_insert_audit_flag = 'T' THEN
472: FND_MSG_PUB.get (
473: p_encoded => FND_API.G_TRUE
474: ,p_msg_index => FND_MSG_PUB.Count_Msg
475: ,p_data => l_encoded_message_text
476: ,p_msg_index_out => l_msg_index_out);

Line 474: ,p_msg_index => FND_MSG_PUB.Count_Msg

470: IF FND_MSG_PUB.Count_Msg > 0 THEN
471: IF p_insert_audit_flag = 'T' THEN
472: FND_MSG_PUB.get (
473: p_encoded => FND_API.G_TRUE
474: ,p_msg_index => FND_MSG_PUB.Count_Msg
475: ,p_data => l_encoded_message_text
476: ,p_msg_index_out => l_msg_index_out);
477:
478: l_action_line_audit_rec.reason_code := 'CONDITION_MET';

Line 485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

481: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
482: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
486:
487: END IF; -- if status is PENDING
488: -- 4537865 : Included Exception Block
489: EXCEPTION

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 683: IF FND_MSG_PUB.Count_Msg > 0 THEN

679: --
680: -- Insert the error into the audit table
681: -- and return error status if there is error message in the stack
682: --
683: IF FND_MSG_PUB.Count_Msg > 0 THEN
684:
685: IF p_insert_audit_flag = 'T' THEN
686: FND_MSG_PUB.get (
687: p_encoded => FND_API.G_TRUE

Line 686: FND_MSG_PUB.get (

682: --
683: IF FND_MSG_PUB.Count_Msg > 0 THEN
684:
685: IF p_insert_audit_flag = 'T' THEN
686: FND_MSG_PUB.get (
687: p_encoded => FND_API.G_TRUE
688: ,p_msg_index => FND_MSG_PUB.Count_Msg
689: ,p_data => l_encoded_message_text
690: ,p_msg_index_out => l_msg_index_out);

Line 688: ,p_msg_index => FND_MSG_PUB.Count_Msg

684:
685: IF p_insert_audit_flag = 'T' THEN
686: FND_MSG_PUB.get (
687: p_encoded => FND_API.G_TRUE
688: ,p_msg_index => FND_MSG_PUB.Count_Msg
689: ,p_data => l_encoded_message_text
690: ,p_msg_index_out => l_msg_index_out);
691:
692: l_action_line_audit_rec.reason_code := 'CONDITION_MET';

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 821: IF FND_MSG_PUB.Count_Msg > 0 THEN

817: --
818: -- Insert the error into the audit table
819: -- and return error status if there is error message in the stack
820: --
821: IF FND_MSG_PUB.Count_Msg > 0 THEN
822: IF p_insert_audit_flag = 'T' THEN
823: FND_MSG_PUB.get (
824: p_encoded => FND_API.G_TRUE
825: ,p_msg_index => FND_MSG_PUB.Count_Msg

Line 823: FND_MSG_PUB.get (

819: -- and return error status if there is error message in the stack
820: --
821: IF FND_MSG_PUB.Count_Msg > 0 THEN
822: IF p_insert_audit_flag = 'T' THEN
823: FND_MSG_PUB.get (
824: p_encoded => FND_API.G_TRUE
825: ,p_msg_index => FND_MSG_PUB.Count_Msg
826: ,p_data => l_encoded_message_text
827: ,p_msg_index_out => l_msg_index_out);

Line 825: ,p_msg_index => FND_MSG_PUB.Count_Msg

821: IF FND_MSG_PUB.Count_Msg > 0 THEN
822: IF p_insert_audit_flag = 'T' THEN
823: FND_MSG_PUB.get (
824: p_encoded => FND_API.G_TRUE
825: ,p_msg_index => FND_MSG_PUB.Count_Msg
826: ,p_data => l_encoded_message_text
827: ,p_msg_index_out => l_msg_index_out);
828:
829: l_action_line_audit_rec.reason_code := 'CONDITION_MET';

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 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 1147: IF FND_MSG_PUB.Count_Msg > 0 THEN

1143: --
1144: -- Insert the error into the audit table
1145: -- and return error status if there is error message in the stack
1146: --
1147: IF FND_MSG_PUB.Count_Msg > 0 THEN
1148: IF p_insert_audit_flag = 'T' THEN
1149:
1150: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
1151: FND_MSG_PUB.get (

Line 1150: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP

1146: --
1147: IF FND_MSG_PUB.Count_Msg > 0 THEN
1148: IF p_insert_audit_flag = 'T' THEN
1149:
1150: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
1151: FND_MSG_PUB.get (
1152: p_encoded => FND_API.G_TRUE
1153: ,p_msg_index => i
1154: ,p_data => l_encoded_message_text

Line 1151: FND_MSG_PUB.get (

1147: IF FND_MSG_PUB.Count_Msg > 0 THEN
1148: IF p_insert_audit_flag = 'T' THEN
1149:
1150: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
1151: FND_MSG_PUB.get (
1152: p_encoded => FND_API.G_TRUE
1153: ,p_msg_index => i
1154: ,p_data => l_encoded_message_text
1155: ,p_msg_index_out => l_msg_index_out);

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 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 1691: IF FND_MSG_PUB.Count_Msg > 0 THEN

1687:
1688: ELSE
1689:
1690: -- ERROR: Insert error into the audit table
1691: IF FND_MSG_PUB.Count_Msg > 0 THEN
1692: IF p_insert_audit_flag = 'T' THEN
1693:
1694: FND_MSG_PUB.get (
1695: p_encoded => FND_API.G_TRUE

Line 1694: FND_MSG_PUB.get (

1690: -- ERROR: Insert error into the audit table
1691: IF FND_MSG_PUB.Count_Msg > 0 THEN
1692: IF p_insert_audit_flag = 'T' THEN
1693:
1694: FND_MSG_PUB.get (
1695: p_encoded => FND_API.G_TRUE
1696: ,p_msg_index => FND_MSG_PUB.Count_Msg
1697: ,p_data => l_encoded_message_text
1698: ,p_msg_index_out => l_msg_index_out);

Line 1696: ,p_msg_index => FND_MSG_PUB.Count_Msg

1692: IF p_insert_audit_flag = 'T' THEN
1693:
1694: FND_MSG_PUB.get (
1695: p_encoded => FND_API.G_TRUE
1696: ,p_msg_index => FND_MSG_PUB.Count_Msg
1697: ,p_data => l_encoded_message_text
1698: ,p_msg_index_out => l_msg_index_out);
1699:
1700: l_action_line_audit_rec.reason_code := 'CONDITION_MET';

Line 1707: END IF; -- IF FND_MSG_PUB.Count_Msg > 0

1703: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1704: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1705: END IF; -- IF p_insert_audit_flag = 'T'
1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: END IF; -- IF FND_MSG_PUB.Count_Msg > 0
1708:
1709: END IF;
1710:
1711:

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 2211: FND_MSG_PUB.get (

2207: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
2208:
2209: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2210:
2211: FND_MSG_PUB.get (
2212: p_encoded => FND_API.G_TRUE
2213: ,p_msg_index => FND_MSG_PUB.Count_Msg
2214: ,p_data => l_encoded_message_text
2215: ,p_msg_index_out => l_msg_index_out);

Line 2213: ,p_msg_index => FND_MSG_PUB.Count_Msg

2209: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2210:
2211: FND_MSG_PUB.get (
2212: p_encoded => FND_API.G_TRUE
2213: ,p_msg_index => FND_MSG_PUB.Count_Msg
2214: ,p_data => l_encoded_message_text
2215: ,p_msg_index_out => l_msg_index_out);
2216:
2217: l_action_line_audit_rec.reason_code := l_audit_reason_code;

Line 2232: IF FND_MSG_PUB.Count_Msg > 0 THEN

2228: END LOOP;
2229:
2230: END IF; -- if l_action_set_line_id_tbl.COUNT > 0
2231:
2232: IF FND_MSG_PUB.Count_Msg > 0 THEN
2233: x_return_status := FND_API.G_RET_STS_ERROR;
2234: END IF;
2235:
2236: -- 4537865 : Included Exception Block

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;