DBA Data[Home] [Help]

APPS.CSD_MASS_RCV_PVT dependencies on FND_MSG_PUB

Line 113: fnd_msg_pub.initialize;

109:
110: IF fnd_api.to_boolean (p_init_msg_list)
111: THEN
112: -- initialize message list
113: fnd_msg_pub.initialize;
114: END IF;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT fnd_api.compatible_api_call (l_api_version_number,

Line 177: fnd_msg_pub.ADD;

173: --Validations: If te status of repair order is not 'Draft' then raise error.
174: IF NVL (l_repair_line_status, ' ') <> c_draft_status
175: THEN
176: fnd_message.set_name ('CSD', 'CSD_INVALID_REPAIR_ORDER');
177: fnd_msg_pub.ADD;
178: RAISE fnd_api.g_exc_error;
179: END IF;
180:
181: IF (l_event_level >= l_debug_level)

Line 437: fnd_msg_pub.ADD;

433:
434: IF (l_count_sn = 0)
435: THEN
436: fnd_message.set_name ('CSD', 'CSD_NO_SERIAL_NUMBERS');
437: fnd_msg_pub.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:
441:

Line 505: fnd_msg_pub.count_and_get (p_count => x_msg_count,

501: COMMIT WORK;
502: END IF;
503:
504: -- Standard call to get message count and IF count is get message info.
505: fnd_msg_pub.count_and_get (p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: IF (fnd_log.level_procedure >= l_debug_level)
509: THEN

Line 521: fnd_msg_pub.count_and_get (p_count => x_msg_count,

517: THEN
518: x_return_status := fnd_api.g_ret_sts_error;
519: log_error_stack ();
520: ROLLBACK TO sp_mass_create_ro;
521: fnd_msg_pub.count_and_get (p_count => x_msg_count,
522: p_data => x_msg_data
523: );
524:
525: IF (fnd_log.level_error >= l_debug_level)

Line 536: fnd_msg_pub.count_and_get (p_count => x_msg_count,

532: WHEN fnd_api.g_exc_unexpected_error
533: THEN
534: x_return_status := fnd_api.g_ret_sts_unexp_error;
535: ROLLBACK TO sp_mass_create_ro;
536: fnd_msg_pub.count_and_get (p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539:
540: IF (fnd_log.level_exception >= l_debug_level)

Line 552: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

548: THEN
549: x_return_status := fnd_api.g_ret_sts_unexp_error;
550: ROLLBACK TO sp_mass_create_ro;
551:
552: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
553: THEN
554: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:

Line 554: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

550: ROLLBACK TO sp_mass_create_ro;
551:
552: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
553: THEN
554: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:
557: fnd_msg_pub.count_and_get (p_count => x_msg_count,
558: p_data => x_msg_data

Line 557: fnd_msg_pub.count_and_get (p_count => x_msg_count,

553: THEN
554: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
555: END IF;
556:
557: fnd_msg_pub.count_and_get (p_count => x_msg_count,
558: p_data => x_msg_data
559: );
560:
561: IF (fnd_log.level_unexpected >= l_debug_level)

Line 652: fnd_msg_pub.initialize;

648:
649: IF fnd_api.to_boolean (p_init_msg_list)
650: THEN
651: -- initialize message list
652: fnd_msg_pub.initialize;
653: END IF;
654:
655: -- Standard call to check for call compatibility.
656: IF NOT fnd_api.compatible_api_call (l_api_version_number,

Line 752: fnd_msg_pub.ADD;

748: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
749: fnd_message.set_token ('REPAIR_LINE_ID',
750: p_repair_line_id
751: );
752: fnd_msg_pub.ADD;
753: CLOSE cur_repair_order;
754: RAISE fnd_api.g_exc_error;
755: END IF;
756:

Line 780: FND_MSG_PUB.Add;

776: IF (cur_repair_type_ref%NOTFOUND)
777: THEN
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
779: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
780: FND_MSG_PUB.Add;
781: CLOSE cur_repair_type_ref;
782: RAISE fnd_api.g_exc_error;
783: END IF;
784:

Line 800: FND_MSG_PUB.ADD;

796: /*
797: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
798: dbms_output.put_line('Error condition');
799: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: */
804: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 998: fnd_msg_pub.count_and_get (p_count => x_msg_count,

994: COMMIT WORK;
995: END IF;
996:
997: -- Standard call to get message count and IF count is get message info.
998: fnd_msg_pub.count_and_get (p_count => x_msg_count,
999: p_data => x_msg_data);
1000:
1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1002: THEN

Line 1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1009: WHEN fnd_api.g_exc_error
1010: THEN
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: ROLLBACK TO sp_process_ro;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:
1017: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

Line 1028: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1024: WHEN fnd_api.g_exc_unexpected_error
1025: THEN
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027: ROLLBACK TO sp_process_ro;
1028: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );
1031:
1032: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1044: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1040: THEN
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: ROLLBACK TO sp_process_ro;
1043:
1044: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1045: THEN
1046: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1047: END IF;
1048:

Line 1046: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1042: ROLLBACK TO sp_process_ro;
1043:
1044: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1045: THEN
1046: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1047: END IF;
1048:
1049: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1050: p_data => x_msg_data

Line 1049: fnd_msg_pub.count_and_get (p_count => x_msg_count,

1045: THEN
1046: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1047: END IF;
1048:
1049: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );
1052:
1053: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1236: fnd_msg_pub.initialize;

1232:
1233: IF fnd_api.to_boolean (p_init_msg_list)
1234: THEN
1235: -- initialize message list
1236: fnd_msg_pub.initialize;
1237: END IF;
1238:
1239: -- Standard call to check for call compatibility.
1240: IF NOT fnd_api.compatible_api_call (l_api_version_number,

Line 1284: fnd_msg_pub.ADD;

1280: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1281: fnd_message.set_token ('REPAIR_LINE_ID',
1282: p_product_txn_rec.repair_line_id
1283: );
1284: fnd_msg_pub.ADD;
1285:
1286: CLOSE cur_ro_details;
1287:
1288: RAISE fnd_api.g_exc_error;

Line 1404: fnd_msg_pub.ADD;

1400: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1401: fnd_message.set_token ('CONTRACT_LINE_ID',
1402: p_product_txn_rec.contract_id
1403: );
1404: fnd_msg_pub.ADD;
1405:
1406: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1407: THEN
1408: fnd_log.STRING

Line 1441: fnd_msg_pub.ADD;

1437: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1438: THEN
1439: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1440: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1441: fnd_msg_pub.ADD;
1442:
1443: CLOSE cur_cust_details;
1444:
1445: RAISE fnd_api.g_exc_error;

Line 1494: fnd_msg_pub.ADD;

1490: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1491: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1492: p_product_txn_rec.txn_billing_type_id
1493: );
1494: fnd_msg_pub.ADD;
1495: RAISE fnd_api.g_exc_error;
1496: END IF;
1497:
1498: ---------------------------------------------------------------------------------7

Line 1517: fnd_msg_pub.ADD;

1513: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1514: fnd_message.set_token ('INVENTORY_ITEM_ID',
1515: p_product_txn_rec.inventory_item_id
1516: );
1517: fnd_msg_pub.ADD;
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1520: THEN
1521: fnd_log.STRING

Line 1550: fnd_msg_pub.ADD;

1546: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1547: fnd_message.set_token ('PRICE_LIST_ID',
1548: p_product_txn_rec.price_list_id
1549: );
1550: fnd_msg_pub.ADD;
1551:
1552: CLOSE cur_pricelist_details;
1553:
1554: RAISE fnd_api.g_exc_error;

Line 2001: fnd_msg_pub.ADD;

1997: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
1998: fnd_message.set_token ('REPAIR_LINE_ID',
1999: p_product_txn_rec.repair_line_id
2000: );
2001: fnd_msg_pub.ADD;
2002: RAISE fnd_api.g_exc_error;
2003: END IF;
2004:
2005: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2024: fnd_msg_pub.ADD;

2020: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2021: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2022: p_product_txn_rec.product_transaction_id
2023: );
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;
2026: END IF;
2027:
2028: ----------------------------------------------------------------------------

Line 2039: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2035: COMMIT WORK;
2036: END IF;
2037:
2038: -- Standard call to get message count and IF count is get message info.
2039: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2040: p_data => x_msg_data);
2041:
2042: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2043: THEN

Line 2055: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2051: THEN
2052: x_return_status := fnd_api.g_ret_sts_error;
2053: log_error_stack ();
2054: ROLLBACK TO sp_create_product_txn;
2055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data
2057: );
2058:
2059: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

Line 2070: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2066: WHEN fnd_api.g_exc_unexpected_error
2067: THEN
2068: x_return_status := fnd_api.g_ret_sts_unexp_error;
2069: ROLLBACK TO sp_create_product_txn;
2070: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2071: p_data => x_msg_data
2072: );
2073:
2074: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 2086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2082: THEN
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: ROLLBACK TO sp_create_product_txn;
2085:
2086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2087: THEN
2088: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2089: END IF;
2090:

Line 2088: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2084: ROLLBACK TO sp_create_product_txn;
2085:
2086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2087: THEN
2088: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2089: END IF;
2090:
2091: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2092: p_data => x_msg_data

Line 2091: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2087: THEN
2088: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2089: END IF;
2090:
2091: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2092: p_data => x_msg_data
2093: );
2094:
2095: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2171: fnd_msg_pub.initialize;

2167:
2168: -- Initialize message list if p_init_msg_list is set to TRUE.
2169: IF fnd_api.to_boolean (p_init_msg_list)
2170: THEN
2171: fnd_msg_pub.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success
2175: x_return_status := fnd_api.g_ret_sts_success;

Line 2311: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2307: COMMIT WORK;
2308: END IF;
2309:
2310: -- Standard call to get message count and if count is 1, get message info.
2311: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2312: p_data => x_msg_data);
2313:
2314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2315: THEN

Line 2327: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2323: WHEN fnd_api.g_exc_error
2324: THEN
2325: ROLLBACK TO create_item_instance;
2326: x_return_status := fnd_api.g_ret_sts_error;
2327: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2328: p_data => x_msg_data
2329: );
2330:
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

Line 2343: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2339: WHEN fnd_api.g_exc_unexpected_error
2340: THEN
2341: ROLLBACK TO create_item_instance;
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2344: p_data => x_msg_data
2345: );
2346:
2347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 2360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2356: THEN
2357: ROLLBACK TO create_item_instance;
2358: x_return_status := fnd_api.g_ret_sts_unexp_error;
2359:
2360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2361: THEN
2362: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2363: END IF;
2364:

Line 2362: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);

2358: x_return_status := fnd_api.g_ret_sts_unexp_error;
2359:
2360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2361: THEN
2362: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2363: END IF;
2364:
2365: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2366: p_data => x_msg_data

Line 2365: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2361: THEN
2362: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2363: END IF;
2364:
2365: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2366: p_data => x_msg_data
2367: );
2368:
2369: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2578: fnd_msg_pub.ADD;

2574: EXCEPTION
2575: WHEN OTHERS
2576: THEN
2577: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END;
2581: END IF;
2582:

Line 2635: fnd_msg_pub.ADD;

2631: WHEN NO_DATA_FOUND
2632: THEN
2633: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2634: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_exc_error;
2637: END is_item_pre_serialized;
2638:
2639: ------------------------------------------------------------------------------

Line 2663: fnd_msg_pub.ADD;

2659: WHEN NO_DATA_FOUND
2660: THEN
2661: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2662: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: END is_item_ib_trackable;
2666:
2667: ----------------------------------------------------------------------

Line 2735: fnd_msg_pub.ADD;

2731: /*
2732: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2734: */
2735: fnd_msg_pub.ADD;
2736:
2737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2738: THEN
2739: fnd_log.STRING (fnd_log.level_statement,

Line 2773: fnd_msg_pub.ADD;

2769: IF (cur_ord_line%NOTFOUND)
2770: THEN
2771: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2772: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2773: fnd_msg_pub.ADD;
2774:
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2776: THEN
2777: fnd_log.STRING (fnd_log.level_statement,

Line 2806: fnd_msg_pub.ADD;

2802: IF l_ship_from_org_id IS NULL
2803: THEN
2804: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2805: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2806: fnd_msg_pub.ADD;
2807:
2808: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2809: THEN
2810: fnd_log.STRING (fnd_log.level_statement,

Line 2824: fnd_msg_pub.ADD;

2820: IF l_unit_selling_price IS NULL
2821: THEN
2822: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2823: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2824: fnd_msg_pub.ADD;
2825:
2826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2827: THEN
2828: fnd_log.STRING (fnd_log.level_statement,

Line 2849: fnd_msg_pub.ADD;

2845: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2846: fnd_message.set_token ('ORDER_HEADER_ID',
2847: p_order_rec.order_header_id
2848: );
2849: fnd_msg_pub.ADD;
2850:
2851: CLOSE cur_ord_hdr;
2852:
2853: RAISE fnd_api.g_exc_error;

Line 2875: l_count := fnd_msg_pub.count_msg ();

2871: l_count NUMBER;
2872: l_msg VARCHAR2 (2000);
2873: l_index_out NUMBER;
2874: BEGIN
2875: l_count := fnd_msg_pub.count_msg ();
2876:
2877: IF (l_count > 0)
2878: THEN
2879: FOR i IN 1 .. l_count

Line 2881: fnd_msg_pub.get (p_msg_index => i,

2877: IF (l_count > 0)
2878: THEN
2879: FOR i IN 1 .. l_count
2880: LOOP
2881: fnd_msg_pub.get (p_msg_index => i,
2882: p_encoded => 'F',
2883: p_data => l_msg,
2884: p_msg_index_out => l_index_out
2885: );