DBA Data[Home] [Help]

APPS.POS_REQUEST_UTILS_PKG dependencies on FND_API

Line 27: x_return_status := fnd_api.g_ret_sts_success;

23: BEGIN
24: pos_spm_wf_pkg1.send_supplier_invite_reg_ntf
25: (p_supplier_reg_id => p_supplier_reg_id);
26:
27: x_return_status := fnd_api.g_ret_sts_success;
28:
29: END pos_src_register_supplier;
30:
31: PROCEDURE pos_src_approve_rfq_supplier

Line 52: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

48: x_return_status => x_return_status,
49: x_msg_count => x_msg_count,
50: x_msg_data => x_msg_data
51: );
52: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
53: ROLLBACK TO approve_rfqa_supplier_sp;
54: RETURN;
55: END IF;
56:

Line 62: x_return_status := fnd_api.g_ret_sts_error;

58: FETCH l_cur INTO x_vendor_id, x_party_id;
59: IF l_cur%notfound THEN
60: CLOSE l_cur;
61: ROLLBACK TO approve_rfqa_supplier_sp;
62: x_return_status := fnd_api.g_ret_sts_error;
63: x_msg_count := 1;
64: x_msg_data := 'failed to find vendor or vendor site row after approve_rfq_supplier';
65: RETURN;
66: END IF;

Line 101: x_return_status := fnd_api.g_ret_sts_error;

97: OPEN l_cur1;
98: FETCH l_cur1 INTO x_vendor_id, x_party_site_id, x_vendor_site_id;
99: IF l_cur1%notfound THEN
100: CLOSE l_cur1;
101: x_return_status := fnd_api.g_ret_sts_error;
102: x_msg_count := 1;
103: x_msg_data := 'no site found for p_supplier_party_id ' || p_supplier_party_id
104: || ' p_org_id ' || p_org_id;
105: RETURN;

Line 113: x_return_status := fnd_api.g_ret_sts_error;

109: OPEN l_cur2;
110: FETCH l_cur2 INTO x_contact_party_id;
111: IF l_cur2%notfound THEN
112: CLOSE l_cur2;
113: x_return_status := fnd_api.g_ret_sts_error;
114: x_msg_count := 1;
115: x_msg_data := 'no contact party found for vendor_id ' || x_vendor_id;
116: RETURN;
117: END IF;

Line 120: x_return_status := fnd_api.g_ret_sts_success;

116: RETURN;
117: END IF;
118: CLOSE l_cur2;
119:
120: x_return_status := fnd_api.g_ret_sts_success;
121:
122: END pos_src_get_supplier_det;
123:
124: PROCEDURE pos_get_contact_approved_det

Line 141: x_return_status := fnd_api.g_ret_sts_error;

137: OPEN l_cur;
138: FETCH l_cur INTO x_contact_party_id;
139: IF l_cur%notfound THEN
140: CLOSE l_cur;
141: x_return_status := fnd_api.g_ret_sts_error;
142: x_msg_count := 1;
143: x_msg_data := 'no contact party found for p_contact_req_id ' || p_contact_req_id;
144: RETURN;
145: END IF;

Line 148: x_return_status := fnd_api.g_ret_sts_success;

144: RETURN;
145: END IF;
146: CLOSE l_cur;
147:
148: x_return_status := fnd_api.g_ret_sts_success;
149:
150: END pos_get_contact_approved_det;
151:
152: END POS_REQUEST_UTILS_PKG;