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.AST_UWQ_MLIST_WORK_ACTION dependencies on FND_API

Line 56: WHEN fnd_api.g_exc_unexpected_error THEN

52: last_update_login = l_last_update_login
53: WHERE list_entry_id = p_list_entry_id
54: AND list_header_id = p_list_header_id;
55: EXCEPTION
56: WHEN fnd_api.g_exc_unexpected_error THEN
57: ROLLBACK TO lock_ams_list;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: FND_MSG_PUB.count_and_get
60: ( p_count => x_msg_count,

Line 58: x_return_status := fnd_api.g_ret_sts_unexp_error;

54: AND list_header_id = p_list_header_id;
55: EXCEPTION
56: WHEN fnd_api.g_exc_unexpected_error THEN
57: ROLLBACK TO lock_ams_list;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: FND_MSG_PUB.count_and_get
60: ( p_count => x_msg_count,
61: p_data => x_msg_data
62: );

Line 67: x_return_status := FND_API.G_Ret_Sts_Unexp_Error;

63: WHEN OTHERS THEN
64: ROLLBACK TO lock_ams_list;
65: FND_MESSAGE.set_name ('AST', 'JTF_TASK_UNKNOWN_ERROR');
66: FND_MESSAGE.set_token ('P_TEXT', SQLCODE || SQLERRM);
67: x_return_status := FND_API.G_Ret_Sts_Unexp_Error;
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count,
70: p_data => x_msg_data
71: );

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: ( p_count => x_msg_count,
70: p_data => x_msg_data
71: );
72: END;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74: COMMIT;
75: END; -- End procedure MLIST_UPDATE_OUTCOME
76:
77: PROCEDURE MLIST_WORK_NODE_REFRESH

Line 325: RAISE FND_API.G_EXC_ERROR;

321: l_return_status := 'E';
322: x_return_status := l_return_status;
323: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;
327: END IF;
328: ELSE
329: EXIT;

Line 375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

371: x_msg_count => l_msg_count,
372: x_msg_data => l_msg_data
373: );
374:
375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
376: x_return_status := l_return_status;
377: x_msg_count := l_msg_count;
378: x_msg_data := l_msg_data;
379: --x_task_id := l_task_id;

Line 383: RAISE FND_API.G_EXC_ERROR;

379: --x_task_id := l_task_id;
380: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
381: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
382: -- FND_MSG_PUB.ADD;
383: RAISE FND_API.G_EXC_ERROR;
384: ELSE
385: x_return_status := l_return_status;
386: x_msg_count := l_msg_count;
387: x_msg_data := l_msg_data;

Line 421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

417: x_msg_data => l_msg_data
418: );
419: Log_Mesg('End Create Note');
420:
421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
422: x_return_status := l_return_status;
423: x_msg_count := l_msg_count;
424: x_msg_data := l_msg_data;
425: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 428: RAISE FND_API.G_EXC_ERROR;

424: x_msg_data := l_msg_data;
425: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
426: -- FND_MESSAGr.Set_Token('TEXT','Failed to Create Note', FALSE);
427: -- FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: ELSE
430: x_return_status := l_return_status;
431: x_msg_count := l_msg_count;
432: x_msg_data := l_msg_data;

Line 506: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

502: l_outcome_id NUMBER;
503: l_reason_id NUMBER;
504: l_result_id NUMBER;
505:
506: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(2000);
509: l_task_id NUMBER;
510: l_jtf_note_id NUMBER;

Line 552: RAISE FND_API.G_EXC_ERROR;

548: l_return_status := 'E';
549: x_return_status := l_return_status;
550: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
551: FND_MSG_PUB.ADD;
552: RAISE FND_API.G_EXC_ERROR;
553: END;
554: ELSIF l_name = 'OUTCOME_ID' THEN
555: l_outcome_id := l_value;
556: ELSIF l_name = 'REASON_ID' THEN

Line 569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

565: --l_err_mesg := 'End date must be greater than start date.';
566: l_return_status := 'E';
567: END IF;
568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: x_return_status := l_return_status;
571: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
572: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
573: FND_MSG_PUB.ADD;

Line 574: RAISE FND_API.G_EXC_ERROR;

570: x_return_status := l_return_status;
571: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
572: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576: Log_Mesg('End parameter validation');
577: ELSE
578: EXIT;

Line 657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

653: x_task_id => l_task_id
654: );
655: Log_Mesg('End Create Task');
656:
657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: x_return_status := l_return_status;
659: x_msg_count := l_msg_count;
660: x_msg_data := l_msg_data;
661: --x_task_id := l_task_id;

Line 665: RAISE FND_API.G_EXC_ERROR;

