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.ASO_PROJ_COMM_PVT dependencies on ASO_DEBUG_PUB

Line 69: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

65: l_proj_comm_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_PROJ_COMMISSION'),'N');
66:
67: BEGIN
68:
69: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
70:
71: -- Standard Start of API savepoint
72: SAVEPOINT CALCULATE_PROJ_COMMISSION_PVT;
73:

Line 97: IF aso_debug_pub.g_debug_flag = 'Y' THEN

93: --
94: -- API body
95: --
96:
97: IF aso_debug_pub.g_debug_flag = 'Y' THEN
98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');

Line 98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');

94: -- API body
95: --
96:
97: IF aso_debug_pub.g_debug_flag = 'Y' THEN
98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');

Line 99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');

95: --
96:
97: IF aso_debug_pub.g_debug_flag = 'Y' THEN
98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');

Line 100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');

96:
97: IF aso_debug_pub.g_debug_flag = 'Y' THEN
98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');
104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');

Line 101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');

97: IF aso_debug_pub.g_debug_flag = 'Y' THEN
98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');
104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');
105: END IF;

Line 102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');

98: aso_debug_pub.add('Calc_Proj_Comm: Begin ',1,'Y');
99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');
104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');
105: END IF;
106: -- Basic Validations

Line 103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');

99: aso_debug_pub.add('Calc_Proj_Comm: l_proj_comm_prof: '||l_proj_comm_prof,1,'N');
100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');
104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');
105: END IF;
106: -- Basic Validations
107: -- Check If ASO:Calculate Projected Commmission is set

Line 104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');

100: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_team_prof: '||l_auto_sales_team_prof,1,'N');
101: aso_debug_pub.add('Calc_Proj_Comm: l_auto_sales_cred_prof: '||l_auto_sales_cred_prof,1,'N');
102: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.quote_header_id: '||p_qte_header_rec.quote_header_id,1,'N');
103: aso_debug_pub.add('Calc_Proj_Comm: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date,1,'N');
104: aso_debug_pub.add('Calc_Proj_Comm: P_Resource_Id: '||P_Resource_Id,1,'N');
105: END IF;
106: -- Basic Validations
107: -- Check If ASO:Calculate Projected Commmission is set
108: IF l_proj_comm_prof <> 'Y' THEN

Line 188: IF aso_debug_pub.g_debug_flag = 'Y' THEN

184: OPEN C_Check_Res_Team (P_Resource_Id, C_Header_Info.Quote_Number);
185: FETCH C_Check_Res_Team INTO l_found;
186: CLOSE C_Check_Res_Team;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Expiration_Date: '||C_Header_Info.Quote_Expiration_Date,1,'N');
190: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Number: '||C_Header_Info.Quote_Number,1,'N');
191: aso_debug_pub.add('Calc_Proj_Comm: l_found: '||l_found,1,'N');
192: END IF;

Line 189: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Expiration_Date: '||C_Header_Info.Quote_Expiration_Date,1,'N');

185: FETCH C_Check_Res_Team INTO l_found;
186: CLOSE C_Check_Res_Team;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Expiration_Date: '||C_Header_Info.Quote_Expiration_Date,1,'N');
190: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Number: '||C_Header_Info.Quote_Number,1,'N');
191: aso_debug_pub.add('Calc_Proj_Comm: l_found: '||l_found,1,'N');
192: END IF;
193:

Line 190: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Number: '||C_Header_Info.Quote_Number,1,'N');

186: CLOSE C_Check_Res_Team;
187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Expiration_Date: '||C_Header_Info.Quote_Expiration_Date,1,'N');
190: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Number: '||C_Header_Info.Quote_Number,1,'N');
191: aso_debug_pub.add('Calc_Proj_Comm: l_found: '||l_found,1,'N');
192: END IF;
193:
194: IF l_found IS NULL OR l_found <> 'Y' THEN

Line 191: aso_debug_pub.add('Calc_Proj_Comm: l_found: '||l_found,1,'N');

187:
188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
189: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Expiration_Date: '||C_Header_Info.Quote_Expiration_Date,1,'N');
190: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Number: '||C_Header_Info.Quote_Number,1,'N');
191: aso_debug_pub.add('Calc_Proj_Comm: l_found: '||l_found,1,'N');
192: END IF;
193:
194: IF l_found IS NULL OR l_found <> 'Y' THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 221: IF aso_debug_pub.g_debug_flag = 'Y' THEN

217: OPEN C_Check_Qte_Ordered (C_Header_Info.Quote_Status_Id);
218: FETCH C_Check_Qte_Ordered INTO l_ordered;
219: CLOSE C_Check_Qte_Ordered;
220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');

Line 222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');

218: FETCH C_Check_Qte_Ordered INTO l_ordered;
219: CLOSE C_Check_Qte_Ordered;
220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');
226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');

Line 223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');

219: CLOSE C_Check_Qte_Ordered;
220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');
226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');
227: END IF;

Line 224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');

220:
221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');
226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');
227: END IF;
228: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN

Line 225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');

221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');
226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');
227: END IF;
228: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');

222: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Pricing_Status_Indicator: '||C_Header_Info.Pricing_Status_Indicator,1,'N');
223: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Credit_Update_Date: '||C_Header_Info.Credit_Update_Date,1,'N');
224: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Price_Updated_Date: '||C_Header_Info.Price_Updated_Date,1,'N');
225: aso_debug_pub.add('Calc_Proj_Comm: C_Header_Info.Quote_Status_Id: '||C_Header_Info.Quote_Status_Id,1,'N');
226: aso_debug_pub.add('Calc_Proj_Comm: l_ordered: '||l_ordered,1,'N');
227: END IF;
228: IF l_ordered IS NOT NULL AND l_ordered = 'Y' THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 253: IF aso_debug_pub.g_debug_flag = 'Y' THEN

249: IF C_Header_Info.Credit_Update_Date IS NULL OR
250: (C_Header_Info.Price_Updated_Date IS NOT NULL AND
251: C_Header_Info.Credit_Update_Date < C_Header_Info.Price_Updated_Date) THEN
252:
253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
254: aso_debug_pub.add('Calc_Proj_Comm: Before Allocate_Sales_Credits ',1,'N');
255: END IF;
256:
257: ASO_QUOTE_PUB.Allocate_Sales_Credits

Line 254: aso_debug_pub.add('Calc_Proj_Comm: Before Allocate_Sales_Credits ',1,'N');

250: (C_Header_Info.Price_Updated_Date IS NOT NULL AND
251: C_Header_Info.Credit_Update_Date < C_Header_Info.Price_Updated_Date) THEN
252:
253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
254: aso_debug_pub.add('Calc_Proj_Comm: Before Allocate_Sales_Credits ',1,'N');
255: END IF;
256:
257: ASO_QUOTE_PUB.Allocate_Sales_Credits
258: (

Line 269: IF aso_debug_pub.g_debug_flag = 'Y' THEN

265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data
267: );
268:
269: IF aso_debug_pub.g_debug_flag = 'Y' THEN
270: aso_debug_pub.add('Calc_Proj_Comm: After Allocate_Sales_Credits:x_return_status '||x_return_status,1,'N');
271: END IF;
272:
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 270: aso_debug_pub.add('Calc_Proj_Comm: After Allocate_Sales_Credits:x_return_status '||x_return_status,1,'N');

266: x_msg_data => x_msg_data
267: );
268:
269: IF aso_debug_pub.g_debug_flag = 'Y' THEN
270: aso_debug_pub.add('Calc_Proj_Comm: After Allocate_Sales_Credits:x_return_status '||x_return_status,1,'N');
271: END IF;
272:
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
274: RAISE FND_API.G_EXC_ERROR;

Line 291: IF aso_debug_pub.g_debug_flag = 'Y' THEN

287:
288: END IF;
289: -- END: Basic Validations
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('Calc_Proj_Comm: Before Trucate table ',1,'N');
293: END IF;
294: -- Truncate Temp table
295: DELETE FROM CN_PROJ_COMPENSATION_GTT;

Line 292: aso_debug_pub.add('Calc_Proj_Comm: Before Trucate table ',1,'N');

288: END IF;
289: -- END: Basic Validations
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('Calc_Proj_Comm: Before Trucate table ',1,'N');
293: END IF;
294: -- Truncate Temp table
295: DELETE FROM CN_PROJ_COMPENSATION_GTT;
296:

Line 297: IF aso_debug_pub.g_debug_flag = 'Y' THEN

293: END IF;
294: -- Truncate Temp table
295: DELETE FROM CN_PROJ_COMPENSATION_GTT;
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('Calc_Proj_Comm: Before Insert into table ',1,'N');
299: END IF;
300: -- Populate input values into temp table
301: INSERT INTO CN_PROJ_COMPENSATION_GTT (

Line 298: aso_debug_pub.add('Calc_Proj_Comm: Before Insert into table ',1,'N');

294: -- Truncate Temp table
295: DELETE FROM CN_PROJ_COMPENSATION_GTT;
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('Calc_Proj_Comm: Before Insert into table ',1,'N');
299: END IF;
300: -- Populate input values into temp table
301: INSERT INTO CN_PROJ_COMPENSATION_GTT (
302: LINE_NUMBER,

Line 343: IF aso_debug_pub.g_debug_flag = 'Y' THEN

339: AND A.Quote_Line_Id NOT IN
340: (SELECT C.Line_Number
341: FROM CN_PROJ_COMPENSATION_GTT C);
342:
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: aso_debug_pub.add('Calc_Proj_Comm: Before CN_COMMISSION_CALC_PUB.Calculate_Commission ',1,'N');
345: aso_utility_pvt.print_login_info();
346: END IF;
347: -- Call CN Calculate Commission

Line 344: aso_debug_pub.add('Calc_Proj_Comm: Before CN_COMMISSION_CALC_PUB.Calculate_Commission ',1,'N');

340: (SELECT C.Line_Number
341: FROM CN_PROJ_COMPENSATION_GTT C);
342:
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: aso_debug_pub.add('Calc_Proj_Comm: Before CN_COMMISSION_CALC_PUB.Calculate_Commission ',1,'N');
345: aso_utility_pvt.print_login_info();
346: END IF;
347: -- Call CN Calculate Commission
348: CN_COMMISSION_CALC_PUB.Calculate_Commission (

Line 357: IF aso_debug_pub.g_debug_flag = 'Y' THEN

353: X_Return_Status => X_Return_Status,
354: X_Msg_Count => X_Msg_Count,
355: X_Msg_Data => X_Msg_Data );
356:
357: IF aso_debug_pub.g_debug_flag = 'Y' THEN
358: aso_debug_pub.add('Calc_Proj_Comm: After Calculate_Commission: '||x_return_status,1,'N');
359: aso_utility_pvt.print_login_info();
360: END IF;
361: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 358: aso_debug_pub.add('Calc_Proj_Comm: After Calculate_Commission: '||x_return_status,1,'N');

354: X_Msg_Count => X_Msg_Count,
355: X_Msg_Data => X_Msg_Data );
356:
357: IF aso_debug_pub.g_debug_flag = 'Y' THEN
358: aso_debug_pub.add('Calc_Proj_Comm: After Calculate_Commission: '||x_return_status,1,'N');
359: aso_utility_pvt.print_login_info();
360: END IF;
361: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 367: IF aso_debug_pub.g_debug_flag = 'Y' THEN

363: ELSE
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365: END IF;
366:
367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('Calc_Proj_Comm: Before Resetting Line No ',1,'N');
369: END IF;
370: -- Reset UI Line Number
371: ASO_LINE_NUM_INT.RESET_LINE_NUM;

Line 368: aso_debug_pub.add('Calc_Proj_Comm: Before Resetting Line No ',1,'N');

364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365: END IF;
366:
367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('Calc_Proj_Comm: Before Resetting Line No ',1,'N');
369: END IF;
370: -- Reset UI Line Number
371: ASO_LINE_NUM_INT.RESET_LINE_NUM;
372:

Line 377: IF aso_debug_pub.g_debug_flag = 'Y' THEN

373: OPEN C_Get_Line_Id (p_qte_header_rec.quote_header_id);
374: FETCH C_Get_Line_Id INTO l_In_Line_Number_Tbl(1).Quote_Line_Id;
375: CLOSE C_Get_Line_Id;
376:
377: IF aso_debug_pub.g_debug_flag = 'Y' THEN
378: aso_debug_pub.add('Calc_Proj_Comm: l_In_Line_Number_Tbl(1).Quote_Line_Id: '||l_In_Line_Number_Tbl(1).Quote_Line_Id,1,'N');
379: END IF;
380:
381: ASO_LINE_NUM_INT.ASO_UI_LINE_NUMBER (

Line 378: aso_debug_pub.add('Calc_Proj_Comm: l_In_Line_Number_Tbl(1).Quote_Line_Id: '||l_In_Line_Number_Tbl(1).Quote_Line_Id,1,'N');

374: FETCH C_Get_Line_Id INTO l_In_Line_Number_Tbl(1).Quote_Line_Id;
375: CLOSE C_Get_Line_Id;
376:
377: IF aso_debug_pub.g_debug_flag = 'Y' THEN
378: aso_debug_pub.add('Calc_Proj_Comm: l_In_Line_Number_Tbl(1).Quote_Line_Id: '||l_In_Line_Number_Tbl(1).Quote_Line_Id,1,'N');
379: END IF;
380:
381: ASO_LINE_NUM_INT.ASO_UI_LINE_NUMBER (
382: P_In_Line_Number_Tbl => l_In_Line_Number_Tbl,

Line 392: IF aso_debug_pub.g_debug_flag = 'Y' THEN

388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
391:
392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
393: aso_debug_pub.add('Calc_Proj_Comm: End ',1,'Y');
394: END IF;
395: EXCEPTION
396:

Line 393: aso_debug_pub.add('Calc_Proj_Comm: End ',1,'Y');

389: p_data => x_msg_data
390: );
391:
392: IF aso_debug_pub.g_debug_flag = 'Y' THEN
393: aso_debug_pub.add('Calc_Proj_Comm: End ',1,'Y');
394: END IF;
395: EXCEPTION
396:
397: WHEN FND_API.G_EXC_ERROR THEN