DBA Data[Home] [Help]

APPS.ASO_EDUCATION_INT dependencies on ASO_DEBUG_PUB

Line 29: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

25: l_UOM_Code VARCHAR2(3);
26:
27: BEGIN
28:
29: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
30: aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');
31: aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');
32: END IF;
33:

Line 30: aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');

26:
27: BEGIN
28:
29: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
30: aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');
31: aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');
32: END IF;
33:
34: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 31: aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');

27: BEGIN
28:
29: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
30: aso_debug_pub.add('Enter Delete_OTA_Line ', 1, 'Y');
31: aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');
32: END IF;
33:
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN

Line 46: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

42: OPEN C_Get_UOM(P_Qte_Line_Id);
43: FETCH C_Get_UOM INTO l_UOM_Code;
44: CLOSE C_Get_UOM;
45:
46: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
47: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
48: END IF;
49:
50: IF l_UOM_Code = 'ENR' THEN

Line 47: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');

43: FETCH C_Get_UOM INTO l_UOM_Code;
44: CLOSE C_Get_UOM;
45:
46: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
47: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
48: END IF;
49:
50: IF l_UOM_Code = 'ENR' THEN
51:

Line 52: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

48: END IF;
49:
50: IF l_UOM_Code = 'ENR' THEN
51:
52: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
53: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
54: END IF;
55: /*
56: OTA_ASO_INTERFACE.ota_aso_del(

Line 53: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code=ENR ', 1, 'N');

49:
50: IF l_UOM_Code = 'ENR' THEN
51:
52: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
53: aso_debug_pub.add('Delete_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
54: END IF;
55: /*
56: OTA_ASO_INTERFACE.ota_aso_del(
57: P_Api_Version => 1.0,

Line 64: aso_debug_pub.add('Delete_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_del: '||X_Return_Status, 1, 'N');

60: P_Quote_Line_Id => P_Qte_Line_Id,
61: X_Return_Status => X_Return_Status,
62: X_Msg_Count => X_Msg_Count,
63: X_Msg_Data => X_Msg_Data);
64: aso_debug_pub.add('Delete_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_del: '||X_Return_Status, 1, 'N');
65: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
66: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_DELETE_OTA_LINE');
68: FND_MSG_PUB.ADD;

Line 98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

94: l_Qte_Line_Id NUMBER;
95:
96: BEGIN
97:
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');
100: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');
101: END IF;
102:

Line 99: aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');

95:
96: BEGIN
97:
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');
100: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 100: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');

96: BEGIN
97:
98: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
99: aso_debug_pub.add('Enter Update_OTA_Line ', 1, 'Y');
100: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN

Line 113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

109: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
110:
111: FOR i IN 1..P_Order_Line_Tbl.count LOOP
112:
113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
114: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl(i).Quote_Shipment_Line_Id: '||P_Order_Line_Tbl(i).Quote_Shipment_Line_Id, 1, 'N');
115: END IF;
116:
117: OPEN C_Get_UOM_Line(P_Order_Line_Tbl(i).Quote_Shipment_Line_Id);

Line 114: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl(i).Quote_Shipment_Line_Id: '||P_Order_Line_Tbl(i).Quote_Shipment_Line_Id, 1, 'N');

110:
111: FOR i IN 1..P_Order_Line_Tbl.count LOOP
112:
113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
114: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl(i).Quote_Shipment_Line_Id: '||P_Order_Line_Tbl(i).Quote_Shipment_Line_Id, 1, 'N');
115: END IF;
116:
117: OPEN C_Get_UOM_Line(P_Order_Line_Tbl(i).Quote_Shipment_Line_Id);
118: FETCH C_Get_UOM_Line INTO l_UOM_Code, l_Qte_Line_Id;

Line 121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

117: OPEN C_Get_UOM_Line(P_Order_Line_Tbl(i).Quote_Shipment_Line_Id);
118: FETCH C_Get_UOM_Line INTO l_UOM_Code, l_Qte_Line_Id;
119: CLOSE C_Get_UOM_Line;
120:
121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
122: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
123: aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');
124: END IF;
125:

Line 122: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');

118: FETCH C_Get_UOM_Line INTO l_UOM_Code, l_Qte_Line_Id;
119: CLOSE C_Get_UOM_Line;
120:
121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
122: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
123: aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');
124: END IF;
125:
126: IF l_UOM_Code = 'ENR' THEN

Line 123: aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');

119: CLOSE C_Get_UOM_Line;
120:
121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
122: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code: '||l_UOM_Code, 1, 'N');
123: aso_debug_pub.add('Update_OTA_Line- l_Qte_Line_Id: '||l_Qte_Line_Id, 1, 'N');
124: END IF;
125:
126: IF l_UOM_Code = 'ENR' THEN
127:

Line 128: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

124: END IF;
125:
126: IF l_UOM_Code = 'ENR' THEN
127:
128: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
129: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
130: END IF;
131: /*
132: OTA_ASO_INTERFACE.ota_aso_upd(

Line 129: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code=ENR ', 1, 'N');

125:
126: IF l_UOM_Code = 'ENR' THEN
127:
128: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
129: aso_debug_pub.add('Update_OTA_Line- l_UOM_Code=ENR ', 1, 'N');
130: END IF;
131: /*
132: OTA_ASO_INTERFACE.ota_aso_upd(
133: P_Api_Version => 1.0,

Line 141: aso_debug_pub.add('Update_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_upd: '||X_Return_Status, 1, 'N');

137: P_Order_Line_Id => P_Order_Line_Tbl(i).Order_Line_Id,
138: X_Return_Status => X_Return_Status,
139: X_Msg_Count => X_Msg_Count,
140: X_Msg_Data => X_Msg_Data);
141: aso_debug_pub.add('Update_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_upd: '||X_Return_Status, 1, 'N');
142: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
144: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_UPDATE_OTA_LINE');
145: FND_MSG_PUB.ADD;