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.

[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on FND_API

Line 182: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

178: are active and close those notifications with proper result. This
179: procedure also initiates the PO Change Order workflow process to send
180: the notification to the buyer about the supplier acknowledgement.
181: * Returns:
182: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
183: * FND_API.G_RET_STS_ERROR if an error occurs
184: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
185: *
186: */

Line 183: * FND_API.G_RET_STS_ERROR if an error occurs

179: procedure also initiates the PO Change Order workflow process to send
180: the notification to the buyer about the supplier acknowledgement.
181: * Returns:
182: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
183: * FND_API.G_RET_STS_ERROR if an error occurs
184: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
185: *
186: */
187:

Line 184: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

180: the notification to the buyer about the supplier acknowledgement.
181: * Returns:
182: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
183: * FND_API.G_RET_STS_ERROR if an error occurs
184: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
185: *
186: */
187:
188: function startSupplierWF

Line 216: startWf := FND_API.G_TRUE;

212: /* End changes for 7172390 */
213:
214: BEGIN
215: -- Assume worflow needs to be started for every change request
216: startWf := FND_API.G_TRUE;
217: -- initialize return status
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: -- Also update approved flag on the po_line_locations to restrict receiving

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

214: BEGIN
215: -- Assume worflow needs to be started for every change request
216: startWf := FND_API.G_TRUE;
217: -- initialize return status
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: -- Also update approved flag on the po_line_locations to restrict receiving
221: -- call workflow if this is the final action
222:

Line 240: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );

236: --Retrieve the Acknowledgement Notification sent thru core po
237: l_nid := getAckNotifId(p_po_header_id,p_po_release_id, l_activity_name);
238: -- Close the notification sent thru core po
239: startWf := po_acknowledge_po_grp.all_shipments_responded (
240: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );
241: if l_nid is not null then
242: begin
243: /* Start changes for 7172390 */
244: if(startWf = FND_API.G_TRUE) THEN

Line 244: if(startWf = FND_API.G_TRUE) THEN

240: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );
241: if l_nid is not null then
242: begin
243: /* Start changes for 7172390 */
244: if(startWf = FND_API.G_TRUE) THEN
245: BEGIN
246: /* l_accepted_flag and Notif_Ack_Status will have the following values respectively.
247: 'Y' for Accepted staus.
248: 'N' for Rejected status.

Line 297: startWf := FND_API.G_TRUE;

293: raise;
294: end;
295: end if;
296: else
297: startWf := FND_API.G_TRUE;
298: end if;
299:
300: -- Call workflow
301: if(startWf = FND_API.G_TRUE) then

Line 301: if(startWf = FND_API.G_TRUE) then

297: startWf := FND_API.G_TRUE;
298: end if;
299:
300: -- Call workflow
301: if(startWf = FND_API.G_TRUE) then
302: /* Handle the change request group id for cases when supplier completes the acknowledgement after
303: asking for a change initially bug 4872348 */
304: if(p_chg_request_grp_id is null) then
305: if (p_po_release_id is not null) then

Line 328: x_return_status := FND_API.g_ret_sts_unexp_error;

324:
325: exception
326: WHEN OTHERS THEN
327: raise;
328: x_return_status := FND_API.g_ret_sts_unexp_error;
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
331: IF g_fnd_debug = 'Y' THEN
332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371: l_supplier_displayname VARCHAR2(240);
372:
373: BEGIN
374: -- initialize return status
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376: if (p_item_key is null ) then
377: x_return_status := FND_API.g_ret_sts_unexp_error;
378: return x_return_status;
379: else

Line 377: x_return_status := FND_API.g_ret_sts_unexp_error;

373: BEGIN
374: -- initialize return status
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376: if (p_item_key is null ) then
377: x_return_status := FND_API.g_ret_sts_unexp_error;
378: return x_return_status;
379: else
380:
381: wf_engine.createProcess ( ItemType => p_item_type,

Line 425: x_return_status := FND_API.g_ret_sts_unexp_error;

421: end if;
422: exception
423: WHEN OTHERS THEN
424: raise;
425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
428: IF g_fnd_debug = 'Y' THEN
429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 474: x_return_status := FND_API.G_RET_STS_SUCCESS;

470: l_supplier_displayname VARCHAR2(240);
471:
472: BEGIN
473: -- initialize return status
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475: if (p_item_key is null ) then
476: x_return_status := FND_API.g_ret_sts_unexp_error;
477: return x_return_status;
478: else

Line 476: x_return_status := FND_API.g_ret_sts_unexp_error;

472: BEGIN
473: -- initialize return status
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475: if (p_item_key is null ) then
476: x_return_status := FND_API.g_ret_sts_unexp_error;
477: return x_return_status;
478: else
479:
480: wf_engine.createProcess ( ItemType => p_item_type,

Line 527: x_return_status := FND_API.g_ret_sts_unexp_error;

523: end if;
524: exception
525: WHEN OTHERS THEN
526: raise;
527: x_return_status := FND_API.g_ret_sts_unexp_error;
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: IF g_fnd_debug = 'Y' THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 546: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

542: * Requires: API message list has been initialized if p_init_msg_list is false.
543: * Modifies: API message list
544: * Effects: Saves Data to the Change Request Table
545: * Returns:
546: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
547: * FND_API.G_RET_STS_ERROR if an error occurs
548: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
549: */
550:

Line 547: * FND_API.G_RET_STS_ERROR if an error occurs

543: * Modifies: API message list
544: * Effects: Saves Data to the Change Request Table
545: * Returns:
546: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
547: * FND_API.G_RET_STS_ERROR if an error occurs
548: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
549: */
550:
551: procedure save_request(

Line 548: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

544: * Effects: Saves Data to the Change Request Table
545: * Returns:
546: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
547: * FND_API.G_RET_STS_ERROR if an error occurs
548: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
549: */
550:
551: procedure save_request(
552: p_api_version IN NUMBER,

Line 579: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

575: l_api_name CONSTANT VARCHAR2(30) := 'save_request';
576: l_api_version_number CONSTANT NUMBER := 1.0;
577:
578: BEGIN
579: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
580: -- initialize message list
581: FND_MSG_PUB.initialize;
582: END IF;
583:

Line 586: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

582: END IF;
583:
584: -- Standard call to check for call compatibility.
585:
586: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
587: p_api_version,
588: l_api_name,
589: G_PKG_NAME)
590: THEN

Line 591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

587: p_api_version,
588: l_api_name,
589: G_PKG_NAME)
590: THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594: -- initialize return status
595: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594: -- initialize return status
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: if (p_user_id is not null) then
598: l_user_id := p_user_id;
599: l_login_id := p_login_id;

Line 710: WHEN FND_API.g_exc_error THEN

706: end if;
707: end loop;
708:
709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN
711: x_return_status := FND_API.g_ret_sts_error;
712: WHEN FND_API.g_exc_unexpected_error THEN
713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN

Line 711: x_return_status := FND_API.g_ret_sts_error;

707: end loop;
708:
709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN
711: x_return_status := FND_API.g_ret_sts_error;
712: WHEN FND_API.g_exc_unexpected_error THEN
713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 712: WHEN FND_API.g_exc_unexpected_error THEN

708:
709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN
711: x_return_status := FND_API.g_ret_sts_error;
712: WHEN FND_API.g_exc_unexpected_error THEN
713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716:

Line 713: x_return_status := FND_API.g_ret_sts_unexp_error;

709: EXCEPTION
710: WHEN FND_API.g_exc_error THEN
711: x_return_status := FND_API.g_ret_sts_error;
712: WHEN FND_API.g_exc_unexpected_error THEN
713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716:
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 715: x_return_status := FND_API.g_ret_sts_unexp_error;

711: x_return_status := FND_API.g_ret_sts_error;
712: WHEN FND_API.g_exc_unexpected_error THEN
713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716:
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: IF g_fnd_debug = 'Y' THEN

Line 735: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

731: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,POS_CHG_REC_TBL
732: * Modifies:
733: * Effects: Processes the change Request and calls PO Doc Submission Check
734: * Returns:
735: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
736: * FND_API.G_RET_STS_ERROR if an error occurs
737: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
738: * POS_ERR_TYPE
739: */

Line 736: * FND_API.G_RET_STS_ERROR if an error occurs

732: * Modifies:
733: * Effects: Processes the change Request and calls PO Doc Submission Check
734: * Returns:
735: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
736: * FND_API.G_RET_STS_ERROR if an error occurs
737: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
738: * POS_ERR_TYPE
739: */
740:

Line 737: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

733: * Effects: Processes the change Request and calls PO Doc Submission Check
734: * Returns:
735: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
736: * FND_API.G_RET_STS_ERROR if an error occurs
737: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
738: * POS_ERR_TYPE
739: */
740:
741: procedure process_supplier_request (

Line 754: p_mpoc IN varchar2 default FND_API.G_FALSE) IS

750: p_chn_requestor_username in varchar2 default null,
751: p_user_id IN number default null,
752: p_login_id IN number default null,
753: p_last_upd_date IN date default null,
754: p_mpoc IN varchar2 default FND_API.G_FALSE) IS
755:
756: x_error_code varchar2(40);
757: no_rec_found exception;
758: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

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

758: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
759: x_progress varchar2(3) := '000';
760: l_api_version_number CONSTANT NUMBER := 1.0;
761: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_request';
762: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
763: l_msg_count NUMBER;
764: l_msg_data VARCHAR2(2000);
765: l_commit VARCHAR2(1) := FND_API.G_FALSE;
766: l_user_id NUMBER;

Line 765: l_commit VARCHAR2(1) := FND_API.G_FALSE;

761: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_request';
762: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
763: l_msg_count NUMBER;
764: l_msg_data VARCHAR2(2000);
765: l_commit VARCHAR2(1) := FND_API.G_FALSE;
766: l_user_id NUMBER;
767: l_login_id NUMBER;
768: l_request_group_id NUMBER :=null;
769: x_return_status varchar2(20);

Line 805: x_return_status := FND_API.G_RET_STS_SUCCESS;

801: relRec REL_CSR%ROWTYPE;
802:
803: BEGIN
804: -- initialize return status
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: x_progress := '001';
807:
808:
809: -- Lock the PO Header Row for update of Last Update Date

Line 906: x_return_status := FND_API.g_ret_sts_unexp_error;

902:
903: if ( l_po_change_requests(1).action_type in ('CANCELLATION') AND
904: l_po_change_requests(1).request_level='HEADER' ) then
905: if (l_po_change_requests.count > 1 ) then
906: x_return_status := FND_API.g_ret_sts_unexp_error;
907:
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: IF g_fnd_debug = 'Y' THEN
910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 937: p_Init_Msg_List => FND_API.G_FALSE,

933: return;
934: end if;
935: save_cancel_request(
936: p_api_version => 1.0 ,
937: p_Init_Msg_List => FND_API.G_FALSE,
938: x_return_status => l_return_status,
939: p_po_header_id => p_po_header_id,
940: p_po_release_id => p_po_release_id,
941: p_revision_num => p_revision_num,

Line 946: if (l_return_status <> FND_API.g_ret_sts_success) then

942: p_po_change_requests => l_po_change_requests,
943: x_request_group_id => l_request_group_id
944: );
945: x_online_report_id := 0;
946: if (l_return_status <> FND_API.g_ret_sts_success) then
947: l_err_msg_name_tbl := po_tbl_varchar30();
948: l_err_msg_text_tbl := po_tbl_varchar2000();
949: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
950:

Line 999: 1.0,FND_API.G_FALSE,x_return_status,

995:
996: -- Process The Acknowledgements
997:
998: PO_ACKNOWLEDGE_PO_GRP.Acknowledge_shipment(
999: 1.0,FND_API.G_FALSE,x_return_status,
1000: l_po_change_requests(i).document_line_location_id,
1001: l_po_change_requests(i).document_header_id,
1002: l_po_change_requests(i).po_release_id,
1003: l_po_change_requests(i).document_revision_num,

Line 1043: 1.0,FND_API.G_FALSE,x_return_status,

1039:
1040: callWf := true;
1041: -- Process The Acknowledgements
1042: PO_ACKNOWLEDGE_PO_GRP.Acknowledge_shipment(
1043: 1.0,FND_API.G_FALSE,x_return_status,
1044: l_po_change_requests(i).document_line_location_id,
1045: l_po_change_requests(i).document_header_id,
1046: l_po_change_requests(i).po_release_id,
1047: l_po_change_requests(i).document_revision_num,

Line 1070: x_return_status := FND_API.g_ret_sts_unexp_error;

1066: set supplier_order_line_number = l_po_change_requests(i).New_Supplier_Order_Line_Number
1067: where line_location_id = l_po_change_requests(i).document_line_location_id;
1068: exception
1069: WHEN OTHERS THEN
1070: x_return_status := FND_API.g_ret_sts_unexp_error;
1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1073: IF g_fnd_debug = 'Y' THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1127: p_init_msg_list => FND_API.G_FALSE,

1123: THEN RETURN;
1124: END IF;
1125: validate_change_request (
1126: p_api_version => 1.0,
1127: p_init_msg_list => FND_API.G_FALSE,
1128: x_return_status => x_return_status,
1129: x_msg_data => l_msg_data,
1130: p_po_header_id => p_po_header_id,
1131: p_po_release_id => p_po_release_id,

Line 1139: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then

1135: x_pos_errors => x_pos_errors);
1136:
1137: end if;
1138:
1139: if (l_po_change_requests.count() > 0 AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1140: IF g_fnd_debug = 'Y' THEN
1141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1143: '.invoked', 'Type: ' ||

Line 1149: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1145: END IF;
1146: END IF;
1147:
1148:
1149: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1150:
1151: if (saveRequest) then
1152:
1153: save_request(

Line 1155: p_init_msg_list => FND_API.G_FALSE,

1151: if (saveRequest) then
1152:
1153: save_request(
1154: p_api_version => 1.0,
1155: p_init_msg_list => FND_API.G_FALSE,
1156: x_return_status => x_return_status,
1157: p_po_header_id => p_po_header_id,
1158: p_po_release_id => p_po_release_id,
1159: p_revision_num => p_revision_num,

Line 1191: FND_API.G_FALSE,

1187: acknowledgement record.
1188: */
1189: PO_ACKNOWLEDGE_PO_GRP.Set_Header_Acknowledgement (
1190: 1.0,
1191: FND_API.G_FALSE,
1192: x_return_status,
1193: p_po_header_id,
1194: p_po_release_id );
1195:

Line 1205: if (p_mpoc = FND_API.G_TRUE) then

1201: '.invoked', 'Call Workflow ' || ', request group id ' || to_char(l_request_group_id));
1202: END IF;
1203: END IF;
1204: --start multiple po change
1205: if (p_mpoc = FND_API.G_TRUE) then
1206: if(x_accp_flag = 'Y') then
1207: x_return_status := po_acknowledge_po_grp.all_shipments_responded (
1208: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );
1209: else

Line 1208: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );

1204: --start multiple po change
1205: if (p_mpoc = FND_API.G_TRUE) then
1206: if(x_accp_flag = 'Y') then
1207: x_return_status := po_acknowledge_po_grp.all_shipments_responded (
1208: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );
1209: else
1210: x_return_status := FND_API.G_TRUE;
1211: end if;
1212:

Line 1210: x_return_status := FND_API.G_TRUE;

1206: if(x_accp_flag = 'Y') then
1207: x_return_status := po_acknowledge_po_grp.all_shipments_responded (
1208: 1.0,FND_API.G_FALSE,p_po_header_id , p_po_release_id, p_revision_num );
1209: else
1210: x_return_status := FND_API.G_TRUE;
1211: end if;
1212:
1213: if(x_return_status = FND_API.G_TRUE) then
1214: IF g_fnd_debug = 'Y' THEN

Line 1213: if(x_return_status = FND_API.G_TRUE) then

1209: else
1210: x_return_status := FND_API.G_TRUE;
1211: end if;
1212:
1213: if(x_return_status = FND_API.G_TRUE) then
1214: IF g_fnd_debug = 'Y' THEN
1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1217: '.invoked', ' All shipments acked/changed ' );

Line 1242: end if; --if docCheck returns FND_API.G_RET_STS_SUCCESS

1238: END IF;
1239: END IF;
1240: end if;
1241:
1242: end if; --if docCheck returns FND_API.G_RET_STS_SUCCESS
1243:
1244: end if;
1245: -- Update the PO Headers/Releases even if the changes dosent require doc Check
1246: if (callDocCheck=false) then

Line 1279: x_return_status := FND_API.g_ret_sts_unexp_error;

1275: end if;
1276: end if; -- if call doc check is false
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1282: IF g_fnd_debug = 'Y' THEN
1283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1298: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

1294: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,REQUEST_GROUP_ID
1295: * Modifies:
1296: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1297: * Returns:
1298: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1299: * FND_API.G_RET_STS_ERROR if an error occurs
1300: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1301: */
1302:

Line 1299: * FND_API.G_RET_STS_ERROR if an error occurs

1295: * Modifies:
1296: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1297: * Returns:
1298: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1299: * FND_API.G_RET_STS_ERROR if an error occurs
1300: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1301: */
1302:
1303: procedure update_po_attributes

Line 1300: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1296: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1297: * Returns:
1298: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1299: * FND_API.G_RET_STS_ERROR if an error occurs
1300: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1301: */
1302:
1303: procedure update_po_attributes
1304: (p_po_header_id IN number,

Line 1319: x_return_status := FND_API.G_RET_STS_SUCCESS;

1315: l_login_id number;
1316:
1317: BEGIN
1318:
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320: if (p_user_id is null or p_login_id is null) then
1321: l_user_id := fnd_global.user_id;
1322: l_login_id := fnd_global.login_id;
1323: else

Line 1441: x_return_status := FND_API.g_ret_sts_unexp_error;

1437: approved_flag='Y';
1438: end if;
1439: EXCEPTION
1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.g_ret_sts_unexp_error;
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1444: IF g_fnd_debug = 'Y' THEN
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1461: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

1457: * Effects: Converts the Supplier Change Request To PO Change Request
1458: * Calls Doc Submission Check API
1459: * Also calls process_acknowledgements API to post Acknowledgements
1460: * Returns:
1461: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1462: * FND_API.G_RET_STS_ERROR if an error occurs
1463: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1464: */
1465:

Line 1462: * FND_API.G_RET_STS_ERROR if an error occurs

1458: * Calls Doc Submission Check API
1459: * Also calls process_acknowledgements API to post Acknowledgements
1460: * Returns:
1461: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1462: * FND_API.G_RET_STS_ERROR if an error occurs
1463: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1464: */
1465:
1466: procedure validate_change_request (

Line 1463: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1459: * Also calls process_acknowledgements API to post Acknowledgements
1460: * Returns:
1461: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1462: * FND_API.G_RET_STS_ERROR if an error occurs
1463: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1464: */
1465:
1466: procedure validate_change_request (
1467: p_api_version IN NUMBER,

Line 1590: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

1586: latest_external_flag='Y' ;
1587:
1588: BEGIN
1589:
1590: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1591: l_api_name, g_pkg_name)
1592: THEN
1593: RAISE FND_API.g_exc_unexpected_error;
1594: END IF;

Line 1593: RAISE FND_API.g_exc_unexpected_error;

1589:
1590: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1591: l_api_name, g_pkg_name)
1592: THEN
1593: RAISE FND_API.g_exc_unexpected_error;
1594: END IF;
1595:
1596: x_return_status := FND_API.g_ret_sts_success;
1597: IF g_fnd_debug = 'Y' THEN

Line 1596: x_return_status := FND_API.g_ret_sts_success;

1592: THEN
1593: RAISE FND_API.g_exc_unexpected_error;
1594: END IF;
1595:
1596: x_return_status := FND_API.g_ret_sts_success;
1597: IF g_fnd_debug = 'Y' THEN
1598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
1600: '.invoked', 'Type: ' ||

Line 1909: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND

1905: l_err_msg_name_tbl := po_tbl_varchar30();
1906: l_err_msg_text_tbl := po_tbl_varchar2000();
1907: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1908:
1909: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
1910: l_sub_check_status = FND_API.G_RET_STS_ERROR) THEN
1911:
1912: x_sub_errors := x_doc_check_error_msg.online_report_id.count;
1913: sub_error_flag := 'N';

Line 1910: l_sub_check_status = FND_API.G_RET_STS_ERROR) THEN

1906: l_err_msg_text_tbl := po_tbl_varchar2000();
1907: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1908:
1909: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
1910: l_sub_check_status = FND_API.G_RET_STS_ERROR) THEN
1911:
1912: x_sub_errors := x_doc_check_error_msg.online_report_id.count;
1913: sub_error_flag := 'N';
1914: FOR i in 1..x_sub_errors loop

Line 1935: x_return_status := FND_API.G_RET_STS_SUCCESS;

1931: -- Some other errors were reported from submission check api
1932: if (sub_error_flag = 'Y') then
1933: raise sub_check_failed;
1934: else
1935: x_return_status := FND_API.G_RET_STS_SUCCESS;
1936: end if;
1937: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1938: --x_msg_data has stuff regarding doc sub check.
1939: l_error_index := l_error_index + 1;

Line 1937: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1933: raise sub_check_failed;
1934: else
1935: x_return_status := FND_API.G_RET_STS_SUCCESS;
1936: end if;
1937: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1938: --x_msg_data has stuff regarding doc sub check.
1939: l_error_index := l_error_index + 1;
1940: x_pos_errors.message_name.extend;
1941: x_pos_errors.text_line.extend;

Line 1945: -- If l_return_status and l_sub_check_status = FND_API.G_RET_STS_SUCCESS

1941: x_pos_errors.text_line.extend;
1942: x_pos_errors.message_name(l_error_index) := null;
1943: x_pos_errors.text_line(l_error_index) := l_msg_data;
1944: raise sub_check_failed;
1945: -- If l_return_status and l_sub_check_status = FND_API.G_RET_STS_SUCCESS
1946: -- Then Continue no errors in doc check
1947: end if;
1948:
1949: x_progress := '007';

Line 1953: WHEN FND_API.g_exc_error THEN

1949: x_progress := '007';
1950: end if; --end rec cnt
1951:
1952: EXCEPTION
1953: WHEN FND_API.g_exc_error THEN
1954: x_return_status := FND_API.g_ret_sts_error;
1955: WHEN FND_API.g_exc_unexpected_error THEN
1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN

Line 1954: x_return_status := FND_API.g_ret_sts_error;

1950: end if; --end rec cnt
1951:
1952: EXCEPTION
1953: WHEN FND_API.g_exc_error THEN
1954: x_return_status := FND_API.g_ret_sts_error;
1955: WHEN FND_API.g_exc_unexpected_error THEN
1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;

Line 1955: WHEN FND_API.g_exc_unexpected_error THEN

1951:
1952: EXCEPTION
1953: WHEN FND_API.g_exc_error THEN
1954: x_return_status := FND_API.g_ret_sts_error;
1955: WHEN FND_API.g_exc_unexpected_error THEN
1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN

Line 1956: x_return_status := FND_API.g_ret_sts_unexp_error;

1952: EXCEPTION
1953: WHEN FND_API.g_exc_error THEN
1954: x_return_status := FND_API.g_ret_sts_error;
1955: WHEN FND_API.g_exc_unexpected_error THEN
1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1958: x_return_status := FND_API.g_ret_sts_error;

1954: x_return_status := FND_API.g_ret_sts_error;
1955: WHEN FND_API.g_exc_unexpected_error THEN
1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.g_ret_sts_unexp_error;
1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1960: x_return_status := FND_API.g_ret_sts_unexp_error;

1956: x_return_status := FND_API.g_ret_sts_unexp_error;
1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.g_ret_sts_unexp_error;
1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1963: IF g_fnd_debug = 'Y' THEN
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1996: p_init_msg_list => FND_API.G_FALSE,

1992: --l_po_change_requests := p_po_change_requests;
1993:
1994: validate_change_request (
1995: p_api_version => 1.0,
1996: p_init_msg_list => FND_API.G_FALSE,
1997: x_return_status => x_return_status,
1998: x_msg_data => l_msg_data,
1999: p_po_header_id => p_po_header_id,
2000: p_po_release_id => p_po_release_id,

Line 2018: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

2014: * Determines id the Line Price can be changed based on
2015: * 1. ACCRUE_ON_RECEIPT_FLAG
2016: * 2. QUANTITY_BILLED
2017: * Returns:
2018: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
2019: * FND_API.G_RET_STS_ERROR if an error occurs
2020: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2021: */
2022:

Line 2019: * FND_API.G_RET_STS_ERROR if an error occurs

2015: * 1. ACCRUE_ON_RECEIPT_FLAG
2016: * 2. QUANTITY_BILLED
2017: * Returns:
2018: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
2019: * FND_API.G_RET_STS_ERROR if an error occurs
2020: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2021: */
2022:
2023: function ifLineChangable( p_po_line_id IN number)

Line 2020: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2016: * 2. QUANTITY_BILLED
2017: * Returns:
2018: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
2019: * FND_API.G_RET_STS_ERROR if an error occurs
2020: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2021: */
2022:
2023: function ifLineChangable( p_po_line_id IN number)
2024: return varchar2 is

Line 2124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2120:
2121:
2122: procedure validateCancelRequest(
2123: p_api_version IN NUMBER,
2124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2125: x_return_status OUT NOCOPY VARCHAR2,
2126: p_po_header_id IN NUMBER,
2127: p_po_release_id IN NUMBER) IS
2128:

Line 2140: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

2136: x_ship_count NUMBER := 0;
2137:
2138:
2139: BEGIN
2140: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2141: l_api_name, g_pkg_name)
2142: THEN
2143: RAISE FND_API.g_exc_unexpected_error;
2144: END IF;

Line 2143: RAISE FND_API.g_exc_unexpected_error;

2139: BEGIN
2140: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2141: l_api_name, g_pkg_name)
2142: THEN
2143: RAISE FND_API.g_exc_unexpected_error;
2144: END IF;
2145:
2146: x_return_status := FND_API.g_ret_sts_success;
2147:

