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

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: END LOOP;
181: l_result:=l_result||'';
182:
183: CSM_UTIL_PKG.LOG('Leaving q_get_address_DFF ', 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: p_result:='S:'||l_result||'';
186: EXCEPTION
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: p_result:='S:'||l_result||'';
186: EXCEPTION
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: x_error_message := 'Exception occurred in q_get_address_DFF: ' || substr(sqlerrm,0,1000);
190: p_result:='E:'||translateString(x_error_message);
191: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_EXCEPTION);
192: END q_get_address_DFF;

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236:
237: CSM_UTIL_PKG.LOG('HR Location_id:'||l_hr_loc_id , 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
238:
239: IF l_hr_loc_id IS NULL THEN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: p_result:='E:Passed TO Location is invalid.';
242: return;
243: END IF;
244:

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: l_result:=l_result||'';
262: END LOOP;
263:
264: CSM_UTIL_PKG.LOG('Leaving q_ship_methods ', 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: p_result:='S:'||l_result||'';
267: EXCEPTION
268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: p_result:='S:'||l_result||'';
267: EXCEPTION
268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: x_error_message := 'Exception occurred in q_ship_methods: ' || substr(sqlerrm,0,1000);
271: p_result:='E:'||translateString(x_error_message);
272: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_EXCEPTION);
273: END q_ship_methods;

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: l_result:=l_result||'';
342: END LOOP;
343:
344: CSM_UTIL_PKG.LOG('Leaving q_receivable_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: p_result:='S:'||l_result||'';
347: EXCEPTION
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: p_result:='S:'||l_result||'';
347: EXCEPTION
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350: x_error_message := 'Exception occurred in q_receivable_parts: ' || substr(sqlerrm,0,1000);
351: p_result:='E:'||translateString(x_error_message);
352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_EXCEPTION);
353: END q_receivable_parts;

Line 567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

563: x_msg_count => l_msg_count,
564: x_msg_data => l_msg_data
565: );
566:
567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
568: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
569: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
570: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
571: l_result:=l_result||''||translateString(l_msg_data)||''||'';

Line 601: x_return_status := FND_API.G_RET_STS_SUCCESS;

597: close c_part_line;
598: END LOOP;
599:
600: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602: p_result:='S:'||l_result||'';
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: ROLLBACK;

Line 604: WHEN FND_API.G_EXC_ERROR THEN

600: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602: p_result:='S:'||l_result||'';
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: ROLLBACK;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

Line 606: x_return_status := FND_API.G_RET_STS_SUCCESS;

602: p_result:='S:'||l_result||'';
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: ROLLBACK;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
609: p_result:='E:'||translateString(x_error_message);
610: WHEN OTHERS THEN

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
609: p_result:='E:'||translateString(x_error_message);
610: WHEN OTHERS THEN
611: ROLLBACK;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: x_error_message := 'Exception occurred in q_receive_parts: ' || substr(sqlerrm,0,1000);
614: p_result:='E:'||translateString(x_error_message);
615: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);
616: end q_receive_parts2;

Line 836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

832: x_msg_count => l_msg_count,
833: x_msg_data => l_msg_data
834: );
835:
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
838: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
839: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
840: IF(r_part_line.serial_number IS NOT NULL) THEN

Line 882: x_return_status := FND_API.G_RET_STS_SUCCESS;

878: l_result:=l_result||'';
879: END LOOP;
880:
881: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883: p_result:='S:'||l_result||'';
884: EXCEPTION
885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK;

Line 885: WHEN FND_API.G_EXC_ERROR THEN

881: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883: p_result:='S:'||l_result||'';
884: EXCEPTION
885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK;
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

Line 887: x_return_status := FND_API.G_RET_STS_SUCCESS;

883: p_result:='S:'||l_result||'';
884: EXCEPTION
885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK;
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
890: p_result:='E:'||translateString(x_error_message);
891: WHEN OTHERS THEN

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
890: p_result:='E:'||translateString(x_error_message);
891: WHEN OTHERS THEN
892: ROLLBACK;
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894: x_error_message := 'Exception occurred in q_receive_parts: ' || substr(sqlerrm,0,1000);
895: p_result:='E:'||translateString(x_error_message);
896: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);
897: end q_receive_parts;

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

902: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
903: l_header_rec csp_parts_requirement.Header_rec_type;
904: l_msg_count NUMBER;
905: l_msg_data VARCHAR2(2000);
906: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
907: l_party_site_id NUMBER;
908: l_customer_id NUMBER;
909: l_cust_account_id NUMBER;
910: l_api_version_number CONSTANT NUMBER := 1.0;

Line 914: x_return_status := FND_API.G_RET_STS_SUCCESS;

910: l_api_version_number CONSTANT NUMBER := 1.0;
911: l_task_id NUMBER;
912:
913: BEGIN
914: x_return_status := FND_API.G_RET_STS_SUCCESS;
915:
916: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
917: x_error_message := g_pass_error;
918: p_result:='E:'||x_error_message;

Line 940: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);

936:
937: l_rqmt_header_Rec.requirement_header_id := l_header_rec.requirement_header_id;
938: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
939: l_rqmt_header_Rec.last_update_date := sysdate;
940: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
941: l_rqmt_header_Rec.last_updated_by := asg_base.get_user_id(p_user_name);
942: l_rqmt_header_Rec.last_update_login := nvl(fnd_global.login_id, -1);
943:
944: --l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);

Line 944: --l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);

940: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
941: l_rqmt_header_Rec.last_updated_by := asg_base.get_user_id(p_user_name);
942: l_rqmt_header_Rec.last_update_login := nvl(fnd_global.login_id, -1);
943:
944: --l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
945: --l_rqmt_header_Rec.need_by_date:= nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
946:
947:
948:

Line 945: --l_rqmt_header_Rec.need_by_date:= nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

941: l_rqmt_header_Rec.last_updated_by := asg_base.get_user_id(p_user_name);
942: l_rqmt_header_Rec.last_update_login := nvl(fnd_global.login_id, -1);
943:
944: --l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
945: --l_rqmt_header_Rec.need_by_date:= nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
946:
947:
948:
949: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

Line 950: P_Api_Version_Number => l_api_Version_number,P_Init_Msg_List => FND_API.G_TRUE,P_Commit => FND_API.G_FALSE,

946:
947:
948:
949: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
950: P_Api_Version_Number => l_api_Version_number,P_Init_Msg_List => FND_API.G_TRUE,P_Commit => FND_API.G_FALSE,
951: p_validation_level => null,
952: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
953: X_Return_Status => l_Return_status,
954: X_Msg_Count => l_msg_count,

Line 962: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

958: IF l_return_status IS NULL THEN
959: p_result:='E:No message returned by CSP api.';
960: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);
961: RETURN;
962: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: p_result:='S:'||to_char(l_Return_status);

Line 963: RAISE FND_API.G_EXC_ERROR;

959: p_result:='E:No message returned by CSP api.';
960: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);
961: RETURN;
962: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: p_result:='S:'||to_char(l_Return_status);
967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);

Line 969: WHEN FND_API.G_EXC_ERROR THEN

965:
966: p_result:='S:'||to_char(l_Return_status);
967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
971: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
972: p_result:='E:'||translateString(x_error_message);
973: WHEN OTHERS THEN

Line 995: x_return_status := FND_API.G_RET_STS_SUCCESS;

991: l_err boolean:=false;
992: l_hr_loc_id NUMBER;
993: begin
994: CSM_UTIL_PKG.LOG('Entering q_upd_oe_shipTo for '||P_REQ_HDR_ID||':'||P_ADDRESS_TYPE||':'||P_SHIP_LOC_ID, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
995: x_return_status := FND_API.G_RET_STS_SUCCESS;
996:
997: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
998: x_error_message := g_pass_error;
999: l_err:=true;

Line 1043: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1039: IF l_return_status IS NULL THEN
1040: p_result:='E:No message returned by CSP api.';
1041: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1042: RETURN;
1043: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: p_result:='E:No message returned by CSP api.';
1041: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1042: RETURN;
1043: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1048: p_result:='S:'||to_char(l_return_status);

Line 1050: WHEN FND_API.G_EXC_ERROR THEN

1046:
1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1048: p_result:='S:'||to_char(l_return_status);
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo',FND_LOG.LEVEL_PROCEDURE);
1052: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1053: p_result:='E:'||translateString(x_error_message);
1054: WHEN OTHERS THEN

Line 1101: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1097: IF l_return_status IS NULL THEN
1098: p_result:='E:No message returned by CSP api.';
1099: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1100: RETURN;
1101: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: p_result:='E:No message returned by CSP api.';
1099: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1100: RETURN;
1101: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1106: p_result:='S:'||to_char(l_return_status);

Line 1108: WHEN FND_API.G_EXC_ERROR THEN

1104:
1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1106: p_result:='S:'||to_char(l_return_status);
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod',FND_LOG.LEVEL_PROCEDURE);
1110: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1111: p_result:='E:'||translateString(x_error_message);
1112: WHEN OTHERS THEN

Line 1170: ,p_Init_Msg_List => FND_API.G_FALSE

1166: CSM_UTIL_PKG.LOG('Before call to CSP: hz_location_id:'||l_hz_loc_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1167:
1168: csp_ship_to_address_pvt.cust_inv_loc_link
1169: ( p_api_version => 1.0
1170: ,p_Init_Msg_List => FND_API.G_FALSE
1171: ,p_commit => FND_API.G_FALSE
1172: ,px_location_id => x_loc_id
1173: ,p_party_site_id => p_party_site_id
1174: ,p_cust_account_id => l_account_id

Line 1171: ,p_commit => FND_API.G_FALSE

1167:
1168: csp_ship_to_address_pvt.cust_inv_loc_link
1169: ( p_api_version => 1.0
1170: ,p_Init_Msg_List => FND_API.G_FALSE
1171: ,p_commit => FND_API.G_FALSE
1172: ,px_location_id => x_loc_id
1173: ,p_party_site_id => p_party_site_id
1174: ,p_cust_account_id => l_account_id
1175: ,p_customer_id => l_party_id

Line 1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN

1188:
1189:
1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1191:
1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN
1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1191:
1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN
1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: RETURN x_loc_id;
1198: end get_hr_location;

Line 1304: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1300:
1301: begin
1302:
1303: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1304: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1305: x_error_message := g_pass_error;
1306: p_result:='E:'||x_error_message;
1307: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1308: RETURN;

Line 1311: x_return_status := FND_API.G_RET_STS_SUCCESS;

1307: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1308: RETURN;
1309: END IF;
1310:
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312: x_error_message:='Success';
1313:
1314: CSM_UTIL_PKG.LOG('Entering q_create_shipTo with xml '||p_address, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1315:

Line 1352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1348:
1349: create_ship_to_address(p_user_name,p_ta_id,l_adrs_line_1 ,l_adrs_line_2 ,l_adrs_line_3,l_adrs_line_4 ,l_city ,l_county
1350: ,l_state,l_province,l_phonetic,l_country,l_pincode ,x_loc_id,x_cust_id, x_ovn,l_return_status ,l_msg_count ,l_msg_data );
1351:
1352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356:

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: create_ship_to_address(p_user_name,p_ta_id,l_adrs_line_1 ,l_adrs_line_2 ,l_adrs_line_3,l_adrs_line_4 ,l_city ,l_county
1350: ,l_state,l_province,l_phonetic,l_country,l_pincode ,x_loc_id,x_cust_id, x_ovn,l_return_status ,l_msg_count ,l_msg_data );
1351:
1352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356:
1357: l_hr_loc_id:=x_loc_id;

Line 1376: WHEN FND_API.G_EXC_ERROR THEN

1372: CSM_UTIL_PKG.LOG('Leaving q_create_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1373: p_result:='S:'||to_char(l_hz_psite_id)||':'||to_char(l_hz_loc_id)||':'||to_char(l_cust_acct_site_id)||':'||to_char(l_hr_loc_id)
1374: ||':'||to_char(l_org_id)||':'||to_char(x_cust_id);
1375: EXCEPTION
1376: WHEN FND_API.G_EXC_ERROR THEN
1377: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo',FND_LOG.LEVEL_PROCEDURE);
1378: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1379: p_result:='E:'||translateString(x_error_message);
1380: WHEN OTHERS THEN

Line 1468: x_return_status := FND_API.G_RET_STS_SUCCESS;

1464: CSM_UTIL_PKG.LOG('Entering q_available_parts for Item : ' ||P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1465:
1466: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',asg_base.get_user_id(p_user_name),NULL,NULL));
1467:
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;
1469:
1470: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1471: x_error_message := g_pass_error;
1472: l_err:=true;

Line 1665: IF L_RETURN_STATUS<> FND_API.G_RET_STS_SUCCESS THEN

1661: x_return_status => L_RETURN_STATUS,
1662: x_msg_data => l_msg_data,
1663: x_msg_count => l_msg_count);
1664:
1665: IF L_RETURN_STATUS<> FND_API.G_RET_STS_SUCCESS THEN
1666: x_error_message := 'Part Search Api Failed with error: ' || fnd_msg_pub.get(l_msg_count,'F');
1667: p_result:='E:'||translateString(x_error_message);
1668: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);
1669: RETURN; --this is meant for error callback

Line 1758: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1754:
1755: CSM_UTIL_PKG.LOG('Entering q_return_item for Item: ' ||P_ITEM_NAME||' and after decode:'||l_item_name , 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1756:
1757: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1758: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1759: x_error_message := g_pass_error;
1760: p_result:='E:'||x_error_message;
1761: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1762: RETURN;

Line 1765: x_return_status := FND_API.G_RET_STS_SUCCESS;

1761: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1762: RETURN;
1763: END IF;
1764:
1765: x_return_status := FND_API.G_RET_STS_SUCCESS;
1766: x_error_message:='Success';
1767:
1768: L_XML_RESULT := 'S:';
1769: l_count:=0;

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

1857: l_task_ovn NUMBER; l_ta_ovn NUMBER;
1858: l_tsk_st_id NUMBER;
1859: l_msg_count NUMBER;
1860: l_msg_data VARCHAR2(2000);
1861: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1862: l_ta_id NUMBER:=to_number(P_TA_ID);
1863: l_ta_audit_id NUMBER;
1864:
1865: CURSOR c_get_ovn IS

Line 1902: x_return_status := FND_API.G_RET_STS_SUCCESS;

1898: AND tas.task_assignment_id = dh.task_assignment_id
1899: AND tas.assignment_status_id = tst.task_status_id;
1900:
1901: BEGIN
1902: x_return_status := FND_API.G_RET_STS_SUCCESS;
1903: x_error_message:='Success';
1904:
1905: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1906: x_error_message := g_pass_error;

Line 1929: , p_init_msg_list => FND_API.G_TRUE

1925: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1926:
1927: csf_task_assignments_pub.update_assignment_status
1928: ( p_api_version => 1.0
1929: , p_init_msg_list => FND_API.G_TRUE
1930: , p_commit => FND_API.G_TRUE
1931: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1932: -- Validate task status transitions.
1933: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1930: , p_commit => FND_API.G_TRUE

1926:
1927: csf_task_assignments_pub.update_assignment_status
1928: ( p_api_version => 1.0
1929: , p_init_msg_list => FND_API.G_TRUE
1930: , p_commit => FND_API.G_TRUE
1931: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1932: -- Validate task status transitions.
1933: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1934: , x_return_status => l_return_status

Line 1931: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1927: csf_task_assignments_pub.update_assignment_status
1928: ( p_api_version => 1.0
1929: , p_init_msg_list => FND_API.G_TRUE
1930: , p_commit => FND_API.G_TRUE
1931: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1932: -- Validate task status transitions.
1933: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1934: , x_return_status => l_return_status
1935: , x_msg_count => l_msg_count

Line 1933: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1929: , p_init_msg_list => FND_API.G_TRUE
1930: , p_commit => FND_API.G_TRUE
1931: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1932: -- Validate task status transitions.
1933: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1934: , x_return_status => l_return_status
1935: , x_msg_count => l_msg_count
1936: , x_msg_data => l_msg_data
1937: , p_task_assignment_id => l_ta_id

Line 1945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1941: , x_task_object_version_number => l_task_ovn
1942: , x_task_status_id => l_tsk_st_id
1943: );
1944:
1945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: /****************** POST DEBRIEF **********************/

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: , x_task_status_id => l_tsk_st_id
1943: );
1944:
1945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: /****************** POST DEBRIEF **********************/
1950:

Line 1986: WHEN FND_API.G_EXC_ERROR THEN

1982:
1983: p_result:='S:'||to_char(l_tsk_st_id);
1984: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1988: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1989: p_result:='E:'||translateString(x_error_message);
1990: WHEN OTHERS THEN