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.PA_ASSIGNMENTS_PVT dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY pa_assignments_pvt AS
2: /*$Header: PARAPVTB.pls 120.6.12010000.3 2008/08/22 08:45:24 sugupta ship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
5: li_message_level NUMBER := 1;
6:
7: PROCEDURE Create_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type

Line 59: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Create_Assignment');

55:
56: BEGIN
57:
58: -- Initialize the Error Stack
59: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Create_Assignment');
60:
61: --Log Message
62: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.begin'

Line 63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.begin'

59: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Create_Assignment');
60:
61: --Log Message
62: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.begin'
64: ,x_msg => 'Beginning of the PVT Create_Assignment'
65: ,x_log_level => 5);
66: END IF;
67: -- Initialize the return status to success

Line 133: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment'

129: END IF;
130:
131: -- END FP.M Development
132: IF P_DEBUG_MODE = 'Y' THEN
133: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment'
134: ,x_msg => 'after FP.M'
135: ,x_log_level => li_message_level);
136: END IF;
137:

Line 144: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_open'

140: IF p_assignment_rec.assignment_type = 'OPEN_ASSIGNMENT' THEN
141:
142: --Log Message
143: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
144: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_open'
145: ,x_msg => 'Calling Create Requirement'
146: ,x_log_level => 5);
147: END IF;
148:

Line 169: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment'

165: ,x_return_status => x_return_status
166: );
167:
168: IF P_DEBUG_MODE = 'Y' THEN
169: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment'
170: ,x_msg => 'after open_asgn_pvt.create, status = '||x_return_status
171: ,x_log_level => li_message_level);
172: END IF;
173:

Line 177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_staff'

173:
174: ELSE
175: --Log Message
176: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_staff'
178: ,x_msg => 'Calling Create Assignment'
179: ,x_log_level => 5);
180:
181: END IF;

Line 236: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_subteam_party'

232: IF (p_project_subteam_id IS NOT NULL AND p_project_subteam_id <> FND_API.G_MISS_NUM) THEN
233:
234: --Log Message
235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
236: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_subteam_party'
237: ,x_msg => 'Calling Create Assignment'
238: ,x_log_level => 5);
239: END IF;
240:

Line 268: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_subteam_party'

264: IF get_subteam_id_rec.project_subteam_id IS NOT NULL THEN
265:
266: --Log Message
267: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
268: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.create_subteam_party'
269: ,x_msg => 'Calling Create Assignment'
270: ,x_log_level => 5);
271: END IF;
272:

Line 314: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.add_asgmt_effort'

310: END IF;
311:
312: --Log Message
313: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
314: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Create_Assignment.add_asgmt_effort'
315: ,x_msg => 'Adding Assignment Effort.'
316: ,x_log_level => 5);
317: END IF;
318:

Line 341: PA_DEBUG.Reset_Err_Stack;

337:
338: END IF; --checking there are any new assignments ids
339:
340: -- Reset the error stack when returning to the calling program
341: PA_DEBUG.Reset_Err_Stack;
342:
343: -- If g_error_exists is TRUE then set the x_return_status to 'E'
344:
345: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

Line 363: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

359: -- ENd : 4537865
360:
361: -- Set the excetption Message and the stack
362: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Create_Assignment'
363: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
364: --
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: RAISE;
367: END Create_Assignment;

Line 404: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Assignment');

400:
401: --dbms_output.put_line('Beginning PVTB Update_Assignment');
402:
403: -- Initialize the Error Stack
404: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Assignment');
405:
406: --Log Message
407: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
408: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.begin'

Line 408: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.begin'

404: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Assignment');
405:
406: --Log Message
407: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
408: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.begin'
409: ,x_msg => 'Beginning of PVT Update_Assignment'
410: ,x_log_level => 5);
411: END IF;
412:

Line 428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_subteam_party'

424: (p_assignment_rec.assignment_id IS NOT NULL AND p_assignment_rec.assignment_id <>FND_API.G_MISS_NUM) THEN
425:
426: --Log Message
427: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_subteam_party'
429: ,x_msg => 'Calling Update_SPT_Assgn for subteam party.'
430: ,x_log_level => 5);
431: END IF;
432: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn

Line 499: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_open'

495:
496: IF l_assignment_rec.assignment_type = 'OPEN_ASSIGNMENT' THEN
497: --Log Message
498: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
499: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_open'
500: ,x_msg => 'Calling update requirement.'
501: ,x_log_level => 5);
502: END IF;
503:

Line 517: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_staff'

513: ELSE
514:
515: --Log Message
516: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
517: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_staff'
518: ,x_msg => 'Calling update assignment.'
519: ,x_log_level => 5);
520: END IF;
521:

Line 534: PA_DEBUG.Reset_Err_Stack;

530: );
531: END IF;
532:
533: -- Reset the error stack when returning to the calling program
534: PA_DEBUG.Reset_Err_Stack;
535:
536: -- If g_error_exists is TRUE then set the x_return_status to 'E'
537:
538: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

Line 550: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

546: WHEN OTHERS THEN
547:
548: -- Set the excetption Message and the stack
549: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Update_Assignment'
550: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
551: --
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553: RAISE;
554: END Update_Assignment;

Line 635: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Delete_Assignment');

631:
632: BEGIN
633:
634: -- Initialize the Error Stack
635: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Delete_Assignment');
636:
637: -- Initialize the return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:

Line 642: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.begin'

638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: --Log Message
641: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
642: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.begin'
643: ,x_msg => 'Beginning of Delete_Assignment.'
644: ,x_log_level => 5);
645: END IF;
646:

Line 652: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_subteam_party'

648: IF (p_assignment_id IS NOT NULL AND p_assignment_id <>FND_API.G_MISS_NUM) THEN
649:
650: --Log Message
651: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
652: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_subteam_party'
653: ,x_msg => 'Deleting subteam party'
654: ,x_log_level => 5);
655: END IF;
656: PA_PROJECT_SUBTEAM_PARTIES_PVT.Delete_SubteamParty_By_Obj

Line 675: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_rows'

671: END IF;
672:
673: --Bug 6330317
674: IF P_DEBUG_MODE = 'Y' THEN
675: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_rows'
676: ,x_msg => 'Deleting Conflict History Information'
677: ,x_log_level => 5);
678: END IF;
679:

Line 717: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_open'

713: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
714:
715: --Log Message
716: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
717: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_open'
718: ,x_msg => 'Deleting Requirement'
719: ,x_log_level => 5);
720: END IF;
721:

Line 736: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_staff'

732: ELSE
733:
734: --Log Message
735: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
736: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_staff'
737: ,x_msg => 'Deleting Assignment'
738: ,x_log_level => 5);
739: END IF;
740:

Line 755: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_staff'

751: END IF;
752:
753: -- FP.M Development
754: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
755: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_staff'
756: ,x_msg => 'Call Update_Task_Assignments'
757: ,x_log_level => 5);
758: END IF;
759:

Line 813: PA_DEBUG.Reset_Err_Stack;

809: END IF;
810: */
811:
812: -- Reset the error stack when returning to the calling program
813: PA_DEBUG.Reset_Err_Stack;
814:
815: -- If g_error_exists is TRUE then set the x_return_status to 'E'
816:
817: IF PA_ASSIGNMENTS_PUB.g_error_exists = FND_API.G_TRUE THEN

Line 829: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

825: WHEN OTHERS THEN
826:
827: -- Set the excetption Message and the stack
828: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Delete_Assignment'
829: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
830: --
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: RAISE;
833: END Delete_Assignment;

Line 850: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Revenue_Bill_Rate');

846: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
847: IS
848: BEGIN
849:
850: PA_DEBUG.init_err_stack('PA_ASSIGNMENTS_PVT.Update_Revenue_Bill_Rate');
851:
852: x_return_status := FND_API.G_RET_STS_SUCCESS;
853:
854: IF p_assignment_id_tbl.COUNT > 0 THEN

Line 934: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price', 'Calling PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price' , 3);

930:
931: BEGIN
932:
933: if p_debug_mode = 'Y' THEN
934: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price', 'Calling PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price' , 3);
935: end if;
936:
937: /* Calling get_initial_transfer_price to get the transfer_price_rate and transfer_price_rate */
938:

Line 962: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','The starting date as in forecast items table:'||l_start_date, 3);

958: lx_transfer_pr_rate_curr := NULL;
959: END;
960:
961: if p_debug_mode = 'Y' THEN
962: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','The starting date as in forecast items table:'||l_start_date, 3);
963: end if;
964:
965: IF l_start_date IS NOT NULL THEN
966:

Line 968: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price'

964:
965: IF l_start_date IS NOT NULL THEN
966:
967: IF P_DEBUG_MODE = 'Y' THEN
968: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price'
969: ,x_msg => 'asgmt_id='||p_assignment_id||
970: ' start_date='||l_start_date||
971: ' debug_mod='||p_debug_mode
972: ,x_log_level => li_message_level);

Line 987: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price', 3);

983: ,x_msg_count => x_msg_count
984: );
985:
986: if p_debug_mode = 'Y' THEN
987: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price', 3);
988: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','status is :'||x_return_status||' : x_msg_count:'||x_msg_count, 3);
989: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate:'||lx_transfer_price_rate, 3);
990: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate curr:'||lx_transfer_pr_rate_curr, 3);
991: end if;

Line 988: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','status is :'||x_return_status||' : x_msg_count:'||x_msg_count, 3);

984: );
985:
986: if p_debug_mode = 'Y' THEN
987: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price', 3);
988: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','status is :'||x_return_status||' : x_msg_count:'||x_msg_count, 3);
989: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate:'||lx_transfer_price_rate, 3);
990: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate curr:'||lx_transfer_pr_rate_curr, 3);
991: end if;
992:

Line 989: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate:'||lx_transfer_price_rate, 3);

985:
986: if p_debug_mode = 'Y' THEN
987: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price', 3);
988: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','status is :'||x_return_status||' : x_msg_count:'||x_msg_count, 3);
989: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate:'||lx_transfer_price_rate, 3);
990: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate curr:'||lx_transfer_pr_rate_curr, 3);
991: end if;
992:
993: /* Call to update_Transfer_Price to udpate the transfer_price_Rate and transfer_pr_rate_curr only if no error */

Line 990: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate curr:'||lx_transfer_pr_rate_curr, 3);

986: if p_debug_mode = 'Y' THEN
987: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of PA_CC_TRANSFER_PRICE.Get_Initial_Transfer_Price', 3);
988: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','status is :'||x_return_status||' : x_msg_count:'||x_msg_count, 3);
989: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate:'||lx_transfer_price_rate, 3);
990: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price','Transfer Price Rate curr:'||lx_transfer_pr_rate_curr, 3);
991: end if;
992:
993: /* Call to update_Transfer_Price to udpate the transfer_price_Rate and transfer_pr_rate_curr only if no error */
994:

Line 998: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Calling update_transfer_price with proper Values', 3);

994:
995: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
996:
997: IF p_debug_mode = 'Y' THEN
998: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Calling update_transfer_price with proper Values', 3);
999: END IF;
1000:
1001: PA_ASSIGNMENTS_PVT.Update_Transfer_Price
1002: (

Line 1012: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of update_transfer_price', 3);

1008:
1009: END IF;
1010:
1011: if p_debug_mode = 'Y' THEN
1012: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of update_transfer_price', 3);
1013: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' x_return_status: '||x_return_status, 3);
1014: end if;
1015:
1016: END IF;

Line 1013: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' x_return_status: '||x_return_status, 3);

1009: END IF;
1010:
1011: if p_debug_mode = 'Y' THEN
1012: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' Out of update_transfer_price', 3);
1013: pa_debug.write('PA_ASSIGNMENT_PVT.Calc_Init_Transfer_Price',' x_return_status: '||x_return_status, 3);
1014: end if;
1015:
1016: END IF;
1017: -- 4537865 : Included Exception Block

Line 1147: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1143:
1144: IF l_task_assignment_id_tbl.COUNT <> 0 THEN
1145:
1146: IF P_DEBUG_MODE = 'Y' THEN
1147: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1148: ,x_msg => 'l_task_assignment_id_tbl.COUNT='||l_task_assignment_id_tbl.COUNT
1149: ,x_log_level => li_message_level);
1150: END IF;
1151:

Line 1164: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1160:
1161: FOR j IN l_task_assignment_id_tbl.FIRST .. l_task_assignment_id_tbl.LAST + 1 LOOP
1162:
1163: IF P_DEBUG_MODE = 'Y' THEN
1164: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1165: ,x_msg => 'inside loop'
1166: ,x_log_level => li_message_level);
1167: END IF;
1168:

Line 1173: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1169: IF j = l_task_assignment_id_tbl.LAST + 1
1170: OR l_budget_version_id_tbl(j) <> l_last_bvid THEN
1171:
1172: IF P_DEBUG_MODE = 'Y' THEN
1173: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1174: ,x_msg => 'prepare to call'
1175: ,x_log_level => li_message_level);
1176: END IF;
1177:

Line 1215: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1211: l_rate_func_curr_code_tbl.extend(l_update_task_asgmt_id_tbl.COUNT);
1212: l_rate_incurred_by_org_id_tbl.extend(l_update_task_asgmt_id_tbl.COUNT);
1213:
1214: IF P_DEBUG_MODE = 'Y' THEN
1215: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1216: ,x_msg => 'struct_version_id='||l_last_struct_version_id||
1217: ' bvid='||l_last_bvid
1218: ,x_log_level => li_message_level);
1219: END IF;

Line 1260: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1256: l_rate_func_curr_code_tbl(i) := p_rate_func_curr_code;
1257: l_rate_incurred_by_org_id_tbl(i) := p_rate_incurred_by_org_id;
1258:
1259: IF P_DEBUG_MODE = 'Y' THEN
1260: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1261: ,x_msg => 'i='||i||'version id='||l_update_task_version_id_tbl(i)||
1262: ' task_id='||l_update_task_asgmt_id_tbl(i)||
1263: ' asgmt_id='||l_project_assignment_id_tbl(i)||
1264: ' rlm='||l_resource_list_member_id_tbl(i)

Line 1267: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1263: ' asgmt_id='||l_project_assignment_id_tbl(i)||
1264: ' rlm='||l_resource_list_member_id_tbl(i)
1265: ,x_log_level => li_message_level);
1266:
1267: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1268: ,x_msg => 'i='||i||'res_class_flag='||l_resource_class_flag_tbl(i)||
1269: ' res_class_code='||l_resource_class_code_tbl(i)||
1270: ' res_class_id='||l_resource_class_id_tbl(i)||
1271: ' res_type_code='||l_res_type_code_tbl(i)||

Line 1275: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1271: ' res_type_code='||l_res_type_code_tbl(i)||
1272: ' person_id='||l_person_id_tbl(i)
1273: ,x_log_level => li_message_level);
1274:
1275: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1276: ,x_msg => 'i='||i||'job_id='||l_job_id_tbl(i)||
1277: ' person_type_code='||l_person_type_code_tbl(i)||
1278: ' named_role='||l_named_role_tbl(i)||
1279: ' bom_res_id='||l_bom_resource_id_tbl(i)||

Line 1283: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1279: ' bom_res_id='||l_bom_resource_id_tbl(i)||
1280: ' non_labor_res='||l_non_labor_resource_tbl(i)
1281: ,x_log_level => li_message_level);
1282:
1283: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1284: ,x_msg => 'i='||i||'inven_item='||l_inventory_item_id_tbl(i)||
1285: ' item_cat_id='||l_item_category_id_tbl(i)||
1286: ' proj_role_id='||l_project_role_id_tbl(i)||
1287: ' org_id='||l_organization_id_tbl(i)||

Line 1292: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1288: ' fc_res_type='||l_fc_res_type_code_tbl(i)||
1289: ' exp_type='||l_expenditure_type_tbl(i)
1290: ,x_log_level => li_message_level);
1291:
1292: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1293: ,x_msg => 'i='||i||'exp_cat='||l_expenditure_category_tbl(i)||
1294: ' event_type='||l_event_type_tbl(i)||
1295: ' rev_cat_code='||l_revenue_category_code_tbl(i)||
1296: ' supplier_id='||l_supplier_id_tbl(i)||

Line 1300: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1296: ' supplier_id='||l_supplier_id_tbl(i)||
1297: ' spread_curve='||l_spread_curve_id_tbl(i)
1298: ,x_log_level => li_message_level);
1299:
1300: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1301: ,x_msg => 'i='||i||'etc_method_code='||l_etc_method_code_tbl(i)||
1302: ' mfc_cost_type='||l_mfc_cost_type_id_tbl(i)||
1303: ' inc_by_res_flag='||l_incurred_by_res_flag_tbl(i)||
1304: ' inc_by_res_class='||l_incur_by_res_class_code_tbl(i)||

Line 1323: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1319: p_user_id => FND_GLOBAL.USER_ID,
1320: p_structure_version_id => l_last_struct_version_id);
1321:
1322: IF P_DEBUG_MODE = 'Y' THEN
1323: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1324: ,x_msg => 'l_edit_task_ok='||l_edit_task_ok
1325: ,x_log_level => li_message_level);
1326: END IF;
1327:

Line 1381: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1377: ,x_msg_data => l_msg_data
1378: ,x_msg_count => l_msg_count);
1379:
1380: IF P_DEBUG_MODE = 'Y' THEN
1381: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1382: ,x_msg => 'return status'||l_return_status
1383: ,x_log_level => li_message_level);
1384: END IF;
1385:

Line 1392: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1388:
1389: -- bug 4117269: Remove the error messages added by the above API
1390: l_msg_count2 := FND_MSG_PUB.Count_Msg;
1391: IF P_DEBUG_MODE = 'Y' THEN
1392: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1393: ,x_msg => ' count1='||l_msg_count1||
1394: ' count2='||l_msg_count2
1395: ,x_log_level => li_message_level);
1396: END IF;

Line 1400: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'

1396: END IF;
1397:
1398: FOR k IN (l_msg_count1 + 1)..l_msg_count2 LOOP
1399: IF P_DEBUG_MODE = 'Y' THEN
1400: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1401: ,x_msg => 'Deleting message at index: ' || FND_MSG_PUB.Count_Msg
1402: ,x_log_level => li_message_level);
1403: END IF;
1404: FND_MSG_PUB.delete_msg(p_msg_index => FND_MSG_PUB.Count_Msg);

Line 1480: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task__Assignments'

1476: END IF; -- budget_version_id different
1477:
1478: IF j <> l_task_assignment_id_tbl.LAST + 1 THEN
1479: IF P_DEBUG_MODE = 'Y' THEN
1480: pa_debug.write(x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Task__Assignments'
1481: ,x_msg => 'j <> l_task_assignment_id_tbl.LAST + 1'
1482: ,x_log_level => li_message_level);
1483: END IF;
1484:

Line 1501: PA_DEBUG.Reset_err_stack;

1497:
1498: x_return_status := l_overall_return_status;
1499:
1500: -- Reset the error stack when returning to the calling program
1501: PA_DEBUG.Reset_err_stack;
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505:

Line 1508: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1504: WHEN OTHERS THEN
1505:
1506: -- Set the excetption Message and the stack
1507: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ASSIGNMENTS_PVT.Update_Task_Assignments'
1508: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1509: --
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: RAISE; -- This is optional depending on the needs
1512: