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.CSI_ORDER_FULFILL_PUB dependencies on FND_MSG_PUB

Line 123: fnd_msg_pub.add;

119: WHEN no_data_found THEN
120: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
121: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
122: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
123: fnd_msg_pub.add;
124: RAISE fnd_api.g_exc_error;
125: END;
126: x_sub_type_rec := l_sub_type_rec;
127: EXCEPTION

Line 1576: FND_MSG_PUB.add;

1572: EXCEPTION
1573: WHEN no_data_found THEN
1574: x_return_status := fnd_api.g_ret_sts_error;
1575: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1576: FND_MSG_PUB.add;
1577: WHEN too_many_rows THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1580: FND_MSG_PUB.add;

Line 1580: FND_MSG_PUB.add;

1576: FND_MSG_PUB.add;
1577: WHEN too_many_rows THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1580: FND_MSG_PUB.add;
1581: END get_txn_sub_type_id;
1582:
1583: /* This routine splits the transaction details in to quantity one each */
1584: PROCEDURE split_txn_dtls(

Line 2353: fnd_msg_pub.add;

2349: END IF;
2350:
2351: IF nvl(l_end_customer_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2352: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2353: fnd_msg_pub.add;
2354: RAISE fnd_api.g_exc_error;
2355: END IF;
2356:
2357: END IF;

Line 2382: fnd_msg_pub.add;

2378: l_current_site_use_id := p_order_line_rec.invoice_to_org_id;
2379: END IF;
2380: IF nvl(l_current_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2381: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2382: fnd_msg_pub.add;
2383: RAISE fnd_api.g_exc_error;
2384: END IF;
2385:
2386: END IF;

Line 2412: fnd_msg_pub.add;

2408: l_install_site_use_id := p_order_line_rec.invoice_to_org_id;
2409: END IF;
2410: IF nvl(l_install_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2411: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2412: fnd_msg_pub.add;
2413: RAISE fnd_api.g_exc_error;
2414: END IF;
2415:
2416: END IF;

Line 2742: fnd_msg_pub.add;

2738: WHEN no_data_found THEN
2739: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2740: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2741: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2742: fnd_msg_pub.add;
2743: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2744: x_return_status := fnd_api.g_ret_sts_error;
2745: raise fnd_api.g_exc_error;
2746: ELSE

Line 2753: fnd_msg_pub.add;

2749: WHEN too_many_rows THEN
2750: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2751: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2752: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2753: fnd_msg_pub.add;
2754: x_return_status := fnd_api.g_ret_sts_error;
2755: raise fnd_api.g_exc_error;
2756: END;
2757: ELSE

Line 3007: fnd_msg_pub.add;

3003:
3004: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
3005: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
3006: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3007: fnd_msg_pub.add;
3008:
3009: RAISE fnd_api.g_exc_error;
3010: END IF;
3011:

Line 5249: FND_MSG_PUB.Add;

5245: ELSIF l_Error_Code > 0 THEN
5246: debug (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
5247: END IF;
5248: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
5249: FND_MSG_PUB.Add;
5250: x_return_status := fnd_api.g_ret_sts_error;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF; -- error
5253:

Line 5386: --FND_MSG_PUB.Add;

5382: ELSIF l_Error_Code > 0 THEN
5383: debug (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
5384: END IF;
5385: --FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
5386: --FND_MSG_PUB.Add;
5387: --x_return_status := fnd_api.g_ret_sts_error;
5388: RAISE FND_API.G_EXC_ERROR;
5389: END IF;
5390:

Line 7354: fnd_msg_pub.add;

7350: x_return_status := fnd_api.g_ret_sts_error;
7351: WHEN others then
7352: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7353: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7354: fnd_msg_pub.add;
7355: x_return_status := fnd_api.g_ret_sts_error;
7356: END process_ato_option_nsrl;
7357:
7358: PROCEDURE mark_and_get_class_instance(

Line 7870: fnd_msg_pub.add;

7866: x_return_status := fnd_api.g_ret_sts_error;
7867: WHEN others then
7868: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7869: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7870: fnd_msg_pub.add;
7871: x_return_status := fnd_api.g_ret_sts_error;
7872: END process_ato_option_srl;
7873:
7874: -- for ato options that are processed from wip

Line 8242: fnd_msg_pub.add;

8238: -- as the inv_organization_id on it for Fulfillments.
8239: l_vld_orgn_id := l_instance_rec.vld_organization_id;
8240: ELSE
8241: fnd_message.set_name('CSI','CSI_INVALID_VLD_MAST_COMB');
8242: fnd_msg_pub.add;
8243: RAISE fnd_api.g_exc_error;
8244: END IF;
8245: END IF;
8246:

Line 8287: fnd_msg_pub.add;

8283: || 'provided on transaction line detail: '
8284: || l_line_dtl_tbl(1).txn_line_detail_id);
8285: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
8286: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8287: fnd_msg_pub.add;
8288: RAISE fnd_api.g_exc_error;
8289: ELSIF l_inst_loc_type
8290: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
8291: THEN

Line 8296: fnd_msg_pub.add;

8292: debug('Location type code is :'||l_inst_loc_type);
8293: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
8294: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
8295: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
8296: fnd_msg_pub.add;
8297: RAISE fnd_api.g_exc_error;
8298: -- allow only externally located
8299: END IF;
8300: END IF;

Line 8309: fnd_msg_pub.add;

8305: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
8306: debug('Owner Change.');
8307: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
8308: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
8309: fnd_msg_pub.add;
8310: RAISE fnd_api.g_exc_error;
8311: ELSIF l_td_owner_id <> l_inst_owner_id THEN
8312: IF l_ownership_override = 'Y' THEN
8313: debug('Ownership Change and is allowed.');

Line 8320: fnd_msg_pub.add;

8316: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8317: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8318: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8319: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8320: fnd_msg_pub.add;
8321: RAISE fnd_api.g_exc_error;
8322: END IF;
8323: END IF;
8324: ELSE -- no owner entered in TD

Line 8341: fnd_msg_pub.add;

8337: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8338: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8339: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8340: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8341: fnd_msg_pub.add;
8342: RAISE fnd_api.g_exc_error;
8343: END IF;
8344: END IF;
8345: END IF;

Line 8355: fnd_msg_pub.add;

8351: -- check if the quantity is greater than the instance quantity
8352: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
8353: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
8354: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8355: fnd_msg_pub.add;
8356: RAISE fnd_api.g_exc_error;
8357: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN
8358: -- split the instance and process....
8359: l_quantity1 := l_instance_rec.quantity - l_line_dtl_tbl(1).quantity ;

Line 8684: fnd_msg_pub.add;

8680: debug(x_return_message);
8681: WHEN others THEN
8682: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8683: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
8684: fnd_msg_pub.add;
8685: x_return_status := fnd_api.g_ret_sts_error;
8686: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
8687: rollback to cz_fulfillment;
8688: debug(x_return_message);

Line 8799: fnd_msg_pub.add;

8795: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
8796: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
8797: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
8798: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
8799: fnd_msg_pub.add;
8800: END IF;
8801: END IF;
8802:
8803: -- assign default current and default install location

Line 8832: fnd_msg_pub.add;

8828: EXCEPTION
8829: WHEN no_data_found then
8830: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8831: fnd_message.set_token('LOCATION_ID', px_default_info_rec.current_party_site_id);
8832: fnd_msg_pub.add;
8833: raise fnd_api.g_exc_error;
8834: WHEN too_many_rows then
8835: debug('Many Party sites found');
8836: raise fnd_api.g_exc_error;

Line 8867: fnd_msg_pub.add;

8863: EXCEPTION
8864: WHEN no_data_found then
8865: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8866: fnd_message.set_token('LOCATION_ID', px_default_info_rec.install_party_site_id);
8867: fnd_msg_pub.add;
8868: raise fnd_api.g_exc_error;
8869: WHEN too_many_rows then
8870: debug('Many Party sites found');
8871: raise fnd_api.g_exc_error;

Line 9210: fnd_msg_pub.initialize;

9206: get_phantom_option_expl_flag
9207: (p_option_expl_flag => l_option_flag);
9208:
9209:
9210: fnd_msg_pub.initialize;
9211:
9212: /* this routine checks if ib is active */
9213: csi_utility_grp.check_ib_active;
9214:

Line 9265: fnd_msg_pub.add;

9261: EXCEPTION
9262: WHEN no_data_found THEN
9263: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
9264: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
9265: fnd_msg_pub.add;
9266: RAISE fnd_api.g_exc_error;
9267: END;
9268:
9269: IF l_order_line_rec.org_id is null THEN

Line 9336: fnd_msg_pub.add;

9332: ELSE
9333: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
9334: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
9335: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
9336: fnd_msg_pub.add;
9337: RAISE fnd_api.g_exc_error;
9338: END IF;
9339: END IF;
9340:

Line 9367: fnd_msg_pub.add;

9363: WHEN no_data_found THEN
9364: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9365: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
9366: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9367: fnd_msg_pub.add;
9368: RAISE fnd_api.g_exc_error;
9369: END;
9370: END IF;
9371:

Line 9386: fnd_msg_pub.add;

9382: WHEN no_data_found THEN
9383: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9384: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
9385: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9386: fnd_msg_pub.add;
9387: RAISE fnd_api.g_exc_error;
9388: END;
9389: END IF;
9390:

Line 9497: fnd_msg_pub.add;

9493: -- in csi_txn_error or ship confirm didnt happen. In both cases
9494: -- block fulfilment processing
9495: debug('Shipment Line Not Interfaced to IB. Blocking Fulfillment till Shipment successfully completes');
9496: fnd_message.set_name('CSI','CSI_PENDING_SHIPMENT_LINES');
9497: fnd_msg_pub.add;
9498: RAISE fnd_api.g_exc_error;
9499: ELSE
9500: -- Shipment line interfaced so proceed with fulfilment line processing
9501: debug('Shipment Lines, if any, are successfully processed. Proceed with Fulfillment processing');

Line 10122: fnd_msg_pub.add;

10118: debug('This transaction detail is already PROCESSED.');
10119: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
10120: fnd_message.set_token('SRC_TBL', l_src_txn_table);
10121: fnd_message.set_token('SRC_ID', p_order_line_id);
10122: fnd_msg_pub.add;
10123: RAISE fnd_api.g_exc_error;
10124: END IF;
10125:
10126: UPDATE csi_t_transaction_lines

Line 10434: fnd_msg_pub.add;

10430: WHEN others THEN
10431: rollback to order_fulfillment;
10432: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10433: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10434: fnd_msg_pub.add;
10435:
10436: x_return_status := fnd_api.g_ret_sts_error;
10437: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
10438: l_error_rec.error_text := l_error_message;

Line 10600: fnd_msg_pub.add;

10596: WHEN others THEN
10597:
10598: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10599: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
10600: fnd_msg_pub.add;
10601: raise fnd_api.g_exc_error;
10602: END;
10603: END ;
10604: IF l_continue THEN

Line 10625: fnd_msg_pub.add;

10621: EXCEPTION
10622: WHEN no_data_found THEN
10623: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10624: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10625: fnd_msg_pub.add;
10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN
10628: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10629: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);

Line 10630: fnd_msg_pub.add;

10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN
10628: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10629: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10630: fnd_msg_pub.add;
10631: raise fnd_api.g_exc_error;
10632: END;
10633:
10634: IF x_order_shipment_tbl(i).ib_install_loc is not null

Line 10651: fnd_msg_pub.add;

10647: EXCEPTION
10648: WHEN no_data_found THEN
10649: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10650: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10651: fnd_msg_pub.add;
10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN
10654: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10655: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);

Line 10656: fnd_msg_pub.add;

10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN
10654: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10655: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10656: fnd_msg_pub.add;
10657: raise fnd_api.g_exc_error;
10658: END;
10659: END IF;
10660:

Line 11120: fnd_msg_pub.add;

11116: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
11117: THEN
11118: IF l_partner_rec.END_CUSTOMER_ID is null Then
11119: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11120: fnd_msg_pub.add;
11121: raise fnd_api.g_exc_error;
11122: ELSE
11123: mmt_rec.ib_owner := l_partner_rec.ib_owner;
11124: mmt_rec.end_customer_id := l_partner_rec.end_customer_id;

Line 11142: fnd_msg_pub.add;

11138: THEN
11139: IF l_partner_rec.end_customer_site_use_id is null
11140: THEN
11141: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11142: fnd_msg_pub.add;
11143: raise fnd_api.g_exc_error;
11144: ELSE
11145: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;
11146: END IF;

Line 11152: fnd_msg_pub.add;

11148: THEN
11149: IF mmt_rec.ship_to_org_id is null
11150: THEN
11151: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11152: fnd_msg_pub.add;
11153: raise fnd_api.g_exc_error;
11154: ELSE
11155: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;
11156: END IF;

Line 11162: fnd_msg_pub.add;

11158: THEN
11159: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
11160: THEN
11161: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11162: fnd_msg_pub.add;
11163: raise fnd_api.g_exc_error;
11164: ELSE
11165: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
11166: END IF;

Line 11172: fnd_msg_pub.add;

11168: THEN
11169: IF mmt_rec.deliver_to_org_id is null
11170: THEN
11171: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11172: fnd_msg_pub.add;
11173: raise fnd_api.g_exc_error;
11174: ELSE
11175: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;
11176: END IF;

Line 11182: fnd_msg_pub.add;

11178: THEN
11179: IF mmt_rec.invoice_to_org_id is null
11180: THEN
11181: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11182: fnd_msg_pub.add;
11183: raise fnd_api.g_exc_error;
11184: ELSE
11185: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;
11186: END IF;

Line 11203: fnd_msg_pub.add;

11199: THEN
11200: IF l_partner_rec.end_customer_site_use_id is null
11201: THEN
11202: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11203: fnd_msg_pub.add;
11204: raise fnd_api.g_exc_error;
11205: ELSE
11206: mmt_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;
11207: END IF;

Line 11213: fnd_msg_pub.add;

11209: THEN
11210: IF mmt_rec.ship_to_org_id is null
11211: THEN
11212: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11213: fnd_msg_pub.add;
11214: raise fnd_api.g_exc_error;
11215: ELSE
11216: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
11217: END IF;

Line 11223: fnd_msg_pub.add;

11219: THEN
11220: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
11221: THEN
11222: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11223: fnd_msg_pub.add;
11224: raise fnd_api.g_exc_error;
11225: ELSE
11226: mmt_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
11227: END IF;

Line 11233: fnd_msg_pub.add;

11229: THEN
11230: IF mmt_rec.deliver_to_org_id is null
11231: THEN
11232: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11233: fnd_msg_pub.add;
11234: raise fnd_api.g_exc_error;
11235: ELSE
11236: mmt_rec.ib_current_loc_id := mmt_rec.deliver_to_org_id;
11237: END IF;

Line 11243: fnd_msg_pub.add;

11239: THEN
11240: IF mmt_rec.invoice_to_org_id is null
11241: THEN
11242: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11243: fnd_msg_pub.add;
11244: raise fnd_api.g_exc_error;
11245: ELSE
11246: mmt_rec.ib_current_loc_id := mmt_rec.invoice_to_org_id;
11247: END IF;

Line 11485: fnd_msg_pub.add;

11481:
11482: WHEN others THEN
11483: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
11484: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
11485: fnd_msg_pub.add;
11486:
11487: x_return_status := fnd_api.g_ret_sts_error;
11488: l_error_rec.source_id := p_mtl_txn_id; -- For 4168922
11489: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 11822: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);

11818: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11819: l_msg_index := 1;
11820: WHILE l_msg_count > 0
11821: LOOP
11822: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);
11823: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
11824: l_msg_index := l_msg_index + 1;
11825: l_msg_count := l_msg_count - 1;
11826: END LOOP;

Line 12003: FND_MSG_PUB.initialize; -- reinit the error messages

11999: p_action_request_tbl => l_action_request_tbl);
12000: END;
12001: COMMIT;
12002: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
12003: FND_MSG_PUB.initialize; -- reinit the error messages
12004: END LOOP;
12005: -- End of Processing Regular Queue
12006: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
12007: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');

Line 12059: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

12055: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
12056: l_msg_index := 1;
12057: WHILE l_msg_count > 0
12058: LOOP
12059: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
12060: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
12061: l_msg_index := l_msg_index + 1;
12062: l_msg_count := l_msg_count - 1;
12063: END LOOP;

Line 12236: FND_MSG_PUB.initialize; -- reinit the error messages

12232: p_action_request_tbl => l_action_request_tbl);
12233: END;
12234: COMMIT;
12235: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
12236: FND_MSG_PUB.initialize; -- reinit the error messages
12237: END LOOP;
12238: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
12239: END Process_old_order_Lines;
12240: