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_API

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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:
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'

Line 75: l_return_status := FND_API.G_RET_STS_SUCCESS;

71: ,x_log_level => 5);
72: END IF;
73:
74: -- Initialize the return status to success
75: l_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: -- Clear the temporary table
78: DELETE FROM pa_adv_action_lines_order_temp;
79:

Line 274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

270: ,p_condition_date_tbl => l_condition_date_tbl2
271: ,x_return_status => l_return_status
272: );
273:
274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277:
278: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: ,x_return_status => l_return_status
272: );
273:
274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277:
278: PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(
279: p_action_set_line_id_tbl => l_action_line_id_tbl2

Line 284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

280: ,p_line_number_tbl => l_action_line_number_tbl2
281: ,x_return_status => x_return_status
282: );
283:
284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287:
288: END IF; -- more than 0 line

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: ,x_return_status => x_return_status
282: );
283:
284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: END IF;
287:
288: END IF; -- more than 0 line
289: -- 4537865 : Included Exception Block

Line 292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

288: END IF; -- more than 0 line
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 ;

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: ,x_log_level => 5);
332: END IF;
333:
334: -- Initialize the return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: --
338: -- Handle PENDING action line only as REVERSE_PENDING and UPDATE_PENDING
339: -- lines can be handled generically by the action set model.

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

353: END IF;
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 ;

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: ,x_log_level => 5);
421: END IF;
422:
423: -- Initialize the return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426:
427: --
428: -- Handle PENDING action line only as REVERSE_PENDING and UPDATE_PENDING

Line 473: p_encoded => FND_API.G_TRUE

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);
477:

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
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

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

487: END IF; -- if status is PENDING
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 ;

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: ,x_log_level => 5);
582: END IF;
583:
584: -- Initialize the return status to success
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586:
587: --
588: -- Handle PENDING action line only as REVERSE_PENDING and UPDATE_PENDING
589: -- lines can be handled generically by the action set model.

Line 644: ,p_validate_only => FND_API.G_FALSE

640: ,p_action_code => p_action_code
641: ,p_action_attribute1 => to_char(l_org_hierarchy_version_id)
642: ,p_action_attribute2 => to_char(l_new_start_org_id)
643: ,p_condition_tbl => p_action_set_line_cond_tbl
644: ,p_validate_only => FND_API.G_FALSE
645: ,p_commit => FND_API.G_FALSE
646: ,p_init_msg_list => FND_API.G_FALSE
647: ,x_return_status => x_return_status
648: ,x_msg_count => l_msg_count

Line 645: ,p_commit => FND_API.G_FALSE

641: ,p_action_attribute1 => to_char(l_org_hierarchy_version_id)
642: ,p_action_attribute2 => to_char(l_new_start_org_id)
643: ,p_condition_tbl => p_action_set_line_cond_tbl
644: ,p_validate_only => FND_API.G_FALSE
645: ,p_commit => FND_API.G_FALSE
646: ,p_init_msg_list => FND_API.G_FALSE
647: ,x_return_status => x_return_status
648: ,x_msg_count => l_msg_count
649: ,x_msg_data => l_msg_data);

Line 646: ,p_init_msg_list => FND_API.G_FALSE

642: ,p_action_attribute2 => to_char(l_new_start_org_id)
643: ,p_condition_tbl => p_action_set_line_cond_tbl
644: ,p_validate_only => FND_API.G_FALSE
645: ,p_commit => FND_API.G_FALSE
646: ,p_init_msg_list => FND_API.G_FALSE
647: ,x_return_status => x_return_status
648: ,x_msg_count => l_msg_count
649: ,x_msg_data => l_msg_data);
650:

Line 687: p_encoded => FND_API.G_TRUE

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);
691:

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
695: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
696: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: END IF;
700:
701: END IF; -- if status is PENDING
702: -- 4537865 : Included Exception Block

Line 705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

701: END IF; -- if status is PENDING
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 ;

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: ,x_log_level => 5);
777: END IF;
778:
779: -- Initialize the return status to success
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: --
783: -- Handle PENDING action line only as REVERSE_PENDING and UPDATE_PENDING
784: -- lines can be handled generically by the action set model.

Line 824: p_encoded => FND_API.G_TRUE

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);
828:

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

831: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
832: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
833: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
834: END IF;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: END IF;
837:
838: END IF; -- if status is PENDING
839: -- 4537865 : Included Exception Block

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

838: END IF; -- if status is PENDING
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 ;

Line 902: x_return_status := FND_API.G_RET_STS_SUCCESS;

898: ,x_log_level => 5);
899: END IF;
900:
901: -- Initialize the return status to success
902: x_return_status := FND_API.G_RET_STS_SUCCESS;
903: /* bug 4701745*/
904:
905: IF instr(l_email_address, ',') > 0 THEN
906: l_email_address := l_email_address || ',';

Line 981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

977:
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 ;

Line 1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM

1000: , p_object_id IN pa_action_sets.object_id%TYPE
1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
1006: , p_project_id IN pa_project_assignments.project_id%TYPE
1007: , p_insert_audit_flag IN VARCHAR2 := 'T'
1008: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
1006: , p_project_id IN pa_project_assignments.project_id%TYPE
1007: , p_insert_audit_flag IN VARCHAR2 := 'T'
1008: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1009: --, x_msg_count OUT NUMBER

Line 1081: x_return_status := FND_API.G_RET_STS_SUCCESS;

1077: ,x_log_level => 5);
1078: END IF;
1079:
1080: -- Initialize the return status to success
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;
1082:
1083: -- get the person_id of the notification recipients
1084: IF p_method = 'PROJECT_ROLE' THEN
1085:

Line 1152: p_encoded => FND_API.G_TRUE

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);
1156:

Line 1172: x_return_status := FND_API.G_RET_STS_ERROR;

1168: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
1169: PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl(l_index) := l_action_line_audit_rec;
1170: END LOOP;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;
1174: -- 4537865 : Included Exception Block
1175: EXCEPTION
1176: WHEN OTHERS THEN

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1173: END IF;
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 ;

Line 1343: x_return_status := FND_API.G_RET_STS_SUCCESS;

1339: ,x_log_level => 5);
1340: END IF;
1341:
1342: -- Initialize the return status to success
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Setting thresold value to run the process in background
1346: l_save_threshold := wf_engine.threshold;
1347: wf_engine.threshold := -1;

Line 1435: x_return_status := FND_API.G_RET_STS_ERROR;

1431: ,p_token1 => 'PERSON_NAME'
1432: ,p_value1 => p_ntf_recipient_name_tbl(i)
1433: );
1434:
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436:
1437: ELSE
1438:
1439: --dbms_output.put_line('sending notification to '|| l_ntf_recipient_user_name);

Line 1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1606: wf_engine.threshold := l_save_threshold;
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 ;

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652: ,x_log_level => 5);
1653: END IF;
1654:
1655: -- Initialize the return status to success
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657:
1658: --
1659: -- Handle PENDING action line only as REVERSE_PENDING and UPDATE_PENDING
1660: -- lines can be handled generically by the action set model.

Line 1677: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND p_insert_audit_flag = 'T' THEN

1673: ,p_staffing_priority_code => p_staffing_priority_code
1674: ,x_return_status => x_return_status );
1675:
1676: -- Insert into audit table
1677: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND p_insert_audit_flag = 'T' THEN
1678:
1679: -- insert into into the global audit record
1680: l_action_line_audit_rec.reason_code := 'CONDITION_MET';
1681: l_action_line_audit_rec.action_code := p_action_code;

Line 1695: p_encoded => FND_API.G_TRUE

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);
1699:

Line 1706: x_return_status := FND_API.G_RET_STS_ERROR;

1702: l_action_line_audit_rec.encoded_error_message := l_encoded_message_text;
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:

Line 1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1737: END IF; -- action status
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 ;

Line 1854: x_return_status := FND_API.G_RET_STS_SUCCESS;

1850: ,x_log_level => 5);
1851: END IF;
1852:
1853: -- Initialize the return status to success
1854: x_return_status := FND_API.G_RET_STS_SUCCESS;
1855:
1856: --
1857: -- CASE 1: the action status code is PENDING
1858: IF p_action_status_code = 'PENDING' THEN

Line 1909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1905: p_action_set_line_id_tbl => l_action_set_line_id_tbl2
1906: ,p_line_status_tbl => l_line_status_tbl2
1907: ,x_return_status => l_return_status
1908: );
1909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: END IF;
1912:
1913: -- Update the active flag to 'N' in the audit records

Line 1910: x_return_status := FND_API.G_RET_STS_ERROR;

1906: ,p_line_status_tbl => l_line_status_tbl2
1907: ,x_return_status => l_return_status
1908: );
1909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: END IF;
1912:
1913: -- Update the active flag to 'N' in the audit records
1914: FORALL i IN l_action_set_line_id_tbl2.FIRST ..l_action_set_line_id_tbl2.LAST

Line 1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1977: p_action_set_line_id_tbl => l_action_set_line_id_tbl
1978: ,p_line_status_tbl => l_line_status_tbl
1979: ,x_return_status => l_return_status
1980: );
1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: END IF;
1984:
1985: -- set the action status code to PENDING

Line 1982: x_return_status := FND_API.G_RET_STS_ERROR;

1978: ,p_line_status_tbl => l_line_status_tbl
1979: ,x_return_status => l_return_status
1980: );
1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: END IF;
1984:
1985: -- set the action status code to PENDING
1986: -- to re-execute the child records

Line 2008: l_perform_return_status := FND_API.G_RET_STS_SUCCESS;

2004:
2005: -- handle send notifications, send email and update staffing priority
2006: FOR i IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST LOOP
2007:
2008: l_perform_return_status := FND_API.G_RET_STS_SUCCESS;
2009: l_audit_action_code := NULL;
2010: --dbms_output.put_line('l_action_set_line_id: '||l_action_set_line_id_tbl(i));
2011:
2012: IF l_action_code_tbl(i) = 'ADVERTISEMENT_SEND_EMAIL' OR

Line 2026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2022: , p_insert_audit_flag => 'F'
2023: , x_return_status => l_return_status
2024:
2025: );
2026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2029: END IF;
2030:

Line 2027: x_return_status := FND_API.G_RET_STS_ERROR;

2023: , x_return_status => l_return_status
2024:
2025: );
2026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2029: END IF;
2030:
2031: -- Store difference action code in the audit table in cases

Line 2028: l_perform_return_status := FND_API.G_RET_STS_ERROR;

2024:
2025: );
2026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2029: END IF;
2030:
2031: -- Store difference action code in the audit table in cases
2032: -- of Cancel Advertisement and Reverse Cancel Advertisement

Line 2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2051: , p_insert_audit_flag => 'F'
2052: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2053:
2054: );
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2058: END IF;
2059:

Line 2056: x_return_status := FND_API.G_RET_STS_ERROR;

2052: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2053:
2054: );
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2058: END IF;
2059:
2060: -- Store difference action code in the audit table in cases

Line 2057: l_perform_return_status := FND_API.G_RET_STS_ERROR;

2053:
2054: );
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2058: END IF;
2059:
2060: -- Store difference action code in the audit table in cases
2061: -- of Cancel Advertisement and Reverse Cancel Advertisement

Line 2084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2080: , p_insert_audit_flag => 'F'
2081: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2082:
2083: );
2084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2087: END IF;
2088:

Line 2085: x_return_status := FND_API.G_RET_STS_ERROR;

2081: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2082:
2083: );
2084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2087: END IF;
2088:
2089: -- Store difference action code in the audit table in cases

Line 2086: l_perform_return_status := FND_API.G_RET_STS_ERROR;

2082:
2083: );
2084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2085: x_return_status := FND_API.G_RET_STS_ERROR;
2086: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2087: END IF;
2088:
2089: -- Store difference action code in the audit table in cases
2090: -- of Cancel Advertisement and Reverse Cancel Advertisement

Line 2111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2107: , p_record_version_number => l_record_version_number
2108: , p_insert_audit_flag => 'F'
2109: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2110: );
2111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2114: END IF;
2115:

Line 2112: x_return_status := FND_API.G_RET_STS_ERROR;

2108: , p_insert_audit_flag => 'F'
2109: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2110: );
2111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2114: END IF;
2115:
2116: -- Store difference action code in the audit table in cases

Line 2113: l_perform_return_status := FND_API.G_RET_STS_ERROR;

2109: , x_return_status => l_return_status -- Changed from x_return_status to l_return_status : 4537865
2110: );
2111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: l_perform_return_status := FND_API.G_RET_STS_ERROR;
2114: END IF;
2115:
2116: -- Store difference action code in the audit table in cases
2117: -- of Cancel Advertisement and Reverse Cancel Advertisement

Line 2189: IF p_insert_audit_flag = 'T' AND l_perform_return_status=FND_API.G_RET_STS_SUCCESS THEN

2185:
2186: END IF; -- if action_code = ..
2187:
2188: -- Insert into into the global audit record
2189: IF p_insert_audit_flag = 'T' AND l_perform_return_status=FND_API.G_RET_STS_SUCCESS THEN
2190:
2191: l_action_line_audit_rec.reason_code := l_audit_reason_code;
2192: l_action_line_audit_rec.action_code := l_audit_action_code;
2193: l_action_line_audit_rec.audit_attribute := l_audit_attribute_tbl(i);

Line 2209: ELSIF p_insert_audit_flag = 'T' AND l_perform_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2205:
2206: l_index := PA_ADVERTISEMENTS_PUB.g_action_line_audit_tbl.COUNT;
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

Line 2212: p_encoded => FND_API.G_TRUE

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);
2216:

Line 2233: x_return_status := FND_API.G_RET_STS_ERROR;

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
2237: EXCEPTION

Line 2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2235:
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 ;