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.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 653: fnd_msg_pub.initialize;

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

Line 758: fnd_msg_pub.ADD;

754: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
755: fnd_message.set_token ('REPAIR_LINE_ID',
756: p_repair_line_id
757: );
758: fnd_msg_pub.ADD;
759: CLOSE cur_repair_order;
760: RAISE fnd_api.g_exc_error;
761: END IF;
762:

Line 786: FND_MSG_PUB.Add;

782: IF (cur_repair_type_ref%NOTFOUND)
783: THEN
784: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
785: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
786: FND_MSG_PUB.Add;
787: CLOSE cur_repair_type_ref;
788: RAISE fnd_api.g_exc_error;
789: END IF;
790:

Line 806: FND_MSG_PUB.ADD;

802: /*
803: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
804: dbms_output.put_line('Error condition');
805: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: */
810: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

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

1000: COMMIT WORK;
1001: END IF;
1002:
1003: -- Standard call to get message count and IF count is get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:
1007: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1008: THEN

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

1015: WHEN fnd_api.g_exc_error
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: ROLLBACK TO sp_process_ro;
1019: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022:
1023: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

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

1030: WHEN fnd_api.g_exc_unexpected_error
1031: THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033: ROLLBACK TO sp_process_ro;
1034: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:
1038: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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

1046: THEN
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048: ROLLBACK TO sp_process_ro;
1049:
1050: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1051: THEN
1052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1053: END IF;
1054:

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

1048: ROLLBACK TO sp_process_ro;
1049:
1050: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1051: THEN
1052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1053: END IF;
1054:
1055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1056: p_data => x_msg_data

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

1051: THEN
1052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1053: END IF;
1054:
1055: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058:
1059: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1242: fnd_msg_pub.initialize;

1238:
1239: IF fnd_api.to_boolean (p_init_msg_list)
1240: THEN
1241: -- initialize message list
1242: fnd_msg_pub.initialize;
1243: END IF;
1244:
1245: -- Standard call to check for call compatibility.
1246: IF NOT fnd_api.compatible_api_call (l_api_version_number,

Line 1290: fnd_msg_pub.ADD;

1286: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1287: fnd_message.set_token ('REPAIR_LINE_ID',
1288: p_product_txn_rec.repair_line_id
1289: );
1290: fnd_msg_pub.ADD;
1291:
1292: CLOSE cur_ro_details;
1293:
1294: RAISE fnd_api.g_exc_error;

Line 1410: fnd_msg_pub.ADD;

1406: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1407: fnd_message.set_token ('CONTRACT_LINE_ID',
1408: p_product_txn_rec.contract_id
1409: );
1410: fnd_msg_pub.ADD;
1411:
1412: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1413: THEN
1414: fnd_log.STRING

Line 1447: fnd_msg_pub.ADD;

1443: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1444: THEN
1445: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1446: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1447: fnd_msg_pub.ADD;
1448:
1449: CLOSE cur_cust_details;
1450:
1451: RAISE fnd_api.g_exc_error;

Line 1500: fnd_msg_pub.ADD;

1496: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1497: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1498: p_product_txn_rec.txn_billing_type_id
1499: );
1500: fnd_msg_pub.ADD;
1501: RAISE fnd_api.g_exc_error;
1502: END IF;
1503:
1504: ---------------------------------------------------------------------------------7

Line 1523: fnd_msg_pub.ADD;

1519: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1520: fnd_message.set_token ('INVENTORY_ITEM_ID',
1521: p_product_txn_rec.inventory_item_id
1522: );
1523: fnd_msg_pub.ADD;
1524:
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1526: THEN
1527: fnd_log.STRING

Line 1556: fnd_msg_pub.ADD;

1552: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1553: fnd_message.set_token ('PRICE_LIST_ID',
1554: p_product_txn_rec.price_list_id
1555: );
1556: fnd_msg_pub.ADD;
1557:
1558: CLOSE cur_pricelist_details;
1559:
1560: RAISE fnd_api.g_exc_error;

Line 2007: fnd_msg_pub.ADD;

2003: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
2004: fnd_message.set_token ('REPAIR_LINE_ID',
2005: p_product_txn_rec.repair_line_id
2006: );
2007: fnd_msg_pub.ADD;
2008: RAISE fnd_api.g_exc_error;
2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2030: fnd_msg_pub.ADD;

2026: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2027: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2028: p_product_txn_rec.product_transaction_id
2029: );
2030: fnd_msg_pub.ADD;
2031: RAISE fnd_api.g_exc_error;
2032: END IF;
2033:
2034: ----------------------------------------------------------------------------

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

2041: COMMIT WORK;
2042: END IF;
2043:
2044: -- Standard call to get message count and IF count is get message info.
2045: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2046: p_data => x_msg_data);
2047:
2048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2049: THEN

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

2057: THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059: log_error_stack ();
2060: ROLLBACK TO sp_create_product_txn;
2061: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2062: p_data => x_msg_data
2063: );
2064:
2065: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)

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

2072: WHEN fnd_api.g_exc_unexpected_error
2073: THEN
2074: x_return_status := fnd_api.g_ret_sts_unexp_error;
2075: ROLLBACK TO sp_create_product_txn;
2076: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2077: p_data => x_msg_data
2078: );
2079:
2080: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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

2088: THEN
2089: x_return_status := fnd_api.g_ret_sts_unexp_error;
2090: ROLLBACK TO sp_create_product_txn;
2091:
2092: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2093: THEN
2094: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2095: END IF;
2096:

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

2090: ROLLBACK TO sp_create_product_txn;
2091:
2092: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2093: THEN
2094: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2095: END IF;
2096:
2097: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2098: p_data => x_msg_data

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

2093: THEN
2094: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2095: END IF;
2096:
2097: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2098: p_data => x_msg_data
2099: );
2100:
2101: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2177: fnd_msg_pub.initialize;

2173:
2174: -- Initialize message list if p_init_msg_list is set to TRUE.
2175: IF fnd_api.to_boolean (p_init_msg_list)
2176: THEN
2177: fnd_msg_pub.initialize;
2178: END IF;
2179:
2180: -- Initialize API return status to success
2181: x_return_status := fnd_api.g_ret_sts_success;

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

2324: COMMIT WORK;
2325: END IF;
2326:
2327: -- Standard call to get message count and if count is 1, get message info.
2328: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2329: p_data => x_msg_data);
2330:
2331: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2332: THEN

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

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

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

2356: WHEN fnd_api.g_exc_unexpected_error
2357: THEN
2358: ROLLBACK TO create_item_instance;
2359: x_return_status := fnd_api.g_ret_sts_unexp_error;
2360: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2361: p_data => x_msg_data
2362: );
2363:
2364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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

2373: THEN
2374: ROLLBACK TO create_item_instance;
2375: x_return_status := fnd_api.g_ret_sts_unexp_error;
2376:
2377: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2378: THEN
2379: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2380: END IF;
2381:

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

2375: x_return_status := fnd_api.g_ret_sts_unexp_error;
2376:
2377: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2378: THEN
2379: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2380: END IF;
2381:
2382: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2383: p_data => x_msg_data

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

2378: THEN
2379: fnd_msg_pub.add_exc_msg (g_file_name, g_pkg_name, l_api_name);
2380: END IF;
2381:
2382: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2383: p_data => x_msg_data
2384: );
2385:
2386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2595: fnd_msg_pub.ADD;

2591: EXCEPTION
2592: WHEN OTHERS
2593: THEN
2594: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2595: fnd_msg_pub.ADD;
2596: RAISE fnd_api.g_exc_error;
2597: END;
2598: END IF;
2599:

Line 2652: fnd_msg_pub.ADD;

2648: WHEN NO_DATA_FOUND
2649: THEN
2650: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2651: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_error;
2654: END is_item_pre_serialized;
2655:
2656: ------------------------------------------------------------------------------

Line 2680: fnd_msg_pub.ADD;

2676: WHEN NO_DATA_FOUND
2677: THEN
2678: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2679: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2680: fnd_msg_pub.ADD;
2681: RAISE fnd_api.g_exc_error;
2682: END is_item_ib_trackable;
2683:
2684: ----------------------------------------------------------------------

Line 2752: fnd_msg_pub.ADD;

2748: /*
2749: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2750: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2751: */
2752: fnd_msg_pub.ADD;
2753:
2754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2755: THEN
2756: fnd_log.STRING (fnd_log.level_statement,

Line 2790: fnd_msg_pub.ADD;

2786: IF (cur_ord_line%NOTFOUND)
2787: THEN
2788: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2789: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2790: fnd_msg_pub.ADD;
2791:
2792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2793: THEN
2794: fnd_log.STRING (fnd_log.level_statement,

Line 2823: fnd_msg_pub.ADD;

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

Line 2841: fnd_msg_pub.ADD;

2837: IF l_unit_selling_price IS NULL
2838: THEN
2839: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2840: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2841: fnd_msg_pub.ADD;
2842:
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2844: THEN
2845: fnd_log.STRING (fnd_log.level_statement,

Line 2866: fnd_msg_pub.ADD;

2862: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2863: fnd_message.set_token ('ORDER_HEADER_ID',
2864: p_order_rec.order_header_id
2865: );
2866: fnd_msg_pub.ADD;
2867:
2868: CLOSE cur_ord_hdr;
2869:
2870: RAISE fnd_api.g_exc_error;

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

2888: l_count NUMBER;
2889: l_msg VARCHAR2 (2000);
2890: l_index_out NUMBER;
2891: BEGIN
2892: l_count := fnd_msg_pub.count_msg ();
2893:
2894: IF (l_count > 0)
2895: THEN
2896: FOR i IN 1 .. l_count

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

2894: IF (l_count > 0)
2895: THEN
2896: FOR i IN 1 .. l_count
2897: LOOP
2898: fnd_msg_pub.get (p_msg_index => i,
2899: p_encoded => 'F',
2900: p_data => l_msg,
2901: p_msg_index_out => l_index_out
2902: );