DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on FND_MSG_PUB

Line 223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

219: WHEN FND_API.G_EXC_ERROR THEN
220: --
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: --
223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
224: , p_data => x_msg_data);
225: --
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --

Line 230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: --
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: --
230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
231: , p_data => x_msg_data);
232: --
233: WHEN OTHERS THEN
234: ROLLBACK TO Pick_Release_PUB;

Line 238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

234: ROLLBACK TO Pick_Release_PUB;
235: --
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: --
238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
240: END IF;
241: --
242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 239: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

235: --
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: --
238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
240: END IF;
241: --
242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
243: , p_data => x_msg_data);

Line 242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
240: END IF;
241: --
242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
243: , p_data => x_msg_data);
244: END;
245:
246:

Line 414: FND_MSG_PUB.Add;

410: WHEN no_data_found THEN
411: ROLLBACK TO Assign_Pick_slip;
412: FND_MESSAGE.SET_NAME('INV','INV_NO_HEADER_FOUND');
413: FND_MESSAGE.SET_TOKEN('MO_LINE_ID','');
414: FND_MSG_PUB.Add;
415: RAISE fnd_api.g_exc_unexpected_error;
416: END;
417:
418: -- If the header did not have a grouping rule ID, retrieve it from

Line 430: FND_MSG_PUB.Add;

426: EXCEPTION
427: WHEN no_data_found THEN
428: ROLLBACK TO Assign_pick_slip;
429: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
430: FND_MSG_PUB.Add;
431: RAISE fnd_api.g_exc_unexpected_error;
432: END;
433: END IF; -- get header rule
434: END IF; -- return status

Line 502: fnd_msg_pub.ADD;

498: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
499: ROLLBACK TO assign_pick_slip;
500: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
501: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505: END IF;
506:

Line 543: fnd_msg_pub.ADD;

539: IF l_api_return_status <> fnd_api.g_ret_sts_success
540: OR l_pick_slip_number = -1 THEN
541: ROLLBACK TO assign_pick_slip;
542: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
543: fnd_msg_pub.ADD;
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546:
547: IF ( p_ps_mode <> 'I' ) THEN

Line 615: fnd_msg_pub.ADD;

611: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
612: ROLLBACK TO process_line_pvt;
613: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
614: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
615: fnd_msg_pub.ADD;
616: RAISE fnd_api.g_exc_unexpected_error;
617: END IF;
618: END IF;
619: END IF;

Line 628: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

624: ROLLBACK TO Assign_pick_slip;
625: --
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: --
628: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
629: , p_data => x_msg_data);
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: ROLLBACK TO Assign_pick_slip;

Line 636: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

632: ROLLBACK TO Assign_pick_slip;
633: --
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: --
636: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
637: , p_data => x_msg_data);
638: --
639: WHEN OTHERS THEN
640: ROLLBACK TO Assign_pick_slip;

Line 644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

640: ROLLBACK TO Assign_pick_slip;
641: --
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: --
644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
646: END IF;
647: --
648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

641: --
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: --
644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
646: END IF;
647: --
648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
649: , p_data => x_msg_data);

Line 648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
646: END IF;
647: --
648: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
649: , p_data => x_msg_data);
650: END assign_pick_slip_number;
651:
652:

Line 993: fnd_msg_pub.initialize;

989: END IF;
990:
991: -- Initialize message list if p_init_msg_list is set to true
992: IF fnd_api.to_Boolean(p_init_msg_list) THEN
993: fnd_msg_pub.initialize;
994: END IF;
995:
996: -- Initialize API return status to success
997: x_return_status := fnd_api.g_ret_sts_success;

Line 1012: FND_MSG_PUB.Add;

1008: End If;
1009:
1010: ROLLBACK TO Pick_Release_PUB;
1011: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');
1012: FND_MSG_PUB.Add;
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015:
1016: -- Set move order transaction date if passed in as not NULL

Line 1054: FND_MSG_PUB.Add;

1050: End If;
1051:
1052: ROLLBACK TO Pick_Release_PUB;
1053: FND_MESSAGE.SET_NAME('INV','INV_PICK_DIFFERENT_ORG');
1054: FND_MSG_PUB.Add;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:
1058: -- Verify that the line status is approved or pre-approved

Line 1067: FND_MSG_PUB.Add;

1063: End If;
1064:
1065: ROLLBACK TO Pick_Release_PUB;
1066: FND_MESSAGE.SET_NAME('INV','INV_PICK_LINE_STATUS');
1067: FND_MSG_PUB.Add;
1068: RAISE fnd_api.g_exc_unexpected_error;
1069: END IF;
1070:
1071: IF l_mo_line.header_id <> l_current_header_id OR

Line 1095: FND_MSG_PUB.Add;

1091:
1092: ROLLBACK TO Pick_Release_PUB;
1093: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');
1094: FND_MESSAGE.SET_TOKEN('MO_NUMBER',l_mo_number);
1095: FND_MSG_PUB.Add;
1096: RAISE fnd_api.g_exc_unexpected_error;
1097: END IF;
1098: l_mol_id_tbl(l_mol_id_index) := l_mo_line.line_id;
1099: l_mol_id_index := l_mol_id_index + 1;

Line 1292: -- FND_MSG_PUB.Add;

1288: 'Inv_Pick_Release_PUB.Pick_release');
1289: End If;
1290: --ROLLBACK TO Pick_Release_PUB;
1291: --FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
1292: -- FND_MSG_PUB.Add;
1293: -- RAISE fnd_api.g_exc_unexpected_error;
1294: END;
1295:
1296: l_return_value := INV_CACHE.set_mso_rec(l_oe_header_id);

Line 1407: FND_MSG_PUB.Add;

1403: 'INV_Pick_Release_Pub.Pick_Release');
1404: End If;
1405: ROLLBACK TO Pick_Release_PUB;
1406: FND_MESSAGE.SET_NAME('INV','INV_AUTO_PICK_CONFIRM_PARAM');
1407: FND_MSG_PUB.Add;
1408: RAISE fnd_api.g_exc_unexpected_error;
1409: ELSE
1410: l_auto_pick_confirm := p_auto_pick_confirm;
1411: END IF;

Line 1446: FND_MSG_PUB.Add;

1442: 'INV_Pick_Release_Pub.Pick_Release');
1443: End If;
1444: ROLLBACK TO Pick_Release_PUB;
1445: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
1446: FND_MSG_PUB.Add;
1447: RAISE fnd_api.g_exc_unexpected_error;
1448: END;
1449:
1450: g_organization_id := l_organization_id;

Line 1464: FND_MSG_PUB.Add;

1460: 'INV_Pick_Release_Pub.Pick_Release');
1461: End If;
1462: ROLLBACK TO Pick_Release_PUB;
1463: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PARTIAL_PICK_PARAM');
1464: FND_MSG_PUB.Add;
1465: RAISE fnd_api.g_exc_unexpected_error;
1466: END IF;
1467:
1468: If is_debug then

Line 1598: FND_MSG_PUB.Add;

1594: 'INV_Pick_Release_Pub.Pick_Release');
1595: End If;
1596: ROLLBACK TO Pick_Release_PUB;
1597: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
1598: FND_MSG_PUB.Add;
1599: RAISE fnd_api.g_exc_unexpected_error;
1600: END;
1601:
1602: If g_organization_id IS NULL Or

Line 1768: FND_MSG_PUB.Add;

1764: IF p_allow_partial_pick = fnd_api.g_false THEN
1765: x_pick_release_status.delete;
1766: ROLLBACK TO Pick_Release_PUB;
1767: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_PICK_FULL');
1768: FND_MSG_PUB.Add;
1769: RAISE fnd_api.g_exc_unexpected_error;
1770: END IF;
1771: END IF;
1772:

Line 2119: FND_MSG_PUB.Add;

2115: 'Inv_Pick_Release_Pub.Pick_Release');
2116: End If;
2117: ROLLBACK TO Pick_Release_PUB;
2118: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2119: FND_MSG_PUB.Add;
2120: RAISE fnd_api.g_exc_unexpected_error;
2121: END;
2122:
2123: -- convert to primary UOM

Line 2240: FND_MSG_PUB.Add;

