DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on FND_MSG_PUB

Line 100: fnd_msg_pub.add;

96: WHEN no_data_found THEN
97: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
98: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
99: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
100: fnd_msg_pub.add;
101: RAISE fnd_api.g_exc_error;
102: END;
103: x_sub_type_rec := l_sub_type_rec;
104: EXCEPTION

Line 1536: FND_MSG_PUB.add;

1532: EXCEPTION
1533: WHEN no_data_found THEN
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1536: FND_MSG_PUB.add;
1537: WHEN too_many_rows THEN
1538: x_return_status := fnd_api.g_ret_sts_error;
1539: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1540: FND_MSG_PUB.add;

Line 1540: FND_MSG_PUB.add;

1536: FND_MSG_PUB.add;
1537: WHEN too_many_rows THEN
1538: x_return_status := fnd_api.g_ret_sts_error;
1539: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1540: FND_MSG_PUB.add;
1541: END get_txn_sub_type_id;
1542:
1543: /* This routine splits the transaction details in to quantity one each */
1544: PROCEDURE split_txn_dtls(

Line 2313: fnd_msg_pub.add;

2309: END IF;
2310:
2311: IF nvl(l_end_customer_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2312: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2313: fnd_msg_pub.add;
2314: RAISE fnd_api.g_exc_error;
2315: END IF;
2316:
2317: END IF;

Line 2342: fnd_msg_pub.add;

2338: l_current_site_use_id := p_order_line_rec.invoice_to_org_id;
2339: END IF;
2340: IF nvl(l_current_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2341: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2342: fnd_msg_pub.add;
2343: RAISE fnd_api.g_exc_error;
2344: END IF;
2345:
2346: END IF;

Line 2372: fnd_msg_pub.add;

2368: l_install_site_use_id := p_order_line_rec.invoice_to_org_id;
2369: END IF;
2370: IF nvl(l_install_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2371: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2372: fnd_msg_pub.add;
2373: RAISE fnd_api.g_exc_error;
2374: END IF;
2375:
2376: END IF;

Line 2702: fnd_msg_pub.add;

2698: WHEN no_data_found THEN
2699: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2700: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2701: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2702: fnd_msg_pub.add;
2703: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2704: x_return_status := fnd_api.g_ret_sts_error;
2705: raise fnd_api.g_exc_error;
2706: ELSE

Line 2713: fnd_msg_pub.add;

2709: WHEN too_many_rows THEN
2710: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2711: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2712: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2713: fnd_msg_pub.add;
2714: x_return_status := fnd_api.g_ret_sts_error;
2715: raise fnd_api.g_exc_error;
2716: END;
2717: ELSE

Line 2961: fnd_msg_pub.add;

2957:
2958: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
2959: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
2960: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
2961: fnd_msg_pub.add;
2962:
2963: RAISE fnd_api.g_exc_error;
2964: END IF;
2965:

Line 6584: fnd_msg_pub.add;

6580: x_return_status := fnd_api.g_ret_sts_error;
6581: WHEN others then
6582: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
6583: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
6584: fnd_msg_pub.add;
6585: x_return_status := fnd_api.g_ret_sts_error;
6586: END process_ato_option_nsrl;
6587:
6588: PROCEDURE mark_and_get_class_instance(

Line 7079: fnd_msg_pub.add;

7075: x_return_status := fnd_api.g_ret_sts_error;
7076: WHEN others then
7077: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7078: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7079: fnd_msg_pub.add;
7080: x_return_status := fnd_api.g_ret_sts_error;
7081: END process_ato_option_srl;
7082:
7083: -- for ato options that are processed from wip

Line 7445: fnd_msg_pub.add;

7441: -- as the inv_organization_id on it for Fulfillments.
7442: l_vld_orgn_id := l_instance_rec.vld_organization_id;
7443: ELSE
7444: fnd_message.set_name('CSI','CSI_INVALID_VLD_MAST_COMB');
7445: fnd_msg_pub.add;
7446: RAISE fnd_api.g_exc_error;
7447: END IF;
7448: END IF;
7449:

Line 7490: fnd_msg_pub.add;

7486: || 'provided on transaction line detail: '
7487: || l_line_dtl_tbl(1).txn_line_detail_id);
7488: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
7489: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7490: fnd_msg_pub.add;
7491: RAISE fnd_api.g_exc_error;
7492: ELSIF l_inst_loc_type
7493: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
7494: THEN

Line 7499: fnd_msg_pub.add;

7495: debug('Location type code is :'||l_inst_loc_type);
7496: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
7497: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
7498: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
7499: fnd_msg_pub.add;
7500: RAISE fnd_api.g_exc_error;
7501: -- allow only externally located
7502: END IF;
7503: END IF;

Line 7512: fnd_msg_pub.add;

7508: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
7509: debug('Owner Change.');
7510: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
7511: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
7512: fnd_msg_pub.add;
7513: RAISE fnd_api.g_exc_error;
7514: ELSIF l_td_owner_id <> l_inst_owner_id THEN
7515: IF l_ownership_override = 'Y' THEN
7516: debug('Ownership Change and is allowed.');

Line 7523: fnd_msg_pub.add;

7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7523: fnd_msg_pub.add;
7524: RAISE fnd_api.g_exc_error;
7525: END IF;
7526: END IF;
7527: ELSE -- no owner entered in TD

Line 7544: fnd_msg_pub.add;

7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7544: fnd_msg_pub.add;
7545: RAISE fnd_api.g_exc_error;
7546: END IF;
7547: END IF;
7548: END IF;

Line 7558: fnd_msg_pub.add;

7554: -- check if the quantity is greater than the instance quantity
7555: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
7556: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
7557: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7558: fnd_msg_pub.add;
7559: RAISE fnd_api.g_exc_error;
7560: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN
7561: -- split the instance and process....
7562: l_quantity1 := l_instance_rec.quantity - l_line_dtl_tbl(1).quantity ;

Line 7887: fnd_msg_pub.add;

7883: debug(x_return_message);
7884: WHEN others THEN
7885: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
7886: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
7887: fnd_msg_pub.add;
7888: x_return_status := fnd_api.g_ret_sts_error;
7889: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
7890: rollback to cz_fulfillment;
7891: debug(x_return_message);

Line 7999: fnd_msg_pub.add;

7995: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
7996: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
7997: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
7998: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
7999: fnd_msg_pub.add;
8000: END IF;
8001: END IF;
8002:
8003: -- assign default current and default install location

Line 8289: fnd_msg_pub.initialize;

8285: debug(' Order Line ID : '||p_order_line_id);
8286:
8287: l_error_rec.source_id := p_order_line_id;
8288:
8289: fnd_msg_pub.initialize;
8290:
8291: /* this routine checks if ib is active */
8292: csi_utility_grp.check_ib_active;
8293:

Line 8344: fnd_msg_pub.add;

8340: EXCEPTION
8341: WHEN no_data_found THEN
8342: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
8343: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
8344: fnd_msg_pub.add;
8345: RAISE fnd_api.g_exc_error;
8346: END;
8347:
8348: IF l_order_line_rec.org_id is null THEN

Line 8415: fnd_msg_pub.add;

8411: ELSE
8412: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
8413: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
8414: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
8415: fnd_msg_pub.add;
8416: RAISE fnd_api.g_exc_error;
8417: END IF;
8418: END IF;
8419:

Line 8446: fnd_msg_pub.add;

8442: WHEN no_data_found THEN
8443: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8444: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
8445: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8446: fnd_msg_pub.add;
8447: RAISE fnd_api.g_exc_error;
8448: END;
8449: END IF;
8450:

Line 8465: fnd_msg_pub.add;

8461: WHEN no_data_found THEN
8462: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8463: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
8464: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8465: fnd_msg_pub.add;
8466: RAISE fnd_api.g_exc_error;
8467: END;
8468: END IF;
8469:

Line 9112: fnd_msg_pub.add;

9108: debug('This transaction detail is already PROCESSED.');
9109: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
9110: fnd_message.set_token('SRC_TBL', l_src_txn_table);
9111: fnd_message.set_token('SRC_ID', p_order_line_id);
9112: fnd_msg_pub.add;
9113: RAISE fnd_api.g_exc_error;
9114: END IF;
9115:
9116: UPDATE csi_t_transaction_lines

Line 9418: fnd_msg_pub.add;

9414: WHEN others THEN
9415: rollback to order_fulfillment;
9416: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9417: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
9418: fnd_msg_pub.add;
9419:
9420: x_return_status := fnd_api.g_ret_sts_error;
9421: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
9422: l_error_rec.error_text := l_error_message;

Line 9584: fnd_msg_pub.add;

9580: WHEN others THEN
9581:
9582: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9583: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
9584: fnd_msg_pub.add;
9585: raise fnd_api.g_exc_error;
9586: END;
9587: END ;
9588: IF l_continue THEN

Line 9609: fnd_msg_pub.add;

9605: EXCEPTION
9606: WHEN no_data_found THEN
9607: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9608: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9609: fnd_msg_pub.add;
9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN
9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9613: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);

Line 9614: fnd_msg_pub.add;

9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN
9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9613: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9614: fnd_msg_pub.add;
9615: raise fnd_api.g_exc_error;
9616: END;
9617:
9618: IF x_order_shipment_tbl(i).ib_install_loc is not null

Line 9635: fnd_msg_pub.add;

9631: EXCEPTION
9632: WHEN no_data_found THEN
9633: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9634: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9635: fnd_msg_pub.add;
9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN
9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9639: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);

Line 9640: fnd_msg_pub.add;

9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN
9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9639: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9640: fnd_msg_pub.add;
9641: raise fnd_api.g_exc_error;
9642: END;
9643: END IF;
9644:

Line 10104: fnd_msg_pub.add;

10100: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
10101: THEN
10102: IF l_partner_rec.END_CUSTOMER_ID is null Then
10103: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10104: fnd_msg_pub.add;
10105: raise fnd_api.g_exc_error;
10106: ELSE
10107: mmt_rec.ib_owner := l_partner_rec.ib_owner;
10108: mmt_rec.end_customer_id := l_partner_rec.end_customer_id;

Line 10126: fnd_msg_pub.add;

10122: THEN
10123: IF l_partner_rec.end_customer_site_use_id is null
10124: THEN
10125: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10126: fnd_msg_pub.add;
10127: raise fnd_api.g_exc_error;
10128: ELSE
10129: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;
10130: END IF;

Line 10136: fnd_msg_pub.add;

10132: THEN
10133: IF mmt_rec.ship_to_org_id is null
10134: THEN
10135: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10136: fnd_msg_pub.add;
10137: raise fnd_api.g_exc_error;
10138: ELSE
10139: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;
10140: END IF;

Line 10146: fnd_msg_pub.add;

10142: THEN
10143: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
10144: THEN
10145: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10146: fnd_msg_pub.add;
10147: raise fnd_api.g_exc_error;
10148: ELSE
10149: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
10150: END IF;

Line 10156: fnd_msg_pub.add;

10152: THEN
10153: IF mmt_rec.deliver_to_org_id is null
10154: THEN
10155: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10156: fnd_msg_pub.add;
10157: raise fnd_api.g_exc_error;
10158: ELSE
10159: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;
10160: END IF;

Line 10166: fnd_msg_pub.add;

10162: THEN
10163: IF mmt_rec.invoice_to_org_id is null
10164: THEN
10165: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10166: fnd_msg_pub.add;
10167: raise fnd_api.g_exc_error;
10168: ELSE
10169: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;
10170: END IF;

Line 10187: fnd_msg_pub.add;

10183: THEN
10184: IF l_partner_rec.end_customer_site_use_id is null
10185: THEN
10186: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10187: fnd_msg_pub.add;
10188: raise fnd_api.g_exc_error;
10189: ELSE
10190: mmt_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;
10191: END IF;

Line 10197: fnd_msg_pub.add;

10193: THEN
10194: IF mmt_rec.ship_to_org_id is null
10195: THEN
10196: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10197: fnd_msg_pub.add;
10198: raise fnd_api.g_exc_error;
10199: ELSE
10200: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;
10201: END IF;

Line 10207: fnd_msg_pub.add;

10203: THEN
10204: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
10205: THEN
10206: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10207: fnd_msg_pub.add;
10208: raise fnd_api.g_exc_error;
10209: ELSE
10210: mmt_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;
10211: END IF;

Line 10217: fnd_msg_pub.add;

10213: THEN
10214: IF mmt_rec.deliver_to_org_id is null
10215: THEN
10216: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10217: fnd_msg_pub.add;
10218: raise fnd_api.g_exc_error;
10219: ELSE
10220: mmt_rec.ib_current_loc_id := mmt_rec.deliver_to_org_id;
10221: END IF;

Line 10227: fnd_msg_pub.add;

10223: THEN
10224: IF mmt_rec.invoice_to_org_id is null
10225: THEN
10226: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10227: fnd_msg_pub.add;
10228: raise fnd_api.g_exc_error;
10229: ELSE
10230: mmt_rec.ib_current_loc_id := mmt_rec.invoice_to_org_id;
10231: END IF;

Line 10469: fnd_msg_pub.add;

10465:
10466: WHEN others THEN
10467: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10468: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10469: fnd_msg_pub.add;
10470:
10471: x_return_status := fnd_api.g_ret_sts_error;
10472: l_error_rec.source_id := p_mtl_txn_id; -- For 4168922
10473: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

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

10802: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
10803: l_msg_index := 1;
10804: WHILE l_msg_count > 0
10805: LOOP
10806: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);
10807: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
10808: l_msg_index := l_msg_index + 1;
10809: l_msg_count := l_msg_count - 1;
10810: END LOOP;

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

10983: p_action_request_tbl => l_action_request_tbl);
10984: END;
10985: COMMIT;
10986: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
10987: FND_MSG_PUB.initialize; -- reinit the error messages
10988: END LOOP;
10989: -- End of Processing Regular Queue
10990: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
10991: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');

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

11039: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11040: l_msg_index := 1;
11041: WHILE l_msg_count > 0
11042: LOOP
11043: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
11044: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
11045: l_msg_index := l_msg_index + 1;
11046: l_msg_count := l_msg_count - 1;
11047: END LOOP;

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

11216: p_action_request_tbl => l_action_request_tbl);
11217: END;
11218: COMMIT;
11219: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
11220: FND_MSG_PUB.initialize; -- reinit the error messages
11221: END LOOP;
11222: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
11223: END Process_old_order_Lines;
11224: