DBA Data[Home] [Help]

APPS.ASO_RESERVATION_INT dependencies on FND_PROFILE

Line 71: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- initialize G_Debug_Flag
71: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
72:
73: l_rsv.reservation_id := NULL;
74: If p_shipment_rec.request_date = FND_API.G_MISS_DATE Or
75: p_shipment_rec.request_date IS NULL Then

Line 86: fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');

82: -- and ship from org , for reservation we are defaulting the value of
83: -- organization_id from profile ASO_SHIP_FROM_ORG_ID
84:
85: l_rsv.organization_id :=
86: fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');
87: If l_rsv.organization_id IS NULL Then
88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: select user_profile_option_name
90: into l_profile_name

Line 91: from fnd_profile_options_vl

87: If l_rsv.organization_id IS NULL Then
88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: select user_profile_option_name
90: into l_profile_name
91: from fnd_profile_options_vl
92: where profile_option_name = 'ASO_SHIP_FROM_ORG_ID';
93:
94: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
95: fnd_message.set_token('PROFILE', l_profile_name);

Line 102: l_rsv.demand_source_type_id := FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');

98: raise FND_API.G_EXC_ERROR;
99: End If;
100:
101: l_rsv.inventory_item_id := p_line_rec.inventory_item_id;
102: l_rsv.demand_source_type_id := FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
103: If l_rsv.demand_source_type_id IS NULL Then
104: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
105: -- THEN
106: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');

Line 274: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

270: END IF;
271:
272:
273: -- initialize G_Debug_Flag
274: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
275:
276:
277: l_rsv_old.reservation_id := p_shipment_rec.reservation_id;
278: l_rsv_old.organization_id := p_line_rec.organization_id;

Line 281: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');

277: l_rsv_old.reservation_id := p_shipment_rec.reservation_id;
278: l_rsv_old.organization_id := p_line_rec.organization_id;
279: l_rsv_old.inventory_item_id := p_line_rec.inventory_item_id;
280: l_rsv_old.demand_source_type_id :=
281: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
282: If l_rsv_old.demand_source_type_id IS NULL Then
283: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
284: -- THEN
285: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');

Line 403: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

399: END IF;
400:
401:
402: -- initialize G_Debug_Flag
403: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
404:
405:
406: l_rsv.reservation_id := p_shipment_rec.reservation_id;
407: l_rsv.organization_id := p_line_rec.organization_id;

Line 410: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');

406: l_rsv.reservation_id := p_shipment_rec.reservation_id;
407: l_rsv.organization_id := p_line_rec.organization_id;
408: l_rsv.inventory_item_id := p_line_rec.inventory_item_id;
409: l_rsv.demand_source_type_id :=
410: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
411: If l_rsv.demand_source_type_id IS NULL Then
412: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
413: -- THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');

Line 526: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

522: END IF;
523:
524:
525: -- initialize G_Debug_Flag
526: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
527:
528:
529: -- existing reservation
530: l_rsv_old.reservation_id := p_shipment_rec.reservation_id;

Line 534: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');

530: l_rsv_old.reservation_id := p_shipment_rec.reservation_id;
531: l_rsv_old.organization_id := p_line_rec.organization_id;
532: l_rsv_old.inventory_item_id := p_line_rec.inventory_item_id;
533: l_rsv_old.demand_source_type_id :=
534: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
535: If l_rsv_old.demand_source_type_id IS NULL Then
536: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
537: -- THEN
538: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');