DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_INVOICE_DETAIL_PROCESS

Line 1: PACKAGE BODY PA_INVOICE_DETAIL_PROCESS as

1: PACKAGE BODY PA_INVOICE_DETAIL_PROCESS as
2: /* $Header: PAICINDB.pls 120.7.12000000.2 2007/02/12 02:06:09 lkan ship $ */
3:
4: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 174: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_all_cc_dist ...');

170: from pa_cc_dist_lines
171: where reference_1 = to_char(P_Draft_Inv_Id);
172: BEGIN
173: IF g1_debug_mode = 'Y' THEN
174: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_all_cc_dist ...');
175: END IF;
176: for cc_get_cc_del_lines in get_cc_del_lines
177: loop
178: --Increase the delete counter

Line 201: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_cc_dist ...');

197: P_index IN number)
198: IS
199: BEGIN
200: IF g1_debug_mode = 'Y' THEN
201: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_cc_dist ...');
202: END IF;
203: --Increase the delete counter
204: PA_CC_BL_PROCESS.g_dcnt := PA_CC_BL_PROCESS.g_dcnt + 1;
205: --Load the delete record

Line 230: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.reverse_cc_dist ...');

226: IS
227: l_pa_date date; /* Added for Bug2276729 */
228: BEGIN
229: IF g1_debug_mode = 'Y' THEN
230: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.reverse_cc_dist ...');
231: END IF;
232: If ((P_CC_REC.TRANSFER_STATUS_CODE = 'P')
233: and (P_CC_REC.LINE_NUM_REVERSED IS NULL ))
234: Then

Line 407: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_cc_dist ...');

403: BEGIN
404:
405: /* Initialize the global record table */
406: IF g1_debug_mode = 'Y' THEN
407: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_cc_dist ...');
408: PA_IC_INV_UTILS.log_message('build_cc_dist: ' || 'Line Num...'||to_char(P_Line_num));
409: END IF;
410: PA_CC_BL_PROCESS.g_icnt := PA_CC_BL_PROCESS.g_icnt + 1;
411: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).expenditure_item_id

Line 567: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_cc_dist ...');

563: l_pa_date date;
564: BEGIN
565:
566: IF g1_debug_mode = 'Y' THEN
567: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_cc_dist ...');
568: END IF;
569: -- Check if any attribute is changed or not
570: If not (( P_Cdl_rec.DR_CODE_COMBINATION_ID = P_CC_rec.DR_CODE_COMBINATION_ID)
571: and ( P_Cdl_rec.CR_CODE_COMBINATION_ID = P_CC_rec.CR_CODE_COMBINATION_ID)

Line 698: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.insert_row ...');

694: IS
695: BEGIN
696:
697: IF g1_debug_mode = 'Y' THEN
698: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.insert_row ...');
699: END IF;
700: --Increase the Insert counter
701: PA_INVOICE_DETAIL_PKG.G_Ins_count := PA_INVOICE_DETAIL_PKG.G_Ins_count + 1;
702: --Assign Invoice detail Id from sequence

Line 715: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_row ...');

711: IS
712: BEGIN
713:
714: IF g1_debug_mode = 'Y' THEN
715: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.delete_row ...');
716: END IF;
717: --Increase the Delete counter
718: PA_INVOICE_DETAIL_PKG.G_Del_count := PA_INVOICE_DETAIL_PKG.G_Del_count + 1;
719: --Add record to delete buffer

Line 731: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_row ...');

727: IS
728: BEGIN
729:
730: IF g1_debug_mode = 'Y' THEN
731: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_row ...');
732: END IF;
733: --Increase the Update counter
734: PA_INVOICE_DETAIL_PKG.G_Upd_count := PA_INVOICE_DETAIL_PKG.G_Upd_count + 1;
735: --Add record to update buffer

Line 745: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_ei ...');

741: -- Procedure to Update EI status as IC Processed.
742: PROCEDURE update_ei
743: IS
744: BEGIN
745: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_ei ...');
746: /* For bug 2877649 Setting the Transfer_price amounts and TP rates to NULL for EIs marked as Never Processed */
747: forall i in 1..I_EI_count
748: Update PA_EXPENDITURE_ITEMS
749: Set CC_IC_PROCESSED_CODE = 'X',

Line 785: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.reverse_row ...');

781: t_line_num NUMBER:=0;
782: BEGIN
783:
784: IF g1_debug_mode = 'Y' THEN
785: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.reverse_row ...');
786: END IF;
787:
788: IF (p_inv_rec.LINE_NUM IS NOT NULL)
789: THEN

Line 874: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row1...');

870: P_Inv_rec IN OUT NOCOPY pa_draft_invoice_details%rowtype)
871: IS
872: BEGIN
873: IF g1_debug_mode = 'Y' THEN
874: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row1...');
875: END IF;
876: P_Inv_rec.INVOICED_FLAG := 'N';
877: P_Inv_rec.DENOM_CURRENCY_CODE := I_DENOM_CURRENCY_CODE(P_Arr_position);
878: P_Inv_rec.DENOM_BILL_AMOUNT := I_DENOM_BILL_AMOUNT(P_Arr_position);

Line 956: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row2...');

952: l_inv_rec pa_draft_invoice_details%rowtype;
953: c number :=0;
954: BEGIN
955: IF g1_debug_mode = 'Y' THEN
956: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.build_row2...');
957: END IF;
958: I_Line_num := I_Line_num + 1;
959: /** Initialize all field of the structure **/
960: l_inv_rec.EXPENDITURE_ITEM_ID := P_Expenditure_item_id;

Line 1049: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.add_ei...');

1045: IS
1046: BEGIN
1047:
1048: IF g1_debug_mode = 'Y' THEN
1049: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.add_ei...');
1050: END IF;
1051: --Increase the EI counter
1052: I_Ei_count := I_Ei_count + 1;
1053: --Add record to Expenditure Buffer buffer

Line 1066: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.is_new_details...');

1062: Return Boolean
1063: IS
1064: Begin
1065: IF g1_debug_mode = 'Y' THEN
1066: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.is_new_details...');
1067: END IF;
1068: Return( not
1069: (
1070: P_IND_REC.DENOM_CURRENCY_CODE = I_DENOM_CURRENCY_CODE(P_Index)

Line 1116: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.read_orig...');

1112: OUT NOCOPY pa_draft_invoice_details%rowtype)
1113: IS
1114: BEGIN
1115: IF g1_debug_mode = 'Y' THEN
1116: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.read_orig...');
1117: END IF;
1118: Select *
1119: INTO X_IND_REC
1120: FROM PA_DRAFT_INVOICE_DETAILS

Line 1137: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_rejection_reason...');

1133: P_No_of_records IN number )
1134: IS
1135: BEGIN
1136: IF g1_debug_mode = 'Y' THEN
1137: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_rejection_reason...');
1138: END IF;
1139: FORALL I IN 1..P_No_of_records
1140: Update PA_EXPENDITURE_ITEMS
1141: Set CC_REJECTION_CODE = P_Error_code(I)

Line 1158: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.apply_db_changes...');

1154: IS
1155: BEGIN
1156:
1157: IF g1_debug_mode = 'Y' THEN
1158: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.apply_db_changes...');
1159: END IF;
1160: /* Apply Pending Delete/Update/Insert in PA_DRAFT_INVOICE Details */
1161: PA_INVOICE_DETAIL_PKG.delete_rows(P_Delete_tab);
1162: PA_INVOICE_DETAIL_PKG.update_rows(P_Update_tab,I_MRC_REQD_FLAG);

Line 1534: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.process_invoice_details...');

1530:
1531:
1532: BEGIN
1533: IF g1_debug_mode = 'Y' THEN
1534: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.process_invoice_details...');
1535: END IF;
1536: /* Checking Provider Reclass Enabled or not...*/
1537: If (P_ca_prov_code = 'N' and P_nca_prov_code = 'N')
1538: Then

Line 2554: END PA_INVOICE_DETAIL_PROCESS;

2550:
2551: END LOOP;
2552: END reverse_preclass;
2553:
2554: END PA_INVOICE_DETAIL_PROCESS;