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.HZ_IMP_LOAD_CODE_ASSIGNMENTS dependencies on FND_FILE

Line 139: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (+)');

135: exp_ind NUMBER := 1;
136:
137: BEGIN
138:
139: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (+)');
140: /**********************************/
141: /* Validation and Error reporting */
142: /**********************************/
143:

Line 159: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || P_ACTION || ' Action, ' || ' total ' || num_exp || ' exceptions');

155: l_exception_exists := FLAG_ERROR();
156: l_exception_exists.extend(l_code_assignment_id.count);
157: num_exp := SQL%BULK_EXCEPTIONS.COUNT;
158:
159: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || P_ACTION || ' Action, ' || ' total ' || num_exp || ' exceptions');
160:
161: FOR k IN 1..l_code_assignment_id.count LOOP
162:
163: /* If DML fails due to validation errors or exceptions */

Line 165: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' DML fails at record ' || ' -> l_code_assignment_id = ' || l_code_assignment_id (k) ||' !');

161: FOR k IN 1..l_code_assignment_id.count LOOP
162:
163: /* If DML fails due to validation errors or exceptions */
164: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
165: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' DML fails at record ' || ' -> l_code_assignment_id = ' || l_code_assignment_id (k) ||' !');
166:
167: l_num_row_processed(k) := 0;
168:
169: /* Check for any exceptions during DML */

Line 241: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');

237: from dual
238: where l_num_row_processed(j) = 0
239: );
240:
241: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');
242:
243: END report_errors;
244:
245:

Line 280: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'populate_error_table');

276: dup_val_exp_val VARCHAR2(1) := null;
277: other_exp_val VARCHAR2(1) := 'Y';
278: BEGIN
279:
280: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'populate_error_table');
281:
282: -- in constraint voilation happen, DUP_VAL_IDX_EXCEP_FLAG column
283: -- in temp error table will be set
284: -- 'A' indicate HZ_CODE_ASSIGNMENTS_U1 constraint violation

Line 296: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'dup_val_exp_val:' || dup_val_exp_val);

292: dup_val_exp_val := 'B';
293: end if;
294: end if;
295:
296: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'dup_val_exp_val:' || dup_val_exp_val);
297:
298: insert into hz_imp_tmp_errors
299: (
300: request_id,

Line 601: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_code_assignments (+)');

597: pid_cursor RefCurType;
598:
599: BEGIN
600:
601: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_code_assignments (+)');
602:
603: savepoint process_insert_codeassigns_pvt;
604:
605: FND_MSG_PUB.initialize;

Line 610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);

606:
607: --Initialize API return status to success.
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609:
610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);
611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);
612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);
613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);
614:

Line 611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);

607: --Initialize API return status to success.
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609:
610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);
611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);
612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);
613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);
614:
615: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN

Line 612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);

608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609:
610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);
611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);
612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);
613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);
614:
615: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');

Line 613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);

609:
610: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID'||P_BATCH_ID);
611: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_wu_os'||p_wu_os);
612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);
613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);
614:
615: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');
617:

Line 616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');

612: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_from_osr'||p_from_osr);
613: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_to_osr'||p_to_osr);
614:
615: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');
617:
618: IF P_DML_RECORD.RERUN = 'N' THEN
619: -- First Run
620: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

Line 620: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');
617:
618: IF P_DML_RECORD.RERUN = 'N' THEN
619: -- First Run
620: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');
621: EXECUTE IMMEDIATE l_insert_sql || l_where_first_run_sql
622: USING
623: p_dml_record.application_id,
624: p_dml_record.actual_content_src,

Line 671: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');

667: ;
668:
669: ELSE
670: -- Rerun
671: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');
672: EXECUTE IMMEDIATE l_insert_sql || l_where_rerun_sql
673: USING
674: p_dml_record.application_id,
675: p_dml_record.actual_content_src,

Line 723: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_allow_disabled_lookup = N');

719:
720: END IF;
721:
722: ELSE -- l_allow_disabled_lookup
723: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_allow_disabled_lookup = N');
724:
725: IF P_DML_RECORD.RERUN = 'N' THEN
726:
727: -- First Run

Line 728: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

724:
725: IF P_DML_RECORD.RERUN = 'N' THEN
726:
727: -- First Run
728: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');
729: EXECUTE IMMEDIATE l_insert_sql|| l_where_first_run_sql || l_where_enabled_lookup_sql
730: USING
731: p_dml_record.application_id,
732: p_dml_record.actual_content_src,

Line 784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');

780: p_dml_record.sysdate;
781:
782: ELSE
783: -- Rerun
784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');
785: EXECUTE IMMEDIATE l_insert_sql || l_where_rerun_sql || l_where_enabled_lookup_sql
786: USING
787: p_dml_record.application_id,
788: p_dml_record.actual_content_src,

Line 846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'de-norm failed primary record with primary_flag = Y');

842:
843: /* Failed primary code assignment */
844: /* for all failed primary code assignment, nullify the corresponding denormalization column */
845:
846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'de-norm failed primary record with primary_flag = Y');
847:
848: OPEN primary_flag_err_cursor FOR
849: 'select party_id, class_category
850: from (

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'de-norm record with primary_flag = Y');

928: /* de-norm the primary address to parties */
929: /* Note: for error case, the party with the id will just be not found */
930: /* in update. Not necessary to filter out here. */
931:
932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'de-norm record with primary_flag = Y');
933:
934: OPEN de_norm_cursor FOR
935: ' select cls_sg.party_id,
936: cls_sg.code_assignment_id,

Line 1037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_code_assignment (-)');

1033: HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id) = 'Y' THEN
1034: HZ_MIXNM_CONC_DYNAMIC_PKG.ImportUpdateOrgSST(P_DML_RECORD.actual_content_src,P_DML_RECORD.FROM_OSR,P_DML_RECORD.TO_OSR,P_DML_RECORD.BATCH_ID,P_DML_RECORD.request_id,P_DML_RECORD.program_id,P_DML_RECORD.program_application_id);
1035: END IF;
1036:
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_code_assignment (-)');
1038:
1039: EXCEPTION
1040:
1041: WHEN DUP_VAL_ON_INDEX THEN

Line 1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment dup val exception: ' || SQLERRM);

1038:
1039: EXCEPTION
1040:
1041: WHEN DUP_VAL_ON_INDEX THEN
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment dup val exception: ' || SQLERRM);
1043: ROLLBACK to process_insert_codeassigns_pvt;
1044:
1045: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment other exception: ' || SQLERRM);

1049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1050: FND_MSG_PUB.ADD;
1051:
1052: WHEN OTHERS THEN
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert code assignment other exception: ' || SQLERRM);
1054: ROLLBACK to process_insert_codeassigns_pvt;
1055:
1056: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_code_assignment (+)');

1155: l_dml_exception varchar2(1) := 'N';
1156:
1157: BEGIN
1158:
1159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_code_assignment (+)');
1160:
1161: savepoint process_update_codeassigns_pvt;
1162:
1163: FND_MSG_PUB.initialize;

Line 1170: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167:
1168: IF P_DML_RECORD.RERUN = 'N' THEN
1169: -- First Run
1170: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');
1171: OPEN c_handle_update FOR l_update_sql || l_where_first_run_sql
1172: USING P_DML_RECORD.GMISS_DATE, P_DML_RECORD.GMISS_NUM, P_DML_RECORD.GMISS_DATE,
1173: P_DML_RECORD.batch_id, P_DML_RECORD.batch_mode_flag,
1174: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR,

Line 1180: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');

1176: l_no_end_date, l_no_end_date, P_DML_RECORD.ACTUAL_CONTENT_SRC;
1177:
1178: ELSE
1179: -- Rerun
1180: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');
1181: OPEN c_handle_update FOR l_update_sql || l_where_rerun_sql
1182: USING P_DML_RECORD.GMISS_DATE, P_DML_RECORD.GMISS_NUM, P_DML_RECORD.GMISS_DATE,
1183: P_DML_RECORD.batch_id, P_DML_RECORD.batch_mode_flag,
1184: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR,

Line 1190: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Fetch update cursor');

1186: l_no_end_date, l_no_end_date, P_DML_RECORD.ACTUAL_CONTENT_SRC;
1187:
1188: END IF;
1189:
1190: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Fetch update cursor');
1191: FETCH c_handle_update BULK COLLECT INTO
1192: l_row_id,
1193: l_party_orig_system,
1194: l_party_orig_system_reference,

Line 1212: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'count = ' || l_code_assignment_id.count);

1208: l_start_date_errors,
1209: l_identical_classcode_errors,
1210: l_multi_assign_errors;
1211:
1212: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'count = ' || l_code_assignment_id.count);
1213:
1214: /*** Do DSS security validation based on profile ***/
1215: IF NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N') = 'Y' THEN
1216: validate_DSS_security;

Line 1219: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update code assignment');

1215: IF NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N') = 'Y' THEN
1216: validate_DSS_security;
1217: END IF;
1218:
1219: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update code assignment');
1220:
1221: BEGIN
1222:
1223: ForAll j in 1..l_code_assignment_id.count SAVE EXCEPTIONS

Line 1257: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions');

1253: and l_multi_assign_errors(j) is not null;
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions');
1258: l_dml_exception := 'Y';
1259:
1260: FOR k IN 1..l_code_assignment_id.count LOOP
1261: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));

Line 1261: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));

1257: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions');
1258: l_dml_exception := 'Y';
1259:
1260: FOR k IN 1..l_code_assignment_id.count LOOP
1261: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));
1262: END LOOP;
1263:
1264: END;
1265:

Line 1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_code_assignment (-)');

1266: report_errors(P_DML_RECORD, 'U', l_dml_exception);
1267:
1268: CLOSE c_handle_update;
1269:
1270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_code_assignment (-)');
1271:
1272: EXCEPTION
1273:
1274: WHEN OTHERS THEN

Line 1275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update code assignment other exception: ' || SQLERRM);

1271:
1272: EXCEPTION
1273:
1274: WHEN OTHERS THEN
1275: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update code assignment other exception: ' || SQLERRM);
1276:
1277: ROLLBACK to process_update_codeassigns_pvt;
1278:
1279: populate_error_table(P_DML_RECORD, 'N', SQLERRM);

Line 1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_code_assignments (+)');

1307: BEGIN
1308:
1309: savepoint load_code_assignments_pvt;
1310: FND_MSG_PUB.initialize;
1311: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_code_assignments (+)');
1312:
1313: --Initialize API return status to success.
1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:

Line 1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;

1315:
1316: l_no_end_date := TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS');
1317:
1318:
1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;
1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;

Line 1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;

1316: l_no_end_date := TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS');
1317:
1318:
1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;
1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;

Line 1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;

1317:
1318:
1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;
1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;

Line 1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;

1318:
1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;
1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;

Line 1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;

1319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.os = ' || p_dml_record.os) ;
1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;

Line 1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;

1320: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.from_osr = ' || p_dml_record.from_osr ) ;
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;

Line 1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;

1321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.to_osr = ' || p_dml_record.to_osr) ;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;

Line 1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;

1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.actual_content_src = ' || p_dml_record.actual_content_src) ;
1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;

Line 1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;

1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.rerun = ' || p_dml_record.rerun) ;
1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;

Line 1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;

1324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.error_limit = ' || p_dml_record.error_limit) ;
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;

Line 1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;

1325: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.batch_mode_flag = ' || p_dml_record.batch_mode_flag) ;
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;

Line 1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;

1326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.user_id = ' || p_dml_record.user_id ) ;
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;

Line 1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;

1327: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.last_update_login = ' || p_dml_record.last_update_login) ;
1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;

Line 1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;

1328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_id = ' || p_dml_record.program_id) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;

Line 1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;

1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.program_application_id = ' || p_dml_record.program_application_id) ;
1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;

Line 1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;

1330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.request_id = ' || p_dml_record.request_id) ;
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;
1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;

Line 1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;

1331: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.application_id = ' || p_dml_record.application_id) ;
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;
1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;
1339:

Line 1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;

1332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_char = ' || p_dml_record.gmiss_char) ;
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;
1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;
1339:
1340:

Line 1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;

1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_num = ' || to_char(p_dml_record.gmiss_num)) ;
1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;
1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;
1339:
1340:
1341: process_insert_code_assignment(

Line 1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;

1334: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.gmiss_date = ' || to_char(p_dml_record.gmiss_date, 'MM-DD-YYYY')) ;
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.flex_validation = ' || p_dml_record.flex_validation) ;
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.allow_disabled_lookup = ' || p_dml_record.allow_disabled_lookup) ;
1337: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_dml_record.profile_version = ' || p_dml_record.profile_version) ;
1338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date) ;
1339:
1340:
1341: process_insert_code_assignment(
1342: P_DML_RECORD => P_DML_RECORD

Line 1359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_code_assignments (-)');

1355: ,x_msg_count => x_msg_count
1356: ,x_msg_data => x_msg_data
1357: );
1358:
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_code_assignments (-)');
1360:
1361: END load_code_assignments;
1362: END HZ_IMP_LOAD_CODE_ASSIGNMENTS;