2236: 'Inv_Pick_Release_Pub.Pick_Release');
2237: End If;
2238: ROLLBACK TO Pick_Release_PUB;
2239: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2240: FND_MSG_PUB.Add;
2241: RAISE fnd_api.g_exc_unexpected_error;
2242: END;
2243:
2244: --convert to primary quantity

Line 3162: fnd_msg_pub.ADD;

3158: IF (l_debug = 1) THEN
3159: print_debug('failed to print labels', 'Inv_Pick_Release_Pub.Pick_Release');
3160: END IF;
3161: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3162: fnd_msg_pub.ADD;
3163: END IF;
3164: END IF;
3165: EXCEPTION
3166: WHEN OTHERS THEN

Line 3171: fnd_msg_pub.ADD;

3167: IF (l_debug = 1) THEN
3168: print_debug('Exception occured while calling print_label', 'Inv_Pick_Release_Pub.Pick_Release');
3169: END IF;
3170: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3171: fnd_msg_pub.ADD;
3172: END;
3173: END IF;
3174: --END Bug 6696594
3175:

Line 3326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3322: x_return_status := FND_API.G_RET_STS_ERROR;
3323: l_return_value := inv_cache.set_pick_release(FALSE); --Added bug3237702
3324: inv_log_util.g_maintain_log_profile := TRUE;
3325: --
3326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3327: , p_data => x_msg_data);
3328: --
3329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3330: --

Line 3335: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3332: l_return_value := inv_cache.set_pick_release(FALSE); --Added bug3237702
3333: inv_log_util.g_maintain_log_profile := TRUE;
3334: --
3335: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3336: , p_data => x_msg_data);
3337: --
3338: WHEN OTHERS THEN
3339: IF is_debug THEN

Line 3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3346: l_return_value := inv_cache.set_pick_release(FALSE); --Added bug3237702
3347: inv_log_util.g_maintain_log_profile := TRUE;
3348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3349: --
3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3352: END IF;
3353: --
3354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 3351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3347: inv_log_util.g_maintain_log_profile := TRUE;
3348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3349: --
3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3352: END IF;
3353: --
3354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3355: , p_data => x_msg_data);

Line 3354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3351: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3352: END IF;
3353: --
3354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3355: , p_data => x_msg_data);
3356: END Pick_Release;
3357:
3358:

Line 3479: fnd_msg_pub.initialize;

3475: END IF;
3476:
3477: -- Initialize message list if p_init_msg_list is set to true
3478: IF fnd_api.to_Boolean(p_init_msg_list) THEN
3479: fnd_msg_pub.initialize;
3480: END IF;
3481:
3482: -- Initialize API return status to success
3483: x_return_status := fnd_api.g_ret_sts_success;

Line 3490: FND_MSG_PUB.Add;

3486:
3487: -- First make sure that missing quantity is not <= 0
3488: IF p_missing_quantity <= 0 THEN
3489: FND_MESSAGE.SET_NAME('INV','INV_NO_QTY_TO_TRANSFER');
3490: FND_MSG_PUB.Add;
3491: RAISE fnd_api.g_exc_unexpected_error;
3492: END IF;
3493:
3494: -- Determine whether the reservation id was given, or if it must be derived

Line 3514: FND_MSG_PUB.Add;

3510: p_demand_source_header_id IS NULL OR
3511: p_demand_source_line_id = fnd_api.g_miss_num OR
3512: p_demand_source_line_id IS NULL THEN
3513: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_ID_RSV');
3514: FND_MSG_PUB.Add;
3515: RAISE fnd_api.g_exc_unexpected_error;
3516: END IF;
3517:
3518: -- First attempt to convert the demand source header id given

Line 3524: FND_MSG_PUB.Add;

3520: /*l_mso_header_id :=
3521: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
3522: IF l_mso_header_id IS NULL THEN
3523: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
3524: FND_MSG_PUB.Add;
3525: RAISE fnd_api.g_exc_unexpected_error;
3526: END IF;*/
3527:
3528: l_reservation_rec.inventory_item_id := p_inventory_item_id;

Line 3578: FND_MSG_PUB.Add;

3574: );
3575: -- Return an error if the query reservations call failed
3576: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3577: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
3578: FND_MSG_PUB.Add;
3579: RAISE fnd_api.g_exc_unexpected_error;
3580: END IF;
3581:
3582: -- Only 1 reservation record should have been returned, since the parameters

Line 3586: FND_MSG_PUB.Add;

3582: -- Only 1 reservation record should have been returned, since the parameters
3583: -- passed are supposed to uniquely identify a reservation record.
3584: IF l_reservation_count = 0 THEN
3585: FND_MESSAGE.SET_NAME('INV','INV_NO_RSVS_FOUND');
3586: FND_MSG_PUB.Add;
3587: RAISE fnd_api.g_exc_unexpected_error;
3588: END IF;
3589:
3590: IF l_reservation_count > 1 THEN

Line 3592: FND_MSG_PUB.Add;

3588: END IF;
3589:
3590: IF l_reservation_count > 1 THEN
3591: FND_MESSAGE.SET_NAME('INV','INV_NON_UNIQUE_RSV');
3592: FND_MSG_PUB.Add;
3593: RAISE fnd_api.g_exc_unexpected_error;
3594: END IF;
3595:
3596: -- Determine whether the quantity to transfer is greater

Line 3600: FND_MSG_PUB.Add;

3596: -- Determine whether the quantity to transfer is greater
3597: -- than the currently reserved quantity
3598: IF p_missing_quantity > l_reservations_tbl(1).primary_reservation_quantity THEN
3599: FND_MESSAGE.SET_NAME('INV','INV_INSUFF_QTY_RSV');
3600: FND_MSG_PUB.Add;
3601: RAISE fnd_api.g_exc_unexpected_error;
3602: END IF;
3603:
3604: -- Initialize the querying record with the reservation ID so that the update

Line 3646: FND_MSG_PUB.Add;

3642: );
3643: -- Return an error if the transfer reservations call failed
3644: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3645: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
3646: FND_MSG_PUB.Add;
3647: RAISE fnd_api.g_exc_unexpected_error;
3648: END IF;
3649:
3650: -- Commit if necessary

Line 3665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3661: WHEN FND_API.G_EXC_ERROR THEN
3662: --
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: --
3665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3666: , p_data => x_msg_data);
3667: --
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: --

Line 3672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: --
3670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3671: --
3672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3673: , p_data => x_msg_data);
3674: --
3675: WHEN OTHERS THEN
3676: ROLLBACK TO Reserve_Unconfirmed_Qty_PUB;

Line 3680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3676: ROLLBACK TO Reserve_Unconfirmed_Qty_PUB;
3677: --
3678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: --
3680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3681: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3682: END IF;
3683: --
3684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 3681: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3677: --
3678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: --
3680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3681: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3682: END IF;
3683: --
3684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3685: , p_data => x_msg_data);

Line 3684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3681: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3682: END IF;
3683: --
3684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3685: , p_data => x_msg_data);
3686: END Reserve_Unconfirmed_Quantity;
3687:
3688:

Line 3746: FND_MSG_PUB.Add;

3742: 'INV_Pick_Release_Pub.Pick_Release');
3743: End If;
3744: --ROLLBACK TO Pick_Release_PUB;
3745: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
3746: FND_MSG_PUB.Add;
3747: RAISE fnd_api.g_exc_unexpected_error;
3748: END;
3749:
3750: g_organization_id := p_org_id;

Line 3819: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3815: WHEN FND_API.G_EXC_ERROR THEN
3816: --
3817: x_return_status := FND_API.G_RET_STS_ERROR;
3818: --
3819: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3820: , p_data => x_msg_data);
3821: --
3822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3823: --

Line 3826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3823: --
3824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3825: --
3826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3827: , p_data => x_msg_data);
3828: --
3829: WHEN OTHERS THEN
3830: ROLLBACK TO PR_Call_cartonization;

Line 3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3830: ROLLBACK TO PR_Call_cartonization;
3831: --
3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3833: --
3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Call_Cartonization');
3836: END IF;
3837: --
3838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 3835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Call_Cartonization');

3831: --
3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3833: --
3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Call_Cartonization');
3836: END IF;
3837: --
3838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3839: , p_data => x_msg_data);

Line 3838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3835: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Call_Cartonization');
3836: END IF;
3837: --
3838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3839: , p_data => x_msg_data);
3840: END call_cartonization;
3841:
3842: