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.INV_COST_GROUP_PVT dependencies on FND_API

Line 28: --Bug 3559334 fix. Need not call the fnd_api again here since

24: --
25: -- End of Comments
26:
27: PROCEDURE print_debug(p_message IN VARCHAR2) IS
28: --Bug 3559334 fix. Need not call the fnd_api again here since
29: --this procedure is invoked only if the Inv:Debug Trace is enabled
30: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
31: BEGIN
32:

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: , p_cost_group_type_id => 3);
117: end if;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: end if;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
128: p_data => x_msg_data);
129:

Line 126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

122: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
123: p_data => x_msg_data);
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
128: p_data => x_msg_data);
129:
130: WHEN OTHERS THEN

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

127: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
128: p_data => x_msg_data);
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
133: FND_MSG_PUB.Add_Exc_Msg
134: ( G_PKG_NAME, 'INV_COST_GROUP_PUB');
135: END IF;

Line 161: x_return_status := fnd_api.g_ret_sts_success;

157: l_primary_cost_method NUMBER := 1 ;
158: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
159: BEGIN
160: SAVEPOINT Calculate_Transfer_Cost_SP;
161: x_return_status := fnd_api.g_ret_sts_success;
162:
163: IF ( l_debug = 1) THEN
164: print_debug('Calculate_Transfer_Cost : Entered with temp id:' ||p_mmtt_temp_id );
165: END IF;

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: ROLLBACK TO Calculate_Transfer_Cost_SP;
239: IF (l_debug = 1) THEN
240: print_debug('Calculate_Transfer_Cost :No Data found !!!! ');
241: END IF;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243:
244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
245: p_data => x_msg_data);
246:

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248: ROLLBACK TO Calculate_Transfer_Cost_SP;
249: IF (l_debug = 1) THEN
250: print_debug('Calculate_Transfer_Cost :Others Exception !!!! ');
251: END IF;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253:
254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
255: p_data => x_msg_data);
256: END Calculate_Transfer_Cost;

Line 262: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

