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

Line 81: v_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

77: v_contact_tbl AS_OPPORTUNITY_PUB.contact_tbl_Type:=as_api_records_pkg.get_p_contact_tbl;
78: v_contact_out_tbl AS_OPPORTUNITY_PUB.contact_out_tbl_Type:=as_api_records_pkg.get_p_contact_out_tbl;
79: v_header_rec AS_OPPORTUNITY_PUB.header_rec_Type:=as_api_records_pkg.get_p_header_rec;
80:
81: v_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
82:
83:
84: v_msg_count NUMBER;
85: v_msg_data VARCHAR2(2000);

Line 135: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

131: x_msg_data => v_msg_data
132: );
133:
134:
135: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: x_return_status := v_return_status;
137: x_msg_count := v_msg_count;
138: x_msg_data := v_msg_data;
139: RAISE FND_API.G_EXC_ERROR;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: x_return_status := v_return_status;
137: x_msg_count := v_msg_count;
138: x_msg_data := v_msg_data;
139: RAISE FND_API.G_EXC_ERROR;
140: ELSE
141: x_return_status := v_return_status;
142: x_msg_count := v_msg_count;
143: x_msg_data := v_msg_data;

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

220:
221: l_uwq_action_data_list IEU_UWQ_WORK_PANEL_PUB.UWQ_ACTION_DATA_REC_LIST;
222: x_action_data VARCHAR2 (4000);
223:
224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
225: l_msg_count NUMBER;
226: l_msg_data VARCHAR2(2000);
227: BEGIN
228:

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

320:
321: l_notes VARCHAR2(2000);
322: l_party_id NUMBER;
323:
324: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
325: l_msg_count NUMBER;
326: l_msg_data VARCHAR2(2000);
327: l_task_id NUMBER;
328: l_jtf_note_id NUMBER;

Line 369: RAISE FND_API.G_EXC_ERROR;

365: l_return_status := 'E';
366: x_return_status := l_return_status;
367: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
368: FND_MSG_PUB.ADD;
369: RAISE FND_API.G_EXC_ERROR;
370: END;
371: END IF;
372:
373: Log_Mesg('Start parameter validation');

Line 380: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

376: --l_err_mesg := 'End date must be greater than start date.';
377: l_return_status := 'E';
378: END IF;
379:
380: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
381: x_return_status := l_return_status;
382: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
383: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
384: FND_MSG_PUB.ADD;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: x_return_status := l_return_status;
382: FND_MESSAGE.Set_Name('AST', 'AST_OPP_TASK_DATE');
383: --FND_MESSAGE.Set_Token('TEXT', l_err_mesg, FALSE);
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387: Log_Mesg('End parameter validation');
388: ELSE
389: EXIT;

Line 456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

452: x_task_id => l_task_id
453: );
454: Log_Mesg('End Create Task');
455:
456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: x_return_status := l_return_status;
458: x_msg_count := l_msg_count;
459: x_msg_data := l_msg_data;
460: --x_task_id := l_task_id;

Line 464: RAISE FND_API.G_EXC_ERROR;

460: --x_task_id := l_task_id;
461: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
462: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Task: ', FALSE);
463: -- FND_MSG_PUB.ADD;
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: x_return_status := l_return_status;
467: x_msg_count := l_msg_count;
468: x_msg_data := l_msg_data;

Line 502: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

498: x_msg_data => l_msg_data
499: );
500: Log_Mesg('End Create Note');
501:
502: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
503: x_return_status := l_return_status;
504: x_msg_count := l_msg_count;
505: x_msg_data := l_msg_data;
506: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 509: RAISE FND_API.G_EXC_ERROR;

505: x_msg_data := l_msg_data;
506: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
507: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
508: -- FND_MSG_PUB.ADD;
509: RAISE FND_API.G_EXC_ERROR;
510: ELSE
511: x_return_status := l_return_status;
512: x_msg_count := l_msg_count;
513: x_msg_data := l_msg_data;

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

617: l_outcome_id NUMBER;
618: l_reason_id NUMBER;
619: l_result_id NUMBER;
620:
621: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2(2000);
624: l_jtf_note_id NUMBER;
625: l_err_mesg VARCHAR2(500);

Line 690: RAISE FND_API.G_EXC_ERROR;

686: WHEN VALUE_ERROR THEN
687: x_return_status := 'E';
688: FND_MESSAGE.Set_Name('AST', 'AST_OPP_CUST_SET_CHECK');
689: FND_MSG_PUB.ADD;
690: RAISE FND_API.G_EXC_ERROR;
691: END;
692: END if;
693: --added for bug#4676975 --End
694:

Line 766: RAISE FND_API.G_EXC_ERROR;

762: l_return_status := 'E';
763: x_return_status := l_return_status;
764: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
765: FND_MSG_PUB.ADD;
766: RAISE FND_API.G_EXC_ERROR;
767: END;
768: END IF;
769: END IF;
770: END LOOP;

Line 889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

885:
886: if l_temp is not null then
887: l_return_status := 'E';
888: end if;
889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
890: x_return_status := l_return_status;
891: FND_MESSAGE.Set_Name('ASN', 'ASN_PROPOSALS_QUOTES_ERR');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;

Line 893: RAISE FND_API.G_EXC_ERROR;

889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
890: x_return_status := l_return_status;
891: FND_MESSAGE.Set_Name('ASN', 'ASN_PROPOSALS_QUOTES_ERR');
892: FND_MSG_PUB.ADD;
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;
895:
896: end if;
897: --code added for R12 enhancement --End

Line 909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

905: l_p_close_competitor_id IS NULL THEN
906: l_return_status := 'E';
907: END IF;
908:
909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: x_return_status := l_return_status;
911: FND_MESSAGE.Set_Name('AS', 'API_CLOSE_COMPETITOR_REQUIRED');
912: FND_MSG_PUB.ADD;
913: RAISE FND_API.G_EXC_ERROR;

Line 913: RAISE FND_API.G_EXC_ERROR;

909: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: x_return_status := l_return_status;
911: FND_MESSAGE.Set_Name('AS', 'API_CLOSE_COMPETITOR_REQUIRED');
912: FND_MSG_PUB.ADD;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF; */
915: --code modified for R12 enhancement --end
916: Log_Mesg('End parameter validation');
917: --End of bug # 3516066

Line 935: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

931: x_msg_count => l_msg_count,
932: x_msg_data => l_msg_data
933: );
934:
935: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
936: x_return_status := l_return_status;
937: x_msg_count := l_msg_count;
938: x_msg_data := l_msg_data;
939: RAISE FND_API.G_EXC_ERROR;

Line 939: RAISE FND_API.G_EXC_ERROR;

935: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
936: x_return_status := l_return_status;
937: x_msg_count := l_msg_count;
938: x_msg_data := l_msg_data;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:
942:
943:

Line 983: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

979: x_msg_data => l_msg_data,
980: x_lead_id => l_temp_id
981: );
982:
983: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: x_return_status := l_return_status;
985: x_msg_count := l_msg_count;
986: x_msg_data := l_msg_data;
987: RAISE FND_API.G_EXC_ERROR;

Line 987: RAISE FND_API.G_EXC_ERROR;

983: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: x_return_status := l_return_status;
985: x_msg_count := l_msg_count;
986: x_msg_data := l_msg_data;
987: RAISE FND_API.G_EXC_ERROR;
988: ELSE
989: --Code added for R12 enhancement ---Start
990: if l_customer_id is not null and
991: l_old_customer_id <> l_customer_id then

Line 1002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

998: x_msg_count => l_msg_count,
999: x_msg_data => l_msg_data,
1000: x_return_status => l_return_status);
1001:
1002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: x_return_status := l_return_status;
1004: x_msg_count := l_msg_count;
1005: x_msg_data := l_msg_data;
1006: RAISE FND_API.G_EXC_ERROR;

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: x_return_status := l_return_status;
1004: x_msg_count := l_msg_count;
1005: x_msg_data := l_msg_data;
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008:
1009: Salesteam_Update(p_customer_id => l_customer_id,
1010: p_lead_id=> l_lead_id);

Line 1050: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1046: x_msg_data => l_msg_data
1047: );
1048: Log_Mesg('End Create Note');
1049:
1050: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1051: x_return_status := l_return_status;
1052: x_msg_count := l_msg_count;
1053: x_msg_data := l_msg_data;
1054: RAISE FND_API.G_EXC_ERROR;

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1051: x_return_status := l_return_status;
1052: x_msg_count := l_msg_count;
1053: x_msg_data := l_msg_data;
1054: RAISE FND_API.G_EXC_ERROR;
1055: ELSE
1056: x_return_status := l_return_status;
1057: x_msg_count := l_msg_count;
1058: x_msg_data := l_msg_data;

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

1109:
1110: l_notes VARCHAR2(2000);
1111: l_party_id NUMBER;
1112:
1113: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1114: l_msg_count NUMBER;
1115: l_msg_data VARCHAR2(2000);
1116: l_task_id NUMBER;
1117: l_jtf_note_id NUMBER;

Line 1144: RAISE FND_API.G_EXC_ERROR;

1140: l_return_status := 'E';
1141: x_return_status := l_return_status;
1142: FND_MESSAGE.Set_Name('AST', 'AST_NOTE_LENGTH_ERROR');
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_ERROR;
1145: END;
1146: END IF;
1147: ELSE
1148: EXIT;

Line 1203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1199: x_msg_data => l_msg_data
1200: );
1201: Log_Mesg('End Create Note');
1202:
1203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1204: x_return_status := l_return_status;
1205: x_msg_count := l_msg_count;
1206: x_msg_data := l_msg_data;
1207: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');

Line 1210: RAISE FND_API.G_EXC_ERROR;

1206: x_msg_data := l_msg_data;
1207: -- FND_MESSAGE.Set_Name('AST', 'AST_API_ERR');
1208: -- FND_MESSAGE.Set_Token('TEXT', 'Failed to Creat Note', FALSE);
1209: -- FND_MSG_PUB.ADD;
1210: RAISE FND_API.G_EXC_ERROR;
1211: ELSE
1212: x_return_status := l_return_status;
1213: x_msg_count := l_msg_count;
1214: x_msg_data := l_msg_data;