DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on FND_MSG_PUB

Line 822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

818: END IF;
819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
823: , p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
823: , p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
827: , p_data => x_msg_data);
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
827: , p_data => x_msg_data);
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_RETURN_TO_STOCK');
832: END IF;
833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
834: , p_data => x_msg_data);

Line 831: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_RETURN_TO_STOCK');

827: , p_data => x_msg_data);
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_RETURN_TO_STOCK');
832: END IF;
833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
834: , p_data => x_msg_data);
835: END INV_RETURN_TO_STOCK;

Line 833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_RETURN_TO_STOCK');
832: END IF;
833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
834: , p_data => x_msg_data);
835: END INV_RETURN_TO_STOCK;
836:
837:

Line 1171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1167: END IF;
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1172: , p_data => x_msg_data);
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1172: , p_data => x_msg_data);
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1176: , p_data => x_msg_data);
1177: WHEN OTHERS THEN
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1176: , p_data => x_msg_data);
1177: WHEN OTHERS THEN
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1181: END IF;
1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1183: , p_data => x_msg_data);

Line 1180: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');

1176: , p_data => x_msg_data);
1177: WHEN OTHERS THEN
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1181: END IF;
1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1183: , p_data => x_msg_data);
1184:

Line 1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1181: END IF;
1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1183: , p_data => x_msg_data);
1184:
1185: END INV_LINE_RETURN_TO_STOCK;
1186:

Line 1438: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1434: END IF;
1435: EXCEPTION
1436: WHEN FND_API.G_EXC_ERROR THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR;
1438: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1439: , p_data => x_msg_data);
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1438: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1439: , p_data => x_msg_data);
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1443: , p_data => x_msg_data);
1444: WHEN OTHERS THEN
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1443: , p_data => x_msg_data);
1444: WHEN OTHERS THEN
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1450: , p_data => x_msg_data);

Line 1447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');

1443: , p_data => x_msg_data);
1444: WHEN OTHERS THEN
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1450: , p_data => x_msg_data);
1451:

Line 1449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_LINE_RETURN_TO_STOCK');
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1450: , p_data => x_msg_data);
1451:
1452: END INV_LINE_RETURN_TO_STOCK;
1453:

Line 2408: fnd_msg_pub.initialize;

2404: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2405: BEGIN
2406: x_return_status := FND_API.G_RET_STS_SUCCESS;
2407: x_ret_code := 0;
2408: fnd_msg_pub.initialize;
2409:
2410: IF l_debug=1 THEN
2411: debug('INV_SHIPPING_TRANSACTION_PUB.CONFIRM_DELIVERY..delivery_id: ' || p_delivery_id, 'confirm_delivery');
2412: END IF;

Line 2423: FND_MSG_PUB.ADD;

2419: x_error_msg => l_error_msg);
2420: IF x_return_status = 'E' THEN
2421: FND_MESSAGE.SET_NAME('INV', 'WMS_WSH_SHIPSET_FORCED');
2422: FND_MESSAGE.SET_TOKEN('SHIP_SET_NAME', l_ship_set);
2423: FND_MSG_PUB.ADD;
2424: RAISE unspec_ship_set_exists;
2425: ELSIF x_return_status = 'U' THEN
2426: RAISE fnd_api.g_exc_unexpected_error;
2427: END IF;

Line 2435: FND_MSG_PUB.ADD;

2431: x_return_Status => x_return_status,
2432: x_error_msg => l_error_msg);
2433: IF x_return_status = 'E' THEN
2434: FND_MESSAGE.SET_NAME('INV', 'WMS_INCOMPLETE_DELI');
2435: FND_MSG_PUB.ADD;
2436: IF l_debug = 1 THEN
2437: debug('check_complete_delivery failed with status E','CONFIRM_DELIVERY');
2438: END IF;
2439: RAISE incomplete_delivery;

Line 2489: fnd_msg_pub.count_and_get

2485: x_return_status := fnd_api.g_ret_sts_error;
2486: x_ret_code := 1;
2487:
2488: -- Get message count and data
2489: fnd_msg_pub.count_and_get
2490: ( p_count => x_msg_count
2491: , p_data => x_msg_data
2492: );
2493:

Line 2499: fnd_msg_pub.count_and_get

2495: x_return_status := fnd_api.g_ret_sts_error;
2496: x_ret_code := 2;
2497:
2498: -- Get message count and data
2499: fnd_msg_pub.count_and_get
2500: ( p_count => x_msg_count
2501: , p_data => x_msg_data
2502: );
2503:

Line 2528: fnd_msg_pub.initialize;

2524: l_error_msg VARCHAR2(2000) := NULL;
2525: unassign_lines_exc EXCEPTION;
2526: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2527: BEGIN
2528: fnd_msg_pub.initialize;
2529:
2530: INV_SHIPPING_TRANSACTION_PUB.UNASSIGN_DELIVERY_LINES(
2531: p_delivery_id => p_delivery_id,
2532: x_return_Status => x_return_status,

Line 2569: fnd_msg_pub.count_and_get

2565: WHEN OTHERS THEN
2566: x_return_status := fnd_api.g_ret_sts_unexp_error;
2567:
2568: -- Get message count and data
2569: fnd_msg_pub.count_and_get
2570: ( p_count => x_msg_count
2571: , p_data => x_msg_data
2572: );
2573:

Line 2702: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2698:
2699: x_return_status := FND_API.G_RET_STS_SUCCESS;
2700: x_new_delivery_detail_id := l_new_delivery_line_id;
2701: x_new_transaction_temp_id := l_new_transaction_temp_id;
2702: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2706: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2702: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2707: END INV_SPLIT_DELIVERY_LINE;
2708:
2709: /**
2710: Bug no 3952081

Line 2869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2865:
2866: x_return_status := FND_API.G_RET_STS_SUCCESS;
2867: x_new_delivery_detail_id := l_new_delivery_line_id;
2868: x_new_transaction_temp_id := l_new_transaction_temp_id;
2869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2870: EXCEPTION
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2870: EXCEPTION
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2874: END INV_SPLIT_DELIVERY_LINE;
2875:
2876: PROCEDURE INV_PROCESS_SERIALS(
2877: p_transaction_temp_id IN NUMBER,

Line 2902: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2898: where transaction_temp_id = l_transaction_temp_id
2899: And delivery_detail_id = l_delivery_detail_id);
2900: end if;
2901: x_return_status := FND_API.G_RET_STS_SUCCESS;
2902: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2903:
2904: EXCEPTION
2905: when FND_API.G_EXC_ERROR THEN
2906: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2903:
2904: EXCEPTION
2905: when FND_API.G_EXC_ERROR THEN
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2908: when others then
2909: x_return_status := FND_API.G_RET_STS_ERROR;
2910: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2911: END INV_PROCESS_SERIALS;

Line 2910: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2908: when others then
2909: x_return_status := FND_API.G_RET_STS_ERROR;
2910: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2911: END INV_PROCESS_SERIALS;
2912:
2913:
2914: PROCEDURE get_enforce_ship(p_org_id IN NUMBER,