258:
259: PROCEDURE Assign_Cost_Group
260: (
261: p_api_version_number IN NUMBER
262: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
263: , p_commit IN VARCHAR2 := FND_API.G_FALSE
264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_msg_count OUT NOCOPY NUMBER
266: , x_msg_data OUT NOCOPY VARCHAR2

Line 263: , p_commit IN VARCHAR2 := FND_API.G_FALSE

259: PROCEDURE Assign_Cost_Group
260: (
261: p_api_version_number IN NUMBER
262: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
263: , p_commit IN VARCHAR2 := FND_API.G_FALSE
264: , x_return_status OUT NOCOPY VARCHAR2
265: , x_msg_count OUT NOCOPY NUMBER
266: , x_msg_data OUT NOCOPY VARCHAR2
267: , p_transaction_header_id IN NUMBER

Line 292: x_return_status := fnd_api.g_ret_sts_success;

288: SAVEPOINT assign_cost_group_hdr;
289:
290: g_failure_txn_temp_id := NULL; -- Bug 5214602
291:
292: x_return_status := fnd_api.g_ret_sts_success;
293: IF (l_debug = 1) THEN
294: print_debug('In assign cost group pass with header id ' || l_transaction_header_id);
295: END IF;
296:

Line 328: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

324: x_transfer_cost_group_id => l_transfer_cost_Group_id);
325:
326: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
327: RAISE inv_comingle_error;
328: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
330: elsif( x_return_status = FND_API.G_RET_STS_ERROR ) then
331: raise FND_API.G_EXC_ERROR;
332: end if;

Line 329: raise FND_API.G_EXC_UNEXPECTED_ERROR;

325:
326: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
327: RAISE inv_comingle_error;
328: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
330: elsif( x_return_status = FND_API.G_RET_STS_ERROR ) then
331: raise FND_API.G_EXC_ERROR;
332: end if;
333: END LOOP;

Line 330: elsif( x_return_status = FND_API.G_RET_STS_ERROR ) then

326: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
327: RAISE inv_comingle_error;
328: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
330: elsif( x_return_status = FND_API.G_RET_STS_ERROR ) then
331: raise FND_API.G_EXC_ERROR;
332: end if;
333: END LOOP;
334:

Line 331: raise FND_API.G_EXC_ERROR;

327: RAISE inv_comingle_error;
328: elsif( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
329: raise FND_API.G_EXC_UNEXPECTED_ERROR;
330: elsif( x_return_status = FND_API.G_RET_STS_ERROR ) then
331: raise FND_API.G_EXC_ERROR;
332: end if;
333: END LOOP;
334:
335: EXCEPTION

Line 338: x_return_status := FND_API.G_RET_STS_ERROR;

334:
335: EXCEPTION
336: WHEN inv_comingle_error THEN
337: ROLLBACK TO assign_cost_group_hdr;
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: --Bug 5214602 : FP of 2879206
340: g_failure_txn_temp_id := g_current_txn_temp_id;
341: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: --Bug 5214602 : FP of 2879206
340: g_failure_txn_temp_id := g_current_txn_temp_id;
341: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO assign_cost_group_hdr;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: --Bug 5214602 : FP of 2879206
347: g_failure_txn_temp_id := g_current_txn_temp_id;

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
342: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO assign_cost_group_hdr;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: --Bug 5214602 : FP of 2879206
347: g_failure_txn_temp_id := g_current_txn_temp_id;
348: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346: --Bug 5214602 : FP of 2879206
347: g_failure_txn_temp_id := g_current_txn_temp_id;
348: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO assign_cost_group_hdr;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: --Bug 5214602 : FP of 2879206
354: g_failure_txn_temp_id := g_current_txn_temp_id;

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

348: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO assign_cost_group_hdr;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: --Bug 5214602 : FP of 2879206
354: g_failure_txn_temp_id := g_current_txn_temp_id;
355: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
356: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

356: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
357:
358: WHEN OTHERS THEN
359: ROLLBACK TO assign_cost_group_hdr;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: --Bug 5214602 : FP of 2879206
362: g_failure_txn_temp_id := g_current_txn_temp_id;
363: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 434: x_return_status := fnd_api.g_ret_sts_success;

430: -- even though they are LPN triggered transactions. We have to
431: -- account FOR them specifically
432: IF (p_mmtt_rec.inventory_item_id = -1) THEN
433:
434: x_return_status := fnd_api.g_ret_sts_success;
435: RETURN;
436:
437: -- Bug: 4959753: The WIP phantom items are not transactable items
438: -- but are still inserted into MMTT. No onhand or MMT is created for these items

Line 447: x_return_status := fnd_api.g_ret_sts_success;

443: (nvl(p_mmtt_rec.OPERATION_SEQ_NUM,1) < 0) AND (nvl(p_mmtt_rec.WIP_SUPPLY_TYPE,0) = 6)) THEN
444: IF (l_debug = 1) THEN
445: print_debug ('Phantom item, Hence skipping processing');
446: END IF;
447: x_return_status := fnd_api.g_ret_sts_success;
448: RETURN;
449:
450: -- If the transaction is a logical receipt or a logical delivery
451: -- adjustment, we will not go through the cost group logic. We will

Line 494: x_return_status := fnd_api.g_ret_sts_success;

490: WHERE transaction_temp_id = p_mmtt_rec.transaction_temp_id;
491:
492: print_debug('Return Status after update' ||x_return_status );
493:
494: x_return_status := fnd_api.g_ret_sts_success;
495: RETURN;
496:
497: ELSE
498: IF p_mmtt_rec.transaction_action_id IN (INV_Globals.G_Action_IntransitShipment,

Line 526: RAISE FND_API.G_EXC_ERROR;

522: END IF;
523: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
524: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
525: FND_MSG_PUB.ADD;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
530: IF (l_debug = 1) THEN

Line 536: RAISE FND_API.G_EXC_ERROR;

532: END IF;
533: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
534: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: END;
538: END IF;-- l_fob_point is null
539: END IF;--actions
540:

Line 585: RAISE fnd_api.g_exc_unexpected_error;

581: WHEN OTHERS THEN
582: IF (l_debug = 1) THEN
583: print_debug('exception in getting to project: ' || Sqlerrm);
584: END IF;
585: RAISE fnd_api.g_exc_unexpected_error;
586: END;
587: ELSE
588: l_to_project_id := NULL;
589: END IF;

Line 678: IF x_return_status <> fnd_api.g_ret_sts_success THEN

674: , x_msg_data => x_msg_data
675: , x_comingling_occurs => l_comingling_occurs
676: , p_mmtt_rec => p_mmtt_rec);
677:
678: IF x_return_status <> fnd_api.g_ret_sts_success THEN
679: RAISE fnd_api.g_exc_unexpected_error;
680: ELSIF l_comingling_occurs = 'Y' THEN
681: IF (l_debug = 1) THEN
682: print_debug('assign_cost_group comingling occurs : ' );

Line 679: RAISE fnd_api.g_exc_unexpected_error;

675: , x_comingling_occurs => l_comingling_occurs
676: , p_mmtt_rec => p_mmtt_rec);
677:
678: IF x_return_status <> fnd_api.g_ret_sts_success THEN
679: RAISE fnd_api.g_exc_unexpected_error;
680: ELSIF l_comingling_occurs = 'Y' THEN
681: IF (l_debug = 1) THEN
682: print_debug('assign_cost_group comingling occurs : ' );
683: END IF;

Line 695: x_return_status := fnd_api.g_ret_sts_success;

691:
692: END IF; -- IF (p_input_type = G_INPUT_MMTT) THEN
693: /****************Code added*********************/
694:
695: x_return_status := fnd_api.g_ret_sts_success;
696:
697: IF (l_debug = 1) THEN
698: print_debug('in inv_cost_group_pub.assign_cost_group');
699: print_debug('l_line_id : ' || l_line_id);

Line 723: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

719: (x_return_status => x_return_status,
720: x_msg_count => x_msg_count,
721: x_msg_data => x_msg_data,
722: p_organization_id => l_organization_id);
723: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;

Line 724: RAISE FND_API.G_EXC_ERROR;

720: x_msg_count => x_msg_count,
721: x_msg_data => x_msg_data,
722: p_organization_id => l_organization_id);
723: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:

Line 725: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

721: x_msg_data => x_msg_data,
722: p_organization_id => l_organization_id);
723: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: IF (p_input_type = G_INPUT_MMTT) THEN

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: p_organization_id => l_organization_id);
723: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: IF (p_input_type = G_INPUT_MMTT) THEN
730: l_cost_group_id := p_mmtt_rec.cost_group_id;

Line 752: RAISE fnd_api.g_exc_unexpected_error;

748: WHEN OTHERS THEN
749: IF (l_debug = 1) THEN
750: print_debug('exception in getting from project: ' || Sqlerrm);
751: END IF;
752: RAISE fnd_api.g_exc_unexpected_error;
753: END;
754: END IF;
755:
756: IF(p_mmtt_rec.transfer_to_location IS NOT NULL) then

Line 768: RAISE fnd_api.g_exc_unexpected_error;

764: WHEN OTHERS THEN
765: IF (l_debug = 1) THEN
766: print_debug('exception in getting to project: ' || Sqlerrm);
767: END IF;
768: RAISE fnd_api.g_exc_unexpected_error;
769: END;
770: END IF;
771:
772: IF (l_debug = 1) THEN

Line 801: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

797: (x_return_status => x_return_status,
798: x_msg_count => x_msg_count,
799: x_msg_data => x_msg_data,
800: p_organization_id => l_transfer_organization_id);
801: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;

Line 802: RAISE FND_API.G_EXC_ERROR;

798: x_msg_count => x_msg_count,
799: x_msg_data => x_msg_data,
800: p_organization_id => l_transfer_organization_id);
801: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:

Line 803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

799: x_msg_data => x_msg_data,
800: p_organization_id => l_transfer_organization_id);
801: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: SELECT default_cost_group_id,

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: p_organization_id => l_transfer_organization_id);
801: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
802: RAISE FND_API.G_EXC_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: SELECT default_cost_group_id,
808: primary_cost_method

Line 824: RAISE fnd_api.g_exc_unexpected_error;

820: WHEN OTHERS THEN
821: IF (l_debug = 1) THEN
822: print_debug('exception in getting from project: ' || Sqlerrm);
823: END IF;
824: RAISE fnd_api.g_exc_unexpected_error;
825: END;
826: END IF;
827:
828: IF( l_to_locator_id IS NOT NULL) then

Line 842: RAISE fnd_api.g_exc_unexpected_error;

838: WHEN OTHERS THEN
839: IF (l_debug = 1) THEN
840: print_debug('exception in getting to project: ' || Sqlerrm);
841: END IF;
842: RAISE fnd_api.g_exc_unexpected_error;
843: END;
844: END IF;
845:
846: IF (l_debug = 1) THEN

