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_LLIST_WORK_ACTION dependencies on FND_API

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

113:
114: l_uwq_action_data_list IEU_UWQ_WORK_PANEL_PUB.UWQ_ACTION_DATA_REC_LIST;
115: x_action_data VARCHAR2 (4000);
116:
117: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(2000);
120: BEGIN
121:

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

237: l_note_type VARCHAR2(30);
238: l_note_status VARCHAR2(1);
239: l_party_id NUMBER;
240:
241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: l_msg_count NUMBER;
243: l_msg_data VARCHAR2(2000);
244: l_task_id NUMBER;
245: l_jtf_note_id NUMBER;

Line 286: RAISE FND_API.G_EXC_ERROR;

282: l_return_status := 'E';
283: x_return_status := l_return_status;
284: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
285: FND_MSG_PUB.ADD;
286: RAISE FND_API.G_EXC_ERROR;
287: END;
288: END IF;
289:
290: Log_Mesg('Start parameter validation');

Line 297: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

293: --l_err_mesg := 'End date must be greater than start date.';
294: l_return_status := 'E';
295: END IF;
296:
297: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
298: x_return_status := l_return_status;
299: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
300: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
301: FND_MSG_PUB.ADD;

Line 302: RAISE FND_API.G_EXC_ERROR;

298: x_return_status := l_return_status;
299: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
300: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
301: FND_MSG_PUB.ADD;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: Log_Mesg('End parameter validation');
305: ELSE
306: EXIT;

Line 377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

373: x_task_id => l_task_id
374: );
375: Log_Mesg('End Create Task');
376:
377: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
378: x_return_status := l_return_status;
379: x_msg_count := l_msg_count;
380: x_msg_data := l_msg_data;
381: --x_task_id := l_task_id;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: --x_task_id := l_task_id;
382: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
383: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Task: ', FALSE);
384: -- FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: ELSE
387: x_return_status := l_return_status;
388: x_msg_count := l_msg_count;
389: x_msg_data := l_msg_data;

Line 423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 430: RAISE FND_API.G_EXC_ERROR;

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

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

507: l_note_status VARCHAR2(1);
508: l_party_id NUMBER;
509: l_sales_lead_id NUMBER;
510:
511: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
512: l_msg_count NUMBER;
513: l_msg_data VARCHAR2(2000);
514: l_jtf_note_id NUMBER;
515: BEGIN

Line 570: RAISE FND_API.G_EXC_ERROR;

566: l_return_status := 'E';
567: x_return_status := l_return_status;
568: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
569: FND_MSG_PUB.ADD;
570: RAISE FND_API.G_EXC_ERROR;
571: END;
572: ELSIF l_name = 'PERSON_ID' THEN
573: l_person_id := l_value;
574: END IF;

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: -- Begin Mod. Raam on 08.16.2002
633: IF l_data_set_id <= 1 AND
634: i = p_work_action_data.COUNT THEN
635: IF l_p_status_code IS NULL THEN
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: FND_MESSAGE.Set_Name('AST', 'AST_LEAD_STATUS_REQUIRED');
638: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;

Line 640: RAISE FND_API.G_EXC_ERROR;

636: x_return_status := FND_API.G_RET_STS_ERROR;
637: FND_MESSAGE.Set_Name('AST', 'AST_LEAD_STATUS_REQUIRED');
638: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642: END IF;
643: -- End Mod.
644:

Line 661: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

657: x_msg_data => l_msg_data
658: );
659: Log_Mesg('After Territory check ' ||l_return_status);
660:
661: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: x_return_status := l_return_status;
663: x_msg_count := l_msg_count;
664: x_msg_data := l_msg_data;
665: RAISE FND_API.G_EXC_ERROR;

Line 665: RAISE FND_API.G_EXC_ERROR;

661: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: x_return_status := l_return_status;
663: x_msg_count := l_msg_count;
664: x_msg_data := l_msg_data;
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668: Log_Mesg(l_sales_lead_id||' - '||l_status_code);
669: AST_UWQ_WRAPPER_PKG.UPDATE_LEAD

Line 696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

692: x_msg_count => l_msg_count,
693: x_msg_data => l_msg_data
694: );
695:
696: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: x_return_status := l_return_status;
698: x_msg_count := l_msg_count;
699: x_msg_data := l_msg_data;
700: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 703: RAISE FND_API.G_EXC_ERROR;

699: x_msg_data := l_msg_data;
700: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
701: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
702: -- FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_ERROR;
704: ELSE
705: x_return_status := l_return_status;
706: x_msg_count := l_msg_count;
707: x_msg_data := l_msg_data;

Line 737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

733: x_msg_count => l_msg_count,
734: x_msg_data => l_msg_data
735: );
736:
737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
738: Log_Mesg('Note Creation Failed.');
739: x_return_status := l_return_status;
740: x_msg_count := l_msg_count;
741: x_msg_data := l_msg_data;

Line 745: RAISE FND_API.G_EXC_ERROR;

741: x_msg_data := l_msg_data;
742: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
743: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
744: -- FND_MSG_PUB.ADD;
745: RAISE FND_API.G_EXC_ERROR;
746: ELSE
747: x_return_status := l_return_status;
748: x_msg_count := l_msg_count;
749: x_msg_data := l_msg_data;

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

806: l_note_status VARCHAR2(1);
807: l_party_id NUMBER;
808: l_jtf_note_id NUMBER;
809:
810: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
811: l_msg_count NUMBER;
812: l_msg_data VARCHAR2(2000);
813: BEGIN
814: Log_Mesg('Inside Reassign Lead');

Line 845: RAISE FND_API.G_EXC_ERROR;

841: l_return_status := 'E';
842: x_return_status := l_return_status;
843: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
844: FND_MSG_PUB.ADD;
845: RAISE FND_API.G_EXC_ERROR;
846: END;
847: ELSIF l_name = 'ADMIN_GROUP_ID' THEN
848: l_admin_group_id := TO_NUMBER(l_value);
849: ELSIF l_name = 'ADMIN_FLAG' THEN

Line 904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

900: x_msg_data => l_msg_data
901: );
902: Log_Mesg('After Territory check');
903:
904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: x_return_status := l_return_status;
906: x_msg_count := l_msg_count;
907: x_msg_data := l_msg_data;
908: RAISE FND_API.G_EXC_ERROR;

Line 908: RAISE FND_API.G_EXC_ERROR;

904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: x_return_status := l_return_status;
906: x_msg_count := l_msg_count;
907: x_msg_data := l_msg_data;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: x_return_status := l_return_status;

Line 911: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

907: x_msg_data := l_msg_data;
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;
910:
911: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: x_return_status := l_return_status;
913: x_msg_count := l_msg_count;
914: x_msg_data := l_msg_data;
915: RAISE FND_API.G_EXC_ERROR;

Line 915: RAISE FND_API.G_EXC_ERROR;

911: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: x_return_status := l_return_status;
913: x_msg_count := l_msg_count;
914: x_msg_data := l_msg_data;
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917:
918: AST_UWQ_WRAPPER_PKG.REASSIGN_LEAD
919: (

Line 936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

932: x_msg_count => l_msg_count,
933: x_msg_data => l_msg_data
934: );
935:
936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
937: x_return_status := l_return_status;
938: x_msg_count := l_msg_count;
939: x_msg_data := l_msg_data;
940: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 943: RAISE FND_API.G_EXC_ERROR;

939: x_msg_data := l_msg_data;
940: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
941: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Reassign Lead: ', FALSE);
942: -- FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE
945: x_return_status := l_return_status;
946: x_msg_count := l_msg_count;
947: x_msg_data := l_msg_data;

Line 977: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

973: x_msg_count => l_msg_count,
974: x_msg_data => l_msg_data
975: );
976:
977: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
978: Log_Mesg('Note Creation Failed.');
979: x_return_status := l_return_status;
980: x_msg_count := l_msg_count;
981: x_msg_data := l_msg_data;

Line 985: RAISE FND_API.G_EXC_ERROR;

981: x_msg_data := l_msg_data;
982: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
983: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
984: -- FND_MSG_PUB.ADD;
985: RAISE FND_API.G_EXC_ERROR;
986: ELSE
987: x_return_status := l_return_status;
988: x_msg_count := l_msg_count;
989: x_msg_data := l_msg_data;

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

1068: l_note_status VARCHAR2(1);
1069: l_party_id NUMBER;
1070: l_jtf_note_id NUMBER;
1071:
1072: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1073: l_msg_count NUMBER;
1074: l_msg_data VARCHAR2(2000);
1075: l_opp_id NUMBER;
1076: l_app_launch VARCHAR2(1);

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130: l_return_status := 'E';
1131: x_return_status := l_return_status;
1132: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1133: FND_MSG_PUB.ADD;
1134: RAISE FND_API.G_EXC_ERROR;
1135: END;
1136: ELSIF l_name = 'PERSON_ID' THEN
1137: l_person_id := l_value;
1138: END IF;

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR;

1197:
1198: IF l_data_set_id <= 1 AND
1199: i = p_work_action_data.COUNT THEN
1200: IF l_p_status_code IS NULL THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MESSAGE.Set_Name('AST', 'AST_LEAD_STATUS_REQUIRED');
1203: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
1204: FND_MSG_PUB.ADD;
1205: RAISE FND_API.G_EXC_ERROR;

Line 1205: RAISE FND_API.G_EXC_ERROR;

1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MESSAGE.Set_Name('AST', 'AST_LEAD_STATUS_REQUIRED');
1203: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
1204: FND_MSG_PUB.ADD;
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207: END IF;
1208:
1209: IF l_prev_data_set_id <> l_data_set_id OR

Line 1225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1221: x_msg_data => l_msg_data
1222: );
1223: Log_Mesg('After Territory check ' ||l_return_status);
1224:
1225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1226: x_return_status := l_return_status;
1227: x_msg_count := l_msg_count;
1228: x_msg_data := l_msg_data;
1229: RAISE FND_API.G_EXC_ERROR;

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1226: x_return_status := l_return_status;
1227: x_msg_count := l_msg_count;
1228: x_msg_data := l_msg_data;
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232: Log_Mesg(l_sales_lead_id||' - '||l_status_code);
1233: AST_UWQ_WRAPPER_PKG.UPDATE_LEAD

Line 1260: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1256: x_msg_count => l_msg_count,
1257: x_msg_data => l_msg_data
1258: );
1259:
1260: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1261: x_return_status := l_return_status;
1262: x_msg_count := l_msg_count;
1263: x_msg_data := l_msg_data;
1264: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1267: RAISE FND_API.G_EXC_ERROR;

1263: x_msg_data := l_msg_data;
1264: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1265: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Update Lead: ', FALSE);
1266: -- FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: ELSE
1269: x_return_status := l_return_status;
1270: x_msg_count := l_msg_count;
1271: x_msg_data := l_msg_data;

Line 1292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1288: x_app_launch => l_app_launch,
1289: x_opportunity_id => l_opp_id
1290: );
1291:
1292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1293: x_return_status := l_return_status;
1294: x_msg_count := l_msg_count;
1295: x_msg_data := l_msg_data;
1296: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1299: RAISE FND_API.G_EXC_ERROR;

1295: x_msg_data := l_msg_data;
1296: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1297: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Convert Lead to Opportunity: ', FALSE);
1298: -- FND_MSG_PUB.ADD;
1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSE
1301: x_return_status := l_return_status;
1302: x_msg_count := l_msg_count;
1303: x_msg_data := l_msg_data;

Line 1334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1330: x_msg_count => l_msg_count,
1331: x_msg_data => l_msg_data
1332: );
1333:
1334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1335: Log_Mesg('Note Creation Failed.');
1336: x_return_status := l_return_status;
1337: x_msg_count := l_msg_count;
1338: x_msg_data := l_msg_data;

Line 1342: RAISE FND_API.G_EXC_ERROR;

1338: x_msg_data := l_msg_data;
1339: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1340: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1341: -- FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: ELSE
1344: x_return_status := l_return_status;
1345: x_msg_count := l_msg_count;
1346: x_msg_data := l_msg_data;

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

1397:
1398: l_notes VARCHAR2(2000);
1399: l_party_id NUMBER;
1400:
1401: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1402: l_msg_count NUMBER;
1403: l_msg_data VARCHAR2(2000);
1404: l_task_id NUMBER;
1405: l_jtf_note_id NUMBER;

Line 1432: RAISE FND_API.G_EXC_ERROR;

1428: l_return_status := 'E';
1429: x_return_status := l_return_status;
1430: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1431: FND_MSG_PUB.ADD;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END;
1434: END IF;
1435: ELSE
1436: EXIT;

Line 1491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1487: x_msg_data => l_msg_data
1488: );
1489: Log_Mesg('End Create Note');
1490:
1491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1492: x_return_status := l_return_status;
1493: x_msg_count := l_msg_count;
1494: x_msg_data := l_msg_data;
1495: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1498: RAISE FND_API.G_EXC_ERROR;

1494: x_msg_data := l_msg_data;
1495: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1496: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1497: -- FND_MSG_PUB.ADD;
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSE
1500: x_return_status := l_return_status;
1501: x_msg_count := l_msg_count;
1502: x_msg_data := l_msg_data;