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

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

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

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

Line 1150: FND_MSG_PUB.get (

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

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

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

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

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

Line 1690: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

Line 1693: FND_MSG_PUB.get (

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

Line 1695: ,p_msg_index => FND_MSG_PUB.Count_Msg

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

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

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

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

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

Line 2210: FND_MSG_PUB.get (

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

Line 2212: ,p_msg_index => FND_MSG_PUB.Count_Msg

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

Line 2231: IF FND_MSG_PUB.Count_Msg > 0 THEN

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

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

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

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

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