Line 985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

981: ' is ' || l_transfer_cost_group_id);
982: END IF;
983: EXCEPTION
984: WHEN no_data_found THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: l_transfer_cost_group_id := l_tfr_org_cost_group_id;
987: IF (l_debug = 1) THEN
988: print_debug('default cost group of org ' || p_mmtt_rec.transfer_organization ||
989: ' is ' || l_transfer_cost_group_id);

Line 1076: p_init_msg_list => fnd_api.g_false,

1072: print_debug('Calling the Rules Engine: ');
1073: END IF;
1074: wms_costgroupengine_pvt.assign_cost_group
1075: (p_api_version => 1.0,
1076: p_init_msg_list => fnd_api.g_false,
1077: p_commit => fnd_api.g_false,
1078: p_validation_level => fnd_api.g_valid_level_full,
1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,

Line 1077: p_commit => fnd_api.g_false,

1073: END IF;
1074: wms_costgroupengine_pvt.assign_cost_group
1075: (p_api_version => 1.0,
1076: p_init_msg_list => fnd_api.g_false,
1077: p_commit => fnd_api.g_false,
1078: p_validation_level => fnd_api.g_valid_level_full,
1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,
1081: x_msg_data => x_msg_data,

Line 1078: p_validation_level => fnd_api.g_valid_level_full,

1074: wms_costgroupengine_pvt.assign_cost_group
1075: (p_api_version => 1.0,
1076: p_init_msg_list => fnd_api.g_false,
1077: p_commit => fnd_api.g_false,
1078: p_validation_level => fnd_api.g_valid_level_full,
1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,
1081: x_msg_data => x_msg_data,
1082: p_line_id => l_line_id,

Line 1084: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1080: x_msg_count => x_msg_count,
1081: x_msg_data => x_msg_data,
1082: p_line_id => l_line_id,
1083: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
1084: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1085: IF (l_debug = 1) THEN
1086: print_debug('return error from wms_costgroupengine_pvt');
1087: END IF;
1088: RAISE fnd_api.g_exc_error;

Line 1088: RAISE fnd_api.g_exc_error;

1084: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1085: IF (l_debug = 1) THEN
1086: print_debug('return error from wms_costgroupengine_pvt');
1087: END IF;
1088: RAISE fnd_api.g_exc_error;
1089: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1090: IF (l_debug = 1) THEN
1091: print_debug('return unexpected error from wms_costgroupengine_pvt');
1092: END IF;

Line 1089: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1085: IF (l_debug = 1) THEN
1086: print_debug('return error from wms_costgroupengine_pvt');
1087: END IF;
1088: RAISE fnd_api.g_exc_error;
1089: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1090: IF (l_debug = 1) THEN
1091: print_debug('return unexpected error from wms_costgroupengine_pvt');
1092: END IF;
1093: RAISE fnd_api.g_exc_unexpected_error;

Line 1093: RAISE fnd_api.g_exc_unexpected_error;

1089: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1090: IF (l_debug = 1) THEN
1091: print_debug('return unexpected error from wms_costgroupengine_pvt');
1092: END IF;
1093: RAISE fnd_api.g_exc_unexpected_error;
1094: END IF;
1095:
1096: IF p_input_type = G_INPUT_MMTT THEN
1097: IF (l_debug = 1) THEN

Line 1265: p_init_msg_list => fnd_api.g_false,

1261: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1262: END IF;
1263: wms_costgroupengine_pvt.assign_cost_group
1264: (p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,

Line 1266: p_commit => fnd_api.g_false,

1262: END IF;
1263: wms_costgroupengine_pvt.assign_cost_group
1264: (p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,
1270: x_msg_data => x_msg_data,

Line 1267: p_validation_level => fnd_api.g_valid_level_full,

1263: wms_costgroupengine_pvt.assign_cost_group
1264: (p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,
1270: x_msg_data => x_msg_data,
1271: p_line_id => l_line_id,

Line 1273: IF (x_return_status = fnd_api.g_ret_sts_error) then

1269: x_msg_count => x_msg_count,
1270: x_msg_data => x_msg_data,
1271: p_line_id => l_line_id,
1272: p_input_type => wms_costgroupengine_pvt.g_input_mtrl);
1273: IF (x_return_status = fnd_api.g_ret_sts_error) then
1274: IF (l_debug = 1) THEN
1275: print_debug('return error from wms_costgroupengine_pvt');
1276: END IF;
1277: RAISE fnd_api.g_exc_error;

Line 1277: RAISE fnd_api.g_exc_error;

1273: IF (x_return_status = fnd_api.g_ret_sts_error) then
1274: IF (l_debug = 1) THEN
1275: print_debug('return error from wms_costgroupengine_pvt');
1276: END IF;
1277: RAISE fnd_api.g_exc_error;
1278: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1279: IF (l_debug = 1) THEN
1280: print_debug('return unexpected error from wms_costgroupengine_pvt');
1281: END IF;

Line 1278: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then

1274: IF (l_debug = 1) THEN
1275: print_debug('return error from wms_costgroupengine_pvt');
1276: END IF;
1277: RAISE fnd_api.g_exc_error;
1278: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1279: IF (l_debug = 1) THEN
1280: print_debug('return unexpected error from wms_costgroupengine_pvt');
1281: END IF;
1282: RAISE fnd_api.g_exc_unexpected_error;

Line 1282: RAISE fnd_api.g_exc_unexpected_error;

1278: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1279: IF (l_debug = 1) THEN
1280: print_debug('return unexpected error from wms_costgroupengine_pvt');
1281: END IF;
1282: RAISE fnd_api.g_exc_unexpected_error;
1283: end if;
1284:
1285: IF (l_debug = 1) THEN
1286: print_debug('Setting from cost group as null ');

Line 1300: p_init_msg_list => FND_API.G_FALSE,

1296: print_debug('Calling Rules Engine : ');
1297: END IF;
1298: wms_costgroupengine_pvt.assign_cost_group
1299: (p_api_version => 1.0,
1300: p_init_msg_list => FND_API.G_FALSE,
1301: p_commit => FND_API.G_FALSE,
1302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1303: x_return_status => x_return_Status,
1304: x_msg_count => x_msg_count,

Line 1301: p_commit => FND_API.G_FALSE,

1297: END IF;
1298: wms_costgroupengine_pvt.assign_cost_group
1299: (p_api_version => 1.0,
1300: p_init_msg_list => FND_API.G_FALSE,
1301: p_commit => FND_API.G_FALSE,
1302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1303: x_return_status => x_return_Status,
1304: x_msg_count => x_msg_count,
1305: x_msg_data => x_msg_data,

Line 1302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1298: wms_costgroupengine_pvt.assign_cost_group
1299: (p_api_version => 1.0,
1300: p_init_msg_list => FND_API.G_FALSE,
1301: p_commit => FND_API.G_FALSE,
1302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1303: x_return_status => x_return_Status,
1304: x_msg_count => x_msg_count,
1305: x_msg_data => x_msg_data,
1306: p_line_id => l_line_id,

Line 1309: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1305: x_msg_data => x_msg_data,
1306: p_line_id => l_line_id,
1307: p_input_type => WMS_CostGroupEngine_PVT.G_INPUT_MMTT);
1308:
1309: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1310: IF (l_debug = 1) THEN
1311: print_debug('return error from wms_costgroupengine_pvt');
1312: END IF;
1313: RAISE fnd_api.g_exc_error;

Line 1313: RAISE fnd_api.g_exc_error;

1309: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1310: IF (l_debug = 1) THEN
1311: print_debug('return error from wms_costgroupengine_pvt');
1312: END IF;
1313: RAISE fnd_api.g_exc_error;
1314: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1315: IF (l_debug = 1) THEN
1316: print_debug('return unexpected error from wms_costgroupengine_pvt');
1317: END IF;

Line 1314: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1310: IF (l_debug = 1) THEN
1311: print_debug('return error from wms_costgroupengine_pvt');
1312: END IF;
1313: RAISE fnd_api.g_exc_error;
1314: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1315: IF (l_debug = 1) THEN
1316: print_debug('return unexpected error from wms_costgroupengine_pvt');
1317: END IF;
1318: RAISE fnd_api.g_exc_unexpected_error;

Line 1318: RAISE fnd_api.g_exc_unexpected_error;

1314: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1315: IF (l_debug = 1) THEN
1316: print_debug('return unexpected error from wms_costgroupengine_pvt');
1317: END IF;
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: END IF;
1320:
1321: IF (l_debug = 1) THEN
1322: print_debug('Setting from cost group as null ');

Line 1535: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then

1531: x_msg_count => x_msg_count,
1532: x_msg_data => x_msg_data);
1533: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1534: RAISE inv_comingle_error;
1535: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: x_msg_data => x_msg_data);
1533: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1534: RAISE inv_comingle_error;
1535: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: END IF;

Line 1537: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1533: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1534: RAISE inv_comingle_error;
1535: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: END IF;
1541: -- Container transactions

Line 1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1534: RAISE inv_comingle_error;
1535: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: END IF;
1541: -- Container transactions
1542: ELSIF (l_transaction_action_id = inv_globals.g_action_containerpack) OR

Line 1562: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then

1558: x_msg_count => x_msg_count,
1559: x_msg_data => x_msg_data);
1560: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1561: RAISE inv_comingle_error;
1562: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1563: RAISE fnd_api.g_exc_error;
1564: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) then
1565: RAISE fnd_api.g_exc_unexpected_error;
1566: END IF;

Line 1563: RAISE fnd_api.g_exc_error;

1559: x_msg_data => x_msg_data);
1560: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1561: RAISE inv_comingle_error;
1562: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1563: RAISE fnd_api.g_exc_error;
1564: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) then
1565: RAISE fnd_api.g_exc_unexpected_error;
1566: END IF;
1567: END IF;

Line 1564: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) then

1560: if( x_return_status = INV_COST_GROUP_PVT.G_COMINGLE_ERROR ) then
1561: RAISE inv_comingle_error;
1562: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1563: RAISE fnd_api.g_exc_error;
1564: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) then
1565: RAISE fnd_api.g_exc_unexpected_error;
1566: END IF;
1567: END IF;
1568: ELSE

Line 1565: RAISE fnd_api.g_exc_unexpected_error;

1561: RAISE inv_comingle_error;
1562: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) then
1563: RAISE fnd_api.g_exc_error;
1564: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) then
1565: RAISE fnd_api.g_exc_unexpected_error;
1566: END IF;
1567: END IF;
1568: ELSE
1569: -- Receipt transactions

Line 1591: p_init_msg_list => FND_API.G_FALSE,

1587: print_debug('Calling Rules Engine : ');
1588: END IF;
1589: wms_costgroupengine_pvt.assign_cost_group
1590: (p_api_version => 1.0,
1591: p_init_msg_list => FND_API.G_FALSE,
1592: p_commit => FND_API.G_FALSE,
1593: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1594: x_return_status => x_return_Status,
1595: x_msg_count => x_msg_count,

Line 1592: p_commit => FND_API.G_FALSE,

1588: END IF;
1589: wms_costgroupengine_pvt.assign_cost_group
1590: (p_api_version => 1.0,
1591: p_init_msg_list => FND_API.G_FALSE,
1592: p_commit => FND_API.G_FALSE,
1593: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1594: x_return_status => x_return_Status,
1595: x_msg_count => x_msg_count,
1596: x_msg_data => x_msg_data,

Line 1593: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1589: wms_costgroupengine_pvt.assign_cost_group
1590: (p_api_version => 1.0,
1591: p_init_msg_list => FND_API.G_FALSE,
1592: p_commit => FND_API.G_FALSE,
1593: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1594: x_return_status => x_return_Status,
1595: x_msg_count => x_msg_count,
1596: x_msg_data => x_msg_data,
1597: p_line_id => l_line_id,

Line 1600: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1596: x_msg_data => x_msg_data,
1597: p_line_id => l_line_id,
1598: p_input_type => WMS_CostGroupEngine_PVT.G_INPUT_MMTT);
1599:
1600: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1601: IF (l_debug = 1) THEN
1602: print_debug('return error from wms_costgroupengine_pvt');
1603: END IF;
1604: RAISE fnd_api.g_exc_error;

Line 1604: RAISE fnd_api.g_exc_error;

1600: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1601: IF (l_debug = 1) THEN
1602: print_debug('return error from wms_costgroupengine_pvt');
1603: END IF;
1604: RAISE fnd_api.g_exc_error;
1605: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1606: IF (l_debug = 1) THEN
1607: print_debug('return unexpected error from wms_costgroupengine_pvt');
1608: END IF;

Line 1605: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1601: IF (l_debug = 1) THEN
1602: print_debug('return error from wms_costgroupengine_pvt');
1603: END IF;
1604: RAISE fnd_api.g_exc_error;
1605: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1606: IF (l_debug = 1) THEN
1607: print_debug('return unexpected error from wms_costgroupengine_pvt');
1608: END IF;
1609: RAISE fnd_api.g_exc_unexpected_error;

Line 1609: RAISE fnd_api.g_exc_unexpected_error;

1605: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1606: IF (l_debug = 1) THEN
1607: print_debug('return unexpected error from wms_costgroupengine_pvt');
1608: END IF;
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1611: END IF;
1612: END IF;
1613: ELSIF (p_input_type = g_input_moline) THEN

Line 1620: p_init_msg_list => fnd_api.g_false,

1616: END IF;
1617: wms_costgroupengine_pvt.assign_cost_group
1618: (
1619: p_api_version => 1.0,
1620: p_init_msg_list => fnd_api.g_false,
1621: p_commit => fnd_api.g_false,
1622: p_validation_level => fnd_api.g_valid_level_full,
1623: x_return_status => x_return_status,
1624: x_msg_count => x_msg_count,

Line 1621: p_commit => fnd_api.g_false,

1617: wms_costgroupengine_pvt.assign_cost_group
1618: (
1619: p_api_version => 1.0,
1620: p_init_msg_list => fnd_api.g_false,
1621: p_commit => fnd_api.g_false,
1622: p_validation_level => fnd_api.g_valid_level_full,
1623: x_return_status => x_return_status,
1624: x_msg_count => x_msg_count,
1625: x_msg_data => x_msg_data,

Line 1622: p_validation_level => fnd_api.g_valid_level_full,

1618: (
1619: p_api_version => 1.0,
1620: p_init_msg_list => fnd_api.g_false,
1621: p_commit => fnd_api.g_false,
1622: p_validation_level => fnd_api.g_valid_level_full,
1623: x_return_status => x_return_status,
1624: x_msg_count => x_msg_count,
1625: x_msg_data => x_msg_data,
1626: p_line_id => l_line_id,

Line 1628: IF (x_return_status = fnd_api.g_ret_sts_error) then

1624: x_msg_count => x_msg_count,
1625: x_msg_data => x_msg_data,
1626: p_line_id => l_line_id,
1627: p_input_type => wms_costgroupengine_pvt.g_input_mtrl);
1628: IF (x_return_status = fnd_api.g_ret_sts_error) then
1629: IF (l_debug = 1) THEN
1630: print_debug('return error from wms_costgroupengine_pvt');
1631: END IF;
1632: RAISE fnd_api.g_exc_error;

Line 1632: RAISE fnd_api.g_exc_error;

1628: IF (x_return_status = fnd_api.g_ret_sts_error) then
1629: IF (l_debug = 1) THEN
1630: print_debug('return error from wms_costgroupengine_pvt');
1631: END IF;
1632: RAISE fnd_api.g_exc_error;
1633: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1634: IF (l_debug = 1) THEN
1635: print_debug('return unexpected error from wms_costgroupengine_pvt');
1636: END IF;

Line 1633: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then

1629: IF (l_debug = 1) THEN
1630: print_debug('return error from wms_costgroupengine_pvt');
1631: END IF;
1632: RAISE fnd_api.g_exc_error;
1633: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1634: IF (l_debug = 1) THEN
1635: print_debug('return unexpected error from wms_costgroupengine_pvt');
1636: END IF;
1637: RAISE fnd_api.g_exc_unexpected_error;

Line 1637: RAISE fnd_api.g_exc_unexpected_error;

1633: elsif( x_return_status = fnd_api.g_ret_sts_unexp_error) then
1634: IF (l_debug = 1) THEN
1635: print_debug('return unexpected error from wms_costgroupengine_pvt');
1636: END IF;
1637: RAISE fnd_api.g_exc_unexpected_error;
1638: end if;
1639:
1640: x_cost_group_id := NULL;
1641: x_transfer_cost_group_id := NULL;

Line 1674: IF ( x_return_status <> FND_API.g_ret_sts_success ) THEN

1670: , x_return_status => x_return_status
1671: , x_msg_count => x_msg_count
1672: , x_msg_data => x_msg_data );
1673:
1674: IF ( x_return_status <> FND_API.g_ret_sts_success ) THEN
1675: IF (l_debug = 1) THEN
1676: print_debug('Error while executing Calculate_transfer_cost : ' );
1677: END IF;
1678: RAISE FND_API.G_EXC_ERROR;

Line 1678: RAISE FND_API.G_EXC_ERROR;

1674: IF ( x_return_status <> FND_API.g_ret_sts_success ) THEN
1675: IF (l_debug = 1) THEN
1676: print_debug('Error while executing Calculate_transfer_cost : ' );
1677: END IF;
1678: RAISE FND_API.G_EXC_ERROR;
1679: END IF;
1680: END IF ; --End of Bug#6343400
1681: END IF;
1682:

Line 1685: x_return_status := FND_API.G_RET_STS_ERROR;

1681: END IF;
1682:
1683: EXCEPTION
1684: WHEN inv_comingle_error THEN
1685: x_return_status := FND_API.G_RET_STS_ERROR;
1686: ROLLBACK TO assign_cost_group;
1687: --Bug 5214602 : FP of 2879206
1688: g_failure_txn_temp_id := g_current_txn_temp_id;
1689: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );

Line 1696: WHEN FND_API.G_EXC_ERROR THEN

1692: --fnd_message.set_name('INV', 'INV_COMINGLE_ERROR');
1693: --fnd_msg_pub.add;
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1695:
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: --Bug 5214602 : FP of 2879206
1698: g_failure_txn_temp_id := g_current_txn_temp_id;
1699: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1700: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1700: x_return_status := FND_API.G_RET_STS_ERROR;

1696: WHEN FND_API.G_EXC_ERROR THEN
1697: --Bug 5214602 : FP of 2879206
1698: g_failure_txn_temp_id := g_current_txn_temp_id;
1699: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --Bug 5214602 : FP of 2879206

Line 1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1699: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --Bug 5214602 : FP of 2879206
1705: g_failure_txn_temp_id := g_current_txn_temp_id;
1706: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --Bug 5214602 : FP of 2879206
1705: g_failure_txn_temp_id := g_current_txn_temp_id;
1706: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1709:
1710: WHEN OTHERS THEN
1711: --Bug 5214602 : FP of 2879206

Line 1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1710: WHEN OTHERS THEN
1711: --Bug 5214602 : FP of 2879206
1712: g_failure_txn_temp_id := g_current_txn_temp_id;
1713: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1716: FND_MSG_PUB.Add_Exc_Msg
1717: ( G_PKG_NAME, 'INV_COST_GROUP_PVT');
1718: end if;

Line 1816: x_return_status := FND_API.g_ret_sts_success;

1812: GROUP BY ccg.cost_group_id, ccg.cost_group;
1813: END IF;
1814: END IF;
1815:
1816: x_return_status := FND_API.g_ret_sts_success;
1817:
1818: EXCEPTION
1819: WHEN too_many_rows THEN
1820: FND_MESSAGE.SET_NAME('WMS', 'WMS_COMMINGLE_EXISTS'); /*bug#2795266*/

Line 1822: x_return_status := FND_API.g_ret_sts_error;

1818: EXCEPTION
1819: WHEN too_many_rows THEN
1820: FND_MESSAGE.SET_NAME('WMS', 'WMS_COMMINGLE_EXISTS'); /*bug#2795266*/
1821: FND_MSG_PUB.ADD;
1822: x_return_status := FND_API.g_ret_sts_error;
1823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1824: p_data => x_msg_data);
1825:
1826: WHEN NO_DATA_FOUND THEN

Line 1827: x_return_status := FND_API.g_ret_sts_success;

1823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1824: p_data => x_msg_data);
1825:
1826: WHEN NO_DATA_FOUND THEN
1827: x_return_status := FND_API.g_ret_sts_success;
1828: /* BUG 2657862
1829: In this Procedure ,the costgroup is taken from the MOQD
1830: If there is no system quantity ,then this procedure will fails.
1831: So if no record is there ,we need to return sucess and transaction Manager

Line 1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1834: x_cost_group_id :=NULL;
1835: x_cost_group :=NULL;
1836:
1837: WHEN OTHERS THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1840: p_data => x_msg_data);
1841: END get_cost_group;
1842: