APPS.POS_PRODUCT_SERVICE_BO_PKG dependencies on FND_API

Line 39: x_return_status := fnd_api.g_ret_sts_success;

35: l_concatenated_segments VARCHAR2(4000) := NULL;
36: l_category_id VARCHAR2(10);
37: BEGIN
38: -- Initialize API return status to success
39: x_return_status := fnd_api.g_ret_sts_success;
40: x_prod_valid := 'Y';
41:
42: -- Below API would give the delimiter and the segment definition to be inserted
43: pos_product_service_utl_pkg.initialize(x_status => l_status,

Line 56: x_return_status := fnd_api.g_ret_sts_error;

52: -- inserted is equal to the product segment count
53: IF (p_vendor_prodsrv_rec.segment_definition <>
54: l_product_segment_definition) THEN
55: x_prod_valid := 'N';
56: x_return_status := fnd_api.g_ret_sts_error;
57: x_msg_data := 'AP_INVALID_SEGMENT_DEF';
58: RETURN;
59: END IF;
60:

Line 147: x_return_status := fnd_api.g_ret_sts_error;

143: length(REPLACE(l_segment_concat, '.', '')));
144:
145: IF (l_segment_count <> l_product_segment_count) THEN
146: x_prod_valid := 'N';
147: x_return_status := fnd_api.g_ret_sts_error;
148: x_msg_data := 'AP_INVALID_SEGMENT_COUNT';
149: RETURN;
150: END IF;
151:

Line 155: x_return_status := fnd_api.g_ret_sts_unexp_error;

151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: x_prod_valid := 'N';
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156:
157: fnd_msg_pub.count_and_get(p_count => x_msg_count,
158: p_data => x_msg_data);
159: END validate_vendor_prods_services;

Line 239: x_return_status := fnd_api.g_ret_sts_success;

235: WHERE ap.party_id = l_party_id
236: AND ps.vendor_id = ap.vendor_id;
237:
238: x_pos_product_service_bo_tbl := l_pos_product_service_bo_tbl;
239: x_return_status := fnd_api.g_ret_sts_success;
240: x_msg_data := 'SUCCESS';
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243:

Line 242: WHEN fnd_api.g_exc_error THEN

238: x_pos_product_service_bo_tbl := l_pos_product_service_bo_tbl;
239: x_return_status := fnd_api.g_ret_sts_success;
240: x_msg_data := 'SUCCESS';
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243:
244: x_return_status := fnd_api.g_ret_sts_error;
245: x_msg_count := 1;
246: x_msg_data := SQLCODE || SQLERRM;

Line 244: x_return_status := fnd_api.g_ret_sts_error;

240: x_msg_data := 'SUCCESS';
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN
243:
244: x_return_status := fnd_api.g_ret_sts_error;
245: x_msg_count := 1;
246: x_msg_data := SQLCODE || SQLERRM;
247: WHEN fnd_api.g_exc_unexpected_error THEN
248:

Line 247: WHEN fnd_api.g_exc_unexpected_error THEN

243:
244: x_return_status := fnd_api.g_ret_sts_error;
245: x_msg_count := 1;
246: x_msg_data := SQLCODE || SQLERRM;
247: WHEN fnd_api.g_exc_unexpected_error THEN
248:
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: x_msg_count := 1;
251: x_msg_data := SQLCODE || SQLERRM;

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error;

245: x_msg_count := 1;
246: x_msg_data := SQLCODE || SQLERRM;
247: WHEN fnd_api.g_exc_unexpected_error THEN
248:
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: x_msg_count := 1;
251: x_msg_data := SQLCODE || SQLERRM;
252: WHEN OTHERS THEN
253:

Line 254: x_return_status := fnd_api.g_ret_sts_unexp_error;

250: x_msg_count := 1;
251: x_msg_data := SQLCODE || SQLERRM;
252: WHEN OTHERS THEN
253:
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255:
256: x_msg_count := 1;
257: x_msg_data := SQLCODE || SQLERRM;
258: END get_pos_product_service_bo_tbl;

Line 370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

366: x_return_status => l_return_status,
367: x_msg_count => l_msg_count,
368: x_msg_data => l_msg_data);
369:
370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
371: x_return_status := l_return_status;
372: x_msg_count := l_msg_count;
373: x_msg_data := l_msg_data;
374: RETURN;

Line 415: WHEN fnd_api.g_exc_error THEN

411: END IF;
412: END LOOP;
413:
414: EXCEPTION
415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417: fnd_msg_pub.count_and_get(p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN fnd_api.g_exc_unexpected_error THEN

Line 416: x_return_status := fnd_api.g_ret_sts_error;

412: END LOOP;
413:
414: EXCEPTION
415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417: fnd_msg_pub.count_and_get(p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN fnd_api.g_exc_unexpected_error THEN
420: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 419: WHEN fnd_api.g_exc_unexpected_error THEN

415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417: fnd_msg_pub.count_and_get(p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN fnd_api.g_exc_unexpected_error THEN
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: fnd_msg_pub.count_and_get(p_count => x_msg_count,
422: p_data => x_msg_data);
423: WHEN OTHERS THEN

Line 420: x_return_status := fnd_api.g_ret_sts_unexp_error;

416: x_return_status := fnd_api.g_ret_sts_error;
417: fnd_msg_pub.count_and_get(p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN fnd_api.g_exc_unexpected_error THEN
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: fnd_msg_pub.count_and_get(p_count => x_msg_count,
422: p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 424: x_return_status := fnd_api.g_ret_sts_unexp_error;

420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: fnd_msg_pub.count_and_get(p_count => x_msg_count,
422: p_data => x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425:
426: fnd_msg_pub.count_and_get(p_count => x_msg_count,
427: p_data => x_msg_data);
428: END create_pos_product_service;

Line 457: x_return_status := fnd_api.g_ret_sts_success;

453: last_update_date = SYSDATE,
454: last_update_login = fnd_global.login_id
455: WHERE classification_id = p_req_id;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 459: WHEN fnd_api.g_exc_error THEN

455: WHERE classification_id = p_req_id;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,
462: p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456:
457: x_return_status := fnd_api.g_ret_sts_success;
458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,
462: p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 463: WHEN fnd_api.g_exc_unexpected_error THEN

459: WHEN fnd_api.g_exc_error THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,
462: p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_msg_pub.count_and_get(p_count => x_msg_count,
466: p_data => x_msg_data);
467: WHEN OTHERS THEN

Line 464: x_return_status := fnd_api.g_ret_sts_unexp_error;

460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,
462: p_data => x_msg_data);
463: WHEN fnd_api.g_exc_unexpected_error THEN
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_msg_pub.count_and_get(p_count => x_msg_count,
466: p_data => x_msg_data);
467: WHEN OTHERS THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 468: x_return_status := fnd_api.g_ret_sts_unexp_error;

464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_msg_pub.count_and_get(p_count => x_msg_count,
466: p_data => x_msg_data);
467: WHEN OTHERS THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469:
470: fnd_msg_pub.count_and_get(p_count => x_msg_count,
471: p_data => x_msg_data);
472: END update_pos_prod_service_status;