661: --x_task_id := l_task_id;
662: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
663: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Task: ', FALSE);
664: -- FND_MSG_PUB.ADD;
665: RAISE FND_API.G_EXC_ERROR;
666: ELSE
667: x_return_status := l_return_status;
668: x_msg_count := l_msg_count;
669: x_msg_data := l_msg_data;

Line 688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

684: x_msg_count => l_msg_count,
685: x_msg_data => l_msg_data
686: );
687:
688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
689: x_return_status := l_return_status;
690: x_msg_count := l_msg_count;
691: x_msg_data := l_msg_data;
692: --x_task_id := l_task_id;

Line 696: RAISE FND_API.G_EXC_ERROR;

692: --x_task_id := l_task_id;
693: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
694: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
695: -- FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: x_return_status := l_return_status;
699: x_msg_count := l_msg_count;
700: x_msg_data := l_msg_data;

Line 731: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

727: x_msg_data => l_msg_data
728: );
729: Log_Mesg('End Create Note');
730:
731: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
732: x_return_status := l_return_status;
733: x_msg_count := l_msg_count;
734: x_msg_data := l_msg_data;
735: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 738: RAISE FND_API.G_EXC_ERROR;

734: x_msg_data := l_msg_data;
735: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
736: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
737: -- FND_MSG_PUB.ADD;
738: RAISE FND_API.G_EXC_ERROR;
739: ELSE
740: x_return_status := l_return_status;
741: x_msg_count := l_msg_count;
742: x_msg_data := l_msg_data;

Line 818: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

814: l_outcome_id NUMBER;
815: l_reason_id NUMBER;
816: l_result_id NUMBER;
817:
818: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
819: l_msg_count NUMBER;
820: l_msg_data VARCHAR2(2000);
821: l_sales_lead_id NUMBER;
822: l_jtf_note_id NUMBER;

Line 906: RAISE FND_API.G_EXC_ERROR;

902: l_return_status := 'E';
903: x_return_status := l_return_status;
904: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
905: FND_MSG_PUB.ADD;
906: RAISE FND_API.G_EXC_ERROR;
907: END;
908: ELSIF l_name = 'OUTCOME_ID' THEN
909: l_outcome_id := l_value;
910: ELSIF l_name = 'REASON_ID' THEN

Line 926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

922: x_msg_count => l_msg_count,
923: x_msg_data => l_msg_data
924: );
925:
926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: x_return_status := l_return_status;
928: x_msg_count := l_msg_count;
929: x_msg_data := l_msg_data;
930: RAISE FND_API.G_EXC_ERROR;

Line 930: RAISE FND_API.G_EXC_ERROR;

926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: x_return_status := l_return_status;
928: x_msg_count := l_msg_count;
929: x_msg_data := l_msg_data;
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932:
933: IF l_list_source_type IN ( 'PERSON_LIST','CONSUMER' ) THEN
934: l_customer_id := l_contact_party_id;

Line 964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

960: x_msg_count => l_msg_count,
961: x_msg_data => l_msg_data
962: );
963:
964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: x_return_status := l_return_status;
966: x_msg_count := l_msg_count;
967: x_msg_data := l_msg_data;
968: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 971: RAISE FND_API.G_EXC_ERROR;

967: x_msg_data := l_msg_data;
968: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
969: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Lead: ', FALSE);
970: -- FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: ELSE
973: x_return_status := l_return_status;
974: x_msg_count := l_msg_count;
975: x_msg_data := l_msg_data;

Line 993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

989: x_msg_count => l_msg_count,
990: x_msg_data => l_msg_data
991: );
992:
993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
994: x_return_status := l_return_status;
995: x_msg_count := l_msg_count;
996: x_msg_data := l_msg_data;
997: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1000: RAISE FND_API.G_EXC_ERROR;

996: x_msg_data := l_msg_data;
997: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
998: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
999: -- FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: ELSE
1002: x_return_status := l_return_status;
1003: x_msg_count := l_msg_count;
1004: x_msg_data := l_msg_data;

Line 1035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1031: x_msg_data => l_msg_data
1032: );
1033: Log_Mesg('End Create Note');
1034:
1035: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1036: x_return_status := l_return_status;
1037: x_msg_count := l_msg_count;
1038: x_msg_data := l_msg_data;
1039: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: x_msg_data := l_msg_data;
1039: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1040: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1041: -- FND_MSG_PUB.ADD;
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSE
1044: x_return_status := l_return_status;
1045: x_msg_count := l_msg_count;
1046: x_msg_data := l_msg_data;

Line 1127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1123: l_customer_budget NUMBER;
1124: l_currency_code varchar2(60);
1125: l_vehicle_response_code varchar2(2000);
1126:
1127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1128: l_msg_count NUMBER;
1129: l_msg_data VARCHAR2(2000);
1130: l_lead_id NUMBER;
1131: l_jtf_note_id NUMBER;

Line 1213: RAISE FND_API.G_EXC_ERROR;

1209: l_return_status := 'E';
1210: x_return_status := l_return_status;
1211: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1212: FND_MSG_PUB.ADD;
1213: RAISE FND_API.G_EXC_ERROR;
1214: END;
1215: ELSIF l_name = 'OUTCOME_ID' THEN
1216: l_outcome_id := l_value;
1217: ELSIF l_name = 'REASON_ID' THEN

Line 1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1235: x_msg_count => l_msg_count,
1236: x_msg_data => l_msg_data
1237: );
1238:
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: x_return_status := l_return_status;
1241: x_msg_count := l_msg_count;
1242: x_msg_data := l_msg_data;
1243: RAISE FND_API.G_EXC_ERROR;

Line 1243: RAISE FND_API.G_EXC_ERROR;

1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: x_return_status := l_return_status;
1241: x_msg_count := l_msg_count;
1242: x_msg_data := l_msg_data;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:
1246: Log_Mesg('Start parameter validation');
1247: --code commented for R12 enhancement --Start

Line 1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1251: l_return_status := 'E';
1252: END IF;
1253:
1254:
1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1256: x_return_status := l_return_status;
1257: FND_MESSAGE.Set_Name('AS', 'API_CLOSE_COMPETITOR_REQUIRED');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1256: x_return_status := l_return_status;
1257: FND_MESSAGE.Set_Name('AS', 'API_CLOSE_COMPETITOR_REQUIRED');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF; */
1261: --code commented for R12 enhancement --end
1262: Log_Mesg('End parameter validation');
1263:

Line 1311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1307: x_msg_data => l_msg_data,
1308: x_lead_id => l_lead_id
1309: );
1310:
1311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1312: x_return_status := l_return_status;
1313: x_msg_count := l_msg_count;
1314: x_msg_data := l_msg_data;
1315: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1318: RAISE FND_API.G_EXC_ERROR;

1314: x_msg_data := l_msg_data;
1315: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1316: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Opportunity: ', FALSE);
1317: -- FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: ELSE
1320: x_return_status := l_return_status;
1321: x_msg_count := l_msg_count;
1322: x_msg_data := l_msg_data;

Line 1340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1336: x_msg_count => l_msg_count,
1337: x_msg_data => l_msg_data
1338: );
1339:
1340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1341: x_return_status := l_return_status;
1342: x_msg_count := l_msg_count;
1343: x_msg_data := l_msg_data;
1344: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1347: RAISE FND_API.G_EXC_ERROR;

1343: x_msg_data := l_msg_data;
1344: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1345: -- FND_MESSAGE.Set_Token('TEXT', 'Failed update marketing list: ', FALSE);
1346: -- FND_MSG_PUB.ADD;
1347: RAISE FND_API.G_EXC_ERROR;
1348: ELSE
1349: x_return_status := l_return_status;
1350: x_msg_count := l_msg_count;
1351: x_msg_data := l_msg_data;

Line 1382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1378: x_msg_data => l_msg_data
1379: );
1380: Log_Mesg('End Create Note');
1381:
1382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1383: x_return_status := l_return_status;
1384: x_msg_count := l_msg_count;
1385: x_msg_data := l_msg_data;
1386: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: x_msg_data := l_msg_data;
1386: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1387: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1388: -- FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: x_return_status := l_return_status;
1392: x_msg_count := l_msg_count;
1393: x_msg_data := l_msg_data;

Line 1441: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1437: l_outcome_id NUMBER;
1438: l_reason_id NUMBER;
1439: l_result_id NUMBER;
1440:
1441: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1442: l_msg_count NUMBER;
1443: l_msg_data VARCHAR2(2000);
1444: l_jtf_note_id NUMBER;
1445: l_err_mesg VARCHAR2(500);

Line 1471: RAISE FND_API.G_EXC_ERROR;

1467: l_return_status := 'E';
1468: x_return_status := l_return_status;
1469: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: END;
1473: ELSIF l_name = 'OUTCOME_ID' THEN
1474: l_outcome_id := l_value;
1475: ELSIF l_name = 'REASON_ID' THEN

Line 1541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1537: x_msg_data => l_msg_data
1538: );
1539: Log_Mesg('End Create Note');
1540:
1541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1542: x_return_status := l_return_status;
1543: x_msg_count := l_msg_count;
1544: x_msg_data := l_msg_data;
1545: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1548: RAISE FND_API.G_EXC_ERROR;

1544: x_msg_data := l_msg_data;
1545: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1546: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1547: -- FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: ELSE
1550: x_return_status := l_return_status;
1551: x_msg_count := l_msg_count;
1552: x_msg_data := l_msg_data;