Line 2146: x_return_status := FND_API.g_ret_sts_success;

2142: THEN
2143: RAISE FND_API.g_exc_unexpected_error;
2144: END IF;
2145:
2146: x_return_status := FND_API.g_ret_sts_success;
2147:
2148: -- Call this when logging is enabled
2149:
2150: IF g_fnd_debug = 'Y' THEN

Line 2203: p_init_msg_list => FND_API.G_TRUE,

2199: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
2200:
2201: PO_Document_Control_GRP.check_control_action(
2202: p_api_version => 1.0,
2203: p_init_msg_list => FND_API.G_TRUE,
2204: x_return_status => x_return_status,
2205: p_doc_type => v_document_type,
2206: p_doc_subtype => v_document_subtype,
2207: p_doc_id => p_po_header_id,

Line 2218: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

2214: p_doc_shipment_num => null,
2215: p_action => 'CANCEL');
2216:
2217:
2218: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
2219:
2220: BEGIN
2221: if (p_po_release_id is not null) then
2222: SELECT count(*)

Line 2254: x_return_status := FND_API.G_RET_STS_ERROR;

2250:
2251: end if;
2252:
2253: if (x_ship_count > 0) then
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: else
2256: x_return_status := FND_API.G_RET_STS_SUCCESS;
2257: end if;
2258:

Line 2256: x_return_status := FND_API.G_RET_STS_SUCCESS;

2252:
2253: if (x_ship_count > 0) then
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255: else
2256: x_return_status := FND_API.G_RET_STS_SUCCESS;
2257: end if;
2258:
2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN

Line 2260: WHEN FND_API.g_exc_error THEN

2256: x_return_status := FND_API.G_RET_STS_SUCCESS;
2257: end if;
2258:
2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN
2261: x_return_status := FND_API.g_ret_sts_error;
2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN

Line 2261: x_return_status := FND_API.g_ret_sts_error;

2257: end if;
2258:
2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN
2261: x_return_status := FND_API.g_ret_sts_error;
2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2262: WHEN FND_API.g_exc_unexpected_error THEN

2258:
2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN
2261: x_return_status := FND_API.g_ret_sts_error;
2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2263: x_return_status := FND_API.g_ret_sts_unexp_error;

2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN
2261: x_return_status := FND_API.g_ret_sts_error;
2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 2265: x_return_status := FND_API.g_ret_sts_unexp_error;

2261: x_return_status := FND_API.g_ret_sts_error;
2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2268: IF g_fnd_debug = 'Y' THEN
2269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2282: WHEN FND_API.g_exc_error THEN

2278:
2279:
2280: EXCEPTION
2281:
2282: WHEN FND_API.g_exc_error THEN
2283: x_return_status := FND_API.g_ret_sts_error;
2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN

Line 2283: x_return_status := FND_API.g_ret_sts_error;

2279:
2280: EXCEPTION
2281:
2282: WHEN FND_API.g_exc_error THEN
2283: x_return_status := FND_API.g_ret_sts_error;
2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2284: WHEN FND_API.g_exc_unexpected_error THEN

2280: EXCEPTION
2281:
2282: WHEN FND_API.g_exc_error THEN
2283: x_return_status := FND_API.g_ret_sts_error;
2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2285: x_return_status := FND_API.g_ret_sts_unexp_error;

2281:
2282: WHEN FND_API.g_exc_error THEN
2283: x_return_status := FND_API.g_ret_sts_error;
2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 2287: x_return_status := FND_API.g_ret_sts_unexp_error;

2283: x_return_status := FND_API.g_ret_sts_error;
2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2290: IF g_fnd_debug = 'Y' THEN
2291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2323: (1.0,FND_API.G_FALSE,pll.line_location_id,

2319: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2320: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2321: DECODE(
2322: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2323: (1.0,FND_API.G_FALSE,pll.line_location_id,
2324: pll.po_header_id, p_po_release_id,p_revision_num),
2325: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2326: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2327: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

Line 2340: (1.0,FND_API.G_FALSE,pll.line_location_id,

2336: OR NVL(pll.CLOSED_CODE,'OPEN') = 'CLOSED FOR INVOICE'
2337: THEN
2338: DECODE(
2339: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2340: (1.0,FND_API.G_FALSE,pll.line_location_id,
2341: pll.po_header_id, p_po_release_id,p_revision_num),
2342: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2343: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2344: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

Line 2354: (1.0,FND_API.G_FALSE,pll.line_location_id,

2350: )
2351: ) ,
2352: nvl(pll.closed_code,'OPEN'),
2353: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2354: (1.0,FND_API.G_FALSE,pll.line_location_id,
2355: pll.po_header_id, p_po_release_id,p_revision_num),nvl(poh.acceptance_required_flag,'N'),
2356: poh.revision_num,nvl(pll.consigned_flag,'N')
2357: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2358: from po_line_locations_all pll,

Line 2386: (1.0,FND_API.G_FALSE,pll.line_location_id,

2382: 'N',DECODE(NVL(pll.CONSIGNED_FLAG,'N'),
2383: 'Y',DECODE(NVL(pll.CLOSED_CODE,'OPEN'),'CLOSED FOR INVOICE',
2384: DECODE(
2385: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2386: (1.0,FND_API.G_FALSE,pll.line_location_id,
2387: pll.po_header_id, p_po_release_id,p_revision_num),
2388: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2389: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2390: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

Line 2403: (1.0,FND_API.G_FALSE,pll.line_location_id,

2399: OR NVL(pll.CLOSED_CODE,'OPEN') = 'CLOSED FOR INVOICE'
2400: THEN
2401: DECODE(
2402: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2403: (1.0,FND_API.G_FALSE,pll.line_location_id,
2404: pll.po_header_id, p_po_release_id,p_revision_num),
2405: 'PENDING_CHANGE',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CHANGE'),
2406: 'ACK_REQUIRED',FND_MESSAGE.GET_STRING('POS','POS_ACCP_REQUIRED'),
2407: 'PENDING_CANCEL',FND_MESSAGE.GET_STRING('POS','POS_PENDING_CANCEL'),

Line 2417: (1.0,FND_API.G_FALSE,pll.line_location_id,

2413: )
2414: ) ,
2415: nvl(pll.closed_code,'OPEN'),
2416: PO_ACKNOWLEDGE_PO_GRP.GET_SHIPMENT_ACK_CHANGE_STATUS
2417: (1.0,FND_API.G_FALSE,pll.line_location_id,
2418: pll.po_header_id, p_po_release_id,p_revision_num),nvl(por.acceptance_required_flag,'N'),
2419: por.revision_num,nvl(pll.consigned_flag,'N')
2420: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2421: from po_line_locations_all pll,

Line 2486: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

2482: l_api_version_number CONSTANT NUMBER := 1.0;
2483: l_request_group_id NUMBER;
2484:
2485: BEGIN
2486: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2487: -- initialize message list
2488: FND_MSG_PUB.initialize;
2489: END IF;
2490:

Line 2493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2489: END IF;
2490:
2491: -- Standard call to check for call compatibility.
2492:
2493: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2494: p_api_version,
2495: l_api_name,
2496: G_PKG_NAME)
2497: THEN

Line 2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2494: p_api_version,
2495: l_api_name,
2496: G_PKG_NAME)
2497: THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500:
2501: -- initialize return status
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500:
2501: -- initialize return status
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503: save_request(
2504: p_api_version => 1.0,
2505: p_init_msg_list => FND_API.G_FALSE,
2506: x_return_status => x_return_status,

Line 2505: p_init_msg_list => FND_API.G_FALSE,

2501: -- initialize return status
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503: save_request(
2504: p_api_version => 1.0,
2505: p_init_msg_list => FND_API.G_FALSE,
2506: x_return_status => x_return_status,
2507: p_po_header_id => p_po_header_id,
2508: p_po_release_id => p_po_release_id,
2509: p_revision_num => p_revision_num,

Line 2521: if (x_return_status = FND_API.G_RET_STS_SUCCESS ) then

2517: l_request_group_id,
2518: x_return_status);
2519:
2520: -- Start the workflow for cancel request
2521: if (x_return_status = FND_API.G_RET_STS_SUCCESS ) then
2522: x_return_status := startSupplierWF(
2523: p_po_header_id,p_po_release_id,p_revision_num,
2524: l_request_group_id,'N');
2525: end if;

Line 2528: WHEN FND_API.g_exc_error THEN

2524: l_request_group_id,'N');
2525: end if;
2526:
2527: EXCEPTION
2528: WHEN FND_API.g_exc_error THEN
2529: x_return_status := FND_API.g_ret_sts_error;
2530: WHEN FND_API.g_exc_unexpected_error THEN
2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN

Line 2529: x_return_status := FND_API.g_ret_sts_error;

2525: end if;
2526:
2527: EXCEPTION
2528: WHEN FND_API.g_exc_error THEN
2529: x_return_status := FND_API.g_ret_sts_error;
2530: WHEN FND_API.g_exc_unexpected_error THEN
2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2530: WHEN FND_API.g_exc_unexpected_error THEN

2526:
2527: EXCEPTION
2528: WHEN FND_API.g_exc_error THEN
2529: x_return_status := FND_API.g_ret_sts_error;
2530: WHEN FND_API.g_exc_unexpected_error THEN
2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534:

Line 2531: x_return_status := FND_API.g_ret_sts_unexp_error;

2527: EXCEPTION
2528: WHEN FND_API.g_exc_error THEN
2529: x_return_status := FND_API.g_ret_sts_error;
2530: WHEN FND_API.g_exc_unexpected_error THEN
2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534:
2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2533: x_return_status := FND_API.g_ret_sts_unexp_error;

2529: x_return_status := FND_API.g_ret_sts_error;
2530: WHEN FND_API.g_exc_unexpected_error THEN
2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534:
2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2537: IF g_fnd_debug = 'Y' THEN

Line 2660: IF FND_API.to_boolean(p_init_msg_list) THEN

2656: request_status not in ('ACCEPTED', 'REJECTED');
2657:
2658: BEGIN
2659: -- Start standard API initialization
2660: IF FND_API.to_boolean(p_init_msg_list) THEN
2661: FND_MSG_PUB.initialize;
2662: END IF;
2663: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2664: l_api_name, g_pkg_name)

Line 2663: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

2659: -- Start standard API initialization
2660: IF FND_API.to_boolean(p_init_msg_list) THEN
2661: FND_MSG_PUB.initialize;
2662: END IF;
2663: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2664: l_api_name, g_pkg_name)
2665: THEN
2666: RAISE FND_API.g_exc_unexpected_error;
2667: END IF;

Line 2666: RAISE FND_API.g_exc_unexpected_error;

2662: END IF;
2663: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2664: l_api_name, g_pkg_name)
2665: THEN
2666: RAISE FND_API.g_exc_unexpected_error;
2667: END IF;
2668: x_return_status := FND_API.g_ret_sts_success;
2669: -- End standard API initialization
2670:

Line 2668: x_return_status := FND_API.g_ret_sts_success;

2664: l_api_name, g_pkg_name)
2665: THEN
2666: RAISE FND_API.g_exc_unexpected_error;
2667: END IF;
2668: x_return_status := FND_API.g_ret_sts_success;
2669: -- End standard API initialization
2670:
2671: -- Get the change request group id for the change requests if any
2672: if (p_po_release_id is not null) then

Line 2874: WHEN FND_API.g_exc_error THEN

2870:
2871:
2872:
2873: EXCEPTION
2874: WHEN FND_API.g_exc_error THEN
2875: x_return_status := FND_API.g_ret_sts_error;
2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN

Line 2875: x_return_status := FND_API.g_ret_sts_error;

2871:
2872:
2873: EXCEPTION
2874: WHEN FND_API.g_exc_error THEN
2875: x_return_status := FND_API.g_ret_sts_error;
2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2876: WHEN FND_API.g_exc_unexpected_error THEN

2872:
2873: EXCEPTION
2874: WHEN FND_API.g_exc_error THEN
2875: x_return_status := FND_API.g_ret_sts_error;
2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2877: x_return_status := FND_API.g_ret_sts_unexp_error;

2873: EXCEPTION
2874: WHEN FND_API.g_exc_error THEN
2875: x_return_status := FND_API.g_ret_sts_error;
2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 2879: x_return_status := FND_API.g_ret_sts_unexp_error;

2875: x_return_status := FND_API.g_ret_sts_error;
2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2882: IF (g_fnd_debug = 'Y') THEN
2883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 2919: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

2915: l_msg_data VARCHAR2(2000);
2916: l_ret_status VARCHAR2(20);
2917: BEGIN
2918:
2919: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2920: -- initialize message list
2921: FND_MSG_PUB.initialize;
2922: END IF;
2923:

Line 2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2922: END IF;
2923:
2924: -- Standard call to check for call compatibility.
2925:
2926: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2927: p_api_version,
2928: l_api_name,
2929: G_PKG_NAME)
2930: THEN

Line 2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2927: p_api_version,
2928: l_api_name,
2929: G_PKG_NAME)
2930: THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934: -- initialize return status
2935: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2935: x_return_status := FND_API.G_RET_STS_SUCCESS;

2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END IF;
2933:
2934: -- initialize return status
2935: x_return_status := FND_API.G_RET_STS_SUCCESS;
2936: if (p_document_subtype in ('STANDARD','PLANNED')) then
2937: l_document_type := 'PO';
2938:
2939: elsif (p_document_subtype in ('BLANKET','CONTRACT')) then

Line 2953: p_init_msg_list => FND_API.G_FALSE,

2949: -- First Find the Item Key for this Document if it were ever generated
2950: BEGIN
2951: PO_SIGNATURE_GRP.Find_Item_Key(
2952: p_api_version => 1.0,
2953: p_init_msg_list => FND_API.G_FALSE,
2954: p_po_header_id => p_po_header_id,
2955: p_revision_num => p_revision_num ,
2956: p_document_type => l_document_type ,
2957: x_itemkey => l_item_key,

Line 2972: p_init_msg_list => FND_API.G_FALSE,

2968: BEGIN
2969:
2970: PO_SIGNATURE_GRP.Get_Item_Key(
2971: p_api_version => 1.0,
2972: p_init_msg_list => FND_API.G_FALSE,
2973: p_po_header_id => p_po_header_id,
2974: p_revision_num => p_revision_num ,
2975: p_document_type => l_document_type ,
2976: x_itemkey => l_item_key,

Line 3000: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

2996: p_org_id ,
2997: p_Agent_Id ,
2998: p_supplier_user_id ) ;
2999:
3000: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
3001: x_notification_id := getSigNotifId(l_item_type, l_item_key);
3002: if x_notification_id is null then
3003: RAISE sig_notif_notfound;
3004: end if;

Line 3035: p_init_msg_list => FND_API.G_FALSE,

3031: -- Abort the previous process and start a new one
3032: BEGIN
3033: PO_SIGNATURE_GRP.Abort_Doc_Sign_Process(
3034: p_api_version => 1.0,
3035: p_init_msg_list => FND_API.G_FALSE,
3036: p_itemkey => l_item_key,
3037: x_result => x_result,
3038: x_return_status => l_ret_status,
3039: x_msg_count => l_msg_count,

Line 3048: p_init_msg_list => FND_API.G_FALSE,

3044: BEGIN
3045:
3046: PO_SIGNATURE_GRP.Get_Item_Key(
3047: p_api_version => 1.0,
3048: p_init_msg_list => FND_API.G_FALSE,
3049: p_po_header_id => p_po_header_id,
3050: p_revision_num => p_revision_num ,
3051: p_document_type => l_document_type ,
3052: x_itemkey => l_item_key,

Line 3087: WHEN FND_API.g_exc_error THEN

3083: end if;
3084: END IF;
3085:
3086: EXCEPTION
3087: WHEN FND_API.g_exc_error THEN
3088: x_return_status := FND_API.g_ret_sts_error;
3089: WHEN FND_API.g_exc_unexpected_error THEN
3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN

Line 3088: x_return_status := FND_API.g_ret_sts_error;

3084: END IF;
3085:
3086: EXCEPTION
3087: WHEN FND_API.g_exc_error THEN
3088: x_return_status := FND_API.g_ret_sts_error;
3089: WHEN FND_API.g_exc_unexpected_error THEN
3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN
3092: IF g_fnd_debug = 'Y' THEN

Line 3089: WHEN FND_API.g_exc_unexpected_error THEN

3085:
3086: EXCEPTION
3087: WHEN FND_API.g_exc_error THEN
3088: x_return_status := FND_API.g_ret_sts_error;
3089: WHEN FND_API.g_exc_unexpected_error THEN
3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN
3092: IF g_fnd_debug = 'Y' THEN
3093: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3090: x_return_status := FND_API.g_ret_sts_unexp_error;

3086: EXCEPTION
3087: WHEN FND_API.g_exc_error THEN
3088: x_return_status := FND_API.g_ret_sts_error;
3089: WHEN FND_API.g_exc_unexpected_error THEN
3090: x_return_status := FND_API.g_ret_sts_unexp_error;
3091: WHEN sig_notif_notfound THEN
3092: IF g_fnd_debug = 'Y' THEN
3093: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3094: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||

Line 3098: x_return_status := FND_API.g_ret_sts_error;

3094: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3095: l_item_key || '.Notification not found exception' ,sqlcode);
3096: END IF;
3097: END IF;
3098: x_return_status := FND_API.g_ret_sts_error;
3099: WHEN OTHERS THEN
3100: x_return_status := FND_API.g_ret_sts_unexp_error;
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 3100: x_return_status := FND_API.g_ret_sts_unexp_error;

3096: END IF;
3097: END IF;
3098: x_return_status := FND_API.g_ret_sts_error;
3099: WHEN OTHERS THEN
3100: x_return_status := FND_API.g_ret_sts_unexp_error;
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3103: IF g_fnd_debug = 'Y' THEN
3104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3142: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

3138: l_msg_data VARCHAR2(2000);
3139: l_ret_status VARCHAR2(20);
3140: BEGIN
3141:
3142: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
3143: -- initialize message list
3144: FND_MSG_PUB.initialize;
3145: END IF;
3146:

Line 3149: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3145: END IF;
3146:
3147: -- Standard call to check for call compatibility.
3148:
3149: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3150: p_api_version,
3151: l_api_name,
3152: G_PKG_NAME)
3153: THEN

Line 3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3150: p_api_version,
3151: l_api_name,
3152: G_PKG_NAME)
3153: THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: -- initialize return status
3158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3158: x_return_status := FND_API.G_RET_STS_SUCCESS;

3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: -- initialize return status
3158: x_return_status := FND_API.G_RET_STS_SUCCESS;
3159: if (p_document_subtype in ('STANDARD','PLANNED')) then
3160: l_document_type := 'PO';
3161:
3162: elsif (p_document_subtype in ('BLANKET','CONTRACT')) then

Line 3177: p_init_msg_list => FND_API.G_FALSE,

3173: -- First Find the Item Key for this Document if it were ever generated
3174: BEGIN
3175: PO_SIGNATURE_GRP.Find_Item_Key(
3176: p_api_version => 1.0,
3177: p_init_msg_list => FND_API.G_FALSE,
3178: p_po_header_id => p_po_header_id,
3179: p_revision_num => p_revision_num ,
3180: p_document_type => l_document_type ,
3181: x_itemkey => l_item_key,

Line 3196: p_init_msg_list => FND_API.G_FALSE,

3192: BEGIN
3193:
3194: PO_SIGNATURE_GRP.Get_Item_Key(
3195: p_api_version => 1.0,
3196: p_init_msg_list => FND_API.G_FALSE,
3197: p_po_header_id => p_po_header_id,
3198: p_revision_num => p_revision_num ,
3199: p_document_type => l_document_type ,
3200: x_itemkey => l_item_key,

Line 3225: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

3221: p_Agent_Id ,
3222: p_supplier_user_id,
3223: p_draft_id ) ;
3224:
3225: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
3226: x_notification_id := getSigNotifId(l_item_type, l_item_key);
3227: if x_notification_id is null then
3228: RAISE sig_notif_notfound;
3229: end if;

Line 3260: p_init_msg_list => FND_API.G_FALSE,

3256: -- Abort the previous process and start a new one
3257: BEGIN
3258: PO_SIGNATURE_GRP.Abort_Doc_Sign_Process(
3259: p_api_version => 1.0,
3260: p_init_msg_list => FND_API.G_FALSE,
3261: p_itemkey => l_item_key,
3262: x_result => x_result,
3263: x_return_status => l_ret_status,
3264: x_msg_count => l_msg_count,

Line 3273: p_init_msg_list => FND_API.G_FALSE,

3269: BEGIN
3270:
3271: PO_SIGNATURE_GRP.Get_Item_Key(
3272: p_api_version => 1.0,
3273: p_init_msg_list => FND_API.G_FALSE,
3274: p_po_header_id => p_po_header_id,
3275: p_revision_num => p_revision_num ,
3276: p_document_type => l_document_type ,
3277: x_itemkey => l_item_key,

Line 3313: WHEN FND_API.g_exc_error THEN

3309: end if;
3310: END IF;
3311:
3312: EXCEPTION
3313: WHEN FND_API.g_exc_error THEN
3314: x_return_status := FND_API.g_ret_sts_error;
3315: WHEN FND_API.g_exc_unexpected_error THEN
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN

Line 3314: x_return_status := FND_API.g_ret_sts_error;

3310: END IF;
3311:
3312: EXCEPTION
3313: WHEN FND_API.g_exc_error THEN
3314: x_return_status := FND_API.g_ret_sts_error;
3315: WHEN FND_API.g_exc_unexpected_error THEN
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN
3318: IF g_fnd_debug = 'Y' THEN

Line 3315: WHEN FND_API.g_exc_unexpected_error THEN

3311:
3312: EXCEPTION
3313: WHEN FND_API.g_exc_error THEN
3314: x_return_status := FND_API.g_ret_sts_error;
3315: WHEN FND_API.g_exc_unexpected_error THEN
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN
3318: IF g_fnd_debug = 'Y' THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3316: x_return_status := FND_API.g_ret_sts_unexp_error;

3312: EXCEPTION
3313: WHEN FND_API.g_exc_error THEN
3314: x_return_status := FND_API.g_ret_sts_error;
3315: WHEN FND_API.g_exc_unexpected_error THEN
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: WHEN sig_notif_notfound THEN
3318: IF g_fnd_debug = 'Y' THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||

Line 3324: x_return_status := FND_API.g_ret_sts_error;

3320: FND_LOG.string(FND_LOG.level_unexpected, l_api_name ||
3321: l_item_key || '.Notification not found exception' ,sqlcode);
3322: END IF;
3323: END IF;
3324: x_return_status := FND_API.g_ret_sts_error;
3325: WHEN OTHERS THEN
3326: x_return_status := FND_API.g_ret_sts_unexp_error;
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 3326: x_return_status := FND_API.g_ret_sts_unexp_error;

3322: END IF;
3323: END IF;
3324: x_return_status := FND_API.g_ret_sts_error;
3325: WHEN OTHERS THEN
3326: x_return_status := FND_API.g_ret_sts_unexp_error;
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3329: IF g_fnd_debug = 'Y' THEN
3330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 3934: x_ret_sts := fnd_api.g_ret_sts_unexp_error;

3930: x_ret_sts := 'Y';
3931: END IF;
3932: EXCEPTION
3933: WHEN OTHERS THEN RAISE;
3934: x_ret_sts := fnd_api.g_ret_sts_unexp_error;
3935: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3936: THEN
3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);
3938: IF g_fnd_debug = 'Y' THEN