DBA Data[Home] [Help]

APPS.IGS_CO_PROCESS dependencies on FND_FILE

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

241:
242: IF c_att_id%NOTFOUND OR l_attach_fid IS NULL THEN
243: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
244: FND_MESSAGE.SET_TOKEN('LIST', l_list_id);
245: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
246: p_exception := 'Y';
247: CLOSE c_att_id;
248: RETURN;
249: END IF;

Line 269: fnd_file.put_line(fnd_file.log,fnd_message.get());

265: IF l_query_text IS NULL THEN
266: p_exception := 'Y';
267: fnd_message.set_name('IGF','IGF_AW_NO_LIST');
268: fnd_message.set_token('LIST',p_list_id);
269: fnd_file.put_line(fnd_file.log,fnd_message.get());
270: fnd_file.put_line(FND_FILE.LOG,' ');
271: RETURN;
272: ELSE
273: l_query_str := 'SELECT distinct person_id FROM '|| '(' || l_query_text || ')';

Line 270: fnd_file.put_line(FND_FILE.LOG,' ');

266: p_exception := 'Y';
267: fnd_message.set_name('IGF','IGF_AW_NO_LIST');
268: fnd_message.set_token('LIST',p_list_id);
269: fnd_file.put_line(fnd_file.log,fnd_message.get());
270: fnd_file.put_line(FND_FILE.LOG,' ');
271: RETURN;
272: ELSE
273: l_query_str := 'SELECT distinct person_id FROM '|| '(' || l_query_text || ')';
274:

Line 325: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

321: -- if file_name is NOT NULL means, the group is dynamic.
322: l_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_parameter_1 ,lv_status, l_group_type);
323: IF lv_status <> 'S' THEN
324: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
325: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
326: p_exception := 'Y';
327: RETURN;
328: END IF;
329:

Line 702: fnd_file.put_line(fnd_file.log,fnd_message.get());

698: OPEN cur_get_per_num(p_person_id);
699: FETCH cur_get_per_num into l_cur_get_per_num;
700: fnd_message.set_name('IGS','IGS_CO_ELAPSED_DAYS');
701: fnd_message.set_token('PERSON',l_cur_get_per_num.person_number);
702: fnd_file.put_line(fnd_file.log,fnd_message.get());
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: CLOSE cur_get_per_num;
705: ELSIF NVL(p_no_of_repeats,10000) <= l_count THEN
706: p_send_letter := 'FALSE';

Line 703: fnd_file.put_line(FND_FILE.LOG,' ');

699: FETCH cur_get_per_num into l_cur_get_per_num;
700: fnd_message.set_name('IGS','IGS_CO_ELAPSED_DAYS');
701: fnd_message.set_token('PERSON',l_cur_get_per_num.person_number);
702: fnd_file.put_line(fnd_file.log,fnd_message.get());
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: CLOSE cur_get_per_num;
705: ELSIF NVL(p_no_of_repeats,10000) <= l_count THEN
706: p_send_letter := 'FALSE';
707: OPEN cur_get_per_num(p_person_id);

Line 711: fnd_file.put_line(fnd_file.log,fnd_message.get());

707: OPEN cur_get_per_num(p_person_id);
708: FETCH cur_get_per_num into l_cur_get_per_num;
709: fnd_message.set_name('IGS','IGS_CO_NO_REPEATS');
710: fnd_message.set_token('PERSON',l_cur_get_per_num.person_number);
711: fnd_file.put_line(fnd_file.log,fnd_message.get());
712: fnd_file.put_line(FND_FILE.LOG,' ');
713: CLOSE cur_get_per_num;
714: ELSE
715: p_send_letter := 'TRUE';

Line 712: fnd_file.put_line(FND_FILE.LOG,' ');

708: FETCH cur_get_per_num into l_cur_get_per_num;
709: fnd_message.set_name('IGS','IGS_CO_NO_REPEATS');
710: fnd_message.set_token('PERSON',l_cur_get_per_num.person_number);
711: fnd_file.put_line(fnd_file.log,fnd_message.get());
712: fnd_file.put_line(FND_FILE.LOG,' ');
713: CLOSE cur_get_per_num;
714: ELSE
715: p_send_letter := 'TRUE';
716: END IF;

Line 1098: -- FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);

1094:
1095:
1096: IF l_return_status IN ('E','U') THEN
1097: -- FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data );
1098: -- FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
1099:
1100: IF l_msg_count > 1 THEN
1101: FOR i IN 1..l_msg_count
1102: LOOP

Line 1106: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);

1102: LOOP
1103: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1104: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1105: END LOOP;
1106: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1107: ELSE
1108: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1109: END IF;
1110: RETURN;

Line 1108: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);

1104: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1105: END LOOP;
1106: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1107: ELSE
1108: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1109: END IF;
1110: RETURN;
1111: END IF;
1112:

Line 1367: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_version_id ||' /'||l_content_xml);

1363: P_VERSION => l_citem_ver_id , -- CITEM version information IBC.C changes. THIS SHOULD NOT BE l_version_id
1364: p_fax => p_fax_number
1365: );
1366:
1367: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_version_id ||' /'||l_content_xml);
1368: --** proc level logging.
1369: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1370: IF (l_request_id IS NULL) THEN
1371: l_request_id := fnd_global.conc_request_id;

Line 1384: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);

1380:
1381:
1382: IF l_return_status IN ('E','U') THEN
1383: --FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data );
1384: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
1385:
1386: IF l_msg_count > 1 THEN
1387: FOR i IN 1..l_msg_count
1388: LOOP

Line 1392: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);

1388: LOOP
1389: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1390: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1391: END LOOP;
1392: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1393: ELSE
1394: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1395: END IF;
1396: RETURN;

Line 1394: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);

1390: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1391: END LOOP;
1392: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1393: ELSE
1394: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1395: END IF;
1396: RETURN;
1397: END IF;
1398:

Line 1607: fnd_file.put_line(fnd_file.log,fnd_message.get);

1603: OPEN c_per_processed(p_person_id);
1604: FETCH c_per_processed INTO l_person_number,l_full_name;
1605: Fnd_Message.Set_name('IGF','IGF_AW_PROC_STUD');
1606: FND_MESSAGE.SET_TOKEN('STDNT',l_person_number||' - '||l_full_name);
1607: fnd_file.put_line(fnd_file.log,fnd_message.get);
1608: Fnd_Message.Set_name('IGS','IGS_CO_REQ_INFO');
1609: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
1610: fnd_file.put_line(fnd_file.log,fnd_message.get);
1611:

Line 1610: fnd_file.put_line(fnd_file.log,fnd_message.get);

1606: FND_MESSAGE.SET_TOKEN('STDNT',l_person_number||' - '||l_full_name);
1607: fnd_file.put_line(fnd_file.log,fnd_message.get);
1608: Fnd_Message.Set_name('IGS','IGS_CO_REQ_INFO');
1609: FND_MESSAGE.SET_TOKEN('REQUEST_ID',p_request_id);
1610: fnd_file.put_line(fnd_file.log,fnd_message.get);
1611:
1612: IF igs_co_process.l_message_logged THEN
1613: igs_co_process.l_message_logged := FALSE;
1614: END IF;

Line 1619: -- FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);

1615: CLOSE c_per_processed;
1616: ELSE
1617: p_request_status := 'FAILURE';
1618: -- FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data );
1619: -- FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
1620:
1621: IF l_msg_count > 1 THEN
1622: FOR i IN 1..l_msg_count
1623: LOOP

Line 1627: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);

1623: LOOP
1624: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1625: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1626: END LOOP;
1627: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1628: ELSE
1629: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1630: END IF;
1631:

Line 1629: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);

1625: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
1626: END LOOP;
1627: FND_FILE.PUT_LINE(FND_FILE.LOG,l_tmp_var1);
1628: ELSE
1629: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data ||'-' ||l_msg_count);
1630: END IF;
1631:
1632: END IF;
1633:

Line 1652: fnd_file.put_line(fnd_file.log,fnd_message.get);

1648: ELSE
1649: l_corp_submit_fulfil_request := TRUE;
1650: IF NOT igs_co_process.l_message_logged THEN
1651: fnd_message.set_name('IGS','IGS_CO_HOLD_EXISTS');
1652: fnd_file.put_line(fnd_file.log,fnd_message.get);
1653: igs_co_process.l_message_logged := TRUE;
1654: END IF;
1655: OPEN log_details; LOOP
1656: FETCH log_details INTO l_full_name,l_person_number,l_encumbrance_desc;

Line 1658: fnd_file.put_line(fnd_file.log,rpad(l_person_number,20,' ')||' '||rpad(l_full_name,50,' ')||' '||l_encumbrance_desc);

1654: END IF;
1655: OPEN log_details; LOOP
1656: FETCH log_details INTO l_full_name,l_person_number,l_encumbrance_desc;
1657: EXIT WHEN log_details%NOTFOUND;
1658: fnd_file.put_line(fnd_file.log,rpad(l_person_number,20,' ')||' '||rpad(l_full_name,50,' ')||' '||l_encumbrance_desc);
1659: END LOOP;
1660: CLOSE log_details;
1661: END IF;
1662: EXCEPTION

Line 2426: fnd_file.put_line(fnd_file.log,fnd_message.get());

2422: p_parameter_4 IS NOT NULL OR p_parameter_6 IS NOT NULL OR p_parameter_7 IS NOT NULL OR
2423: p_parameter_9 IS NOT NULL OR p_person_id IS NOT NULL THEN
2424: p_exception := 'Y';
2425: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2426: fnd_file.put_line(fnd_file.log,fnd_message.get());
2427: fnd_file.put_line(FND_FILE.LOG,' ');
2428: --** proc level logging.
2429: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2430: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2427: fnd_file.put_line(FND_FILE.LOG,' ');

2423: p_parameter_9 IS NOT NULL OR p_person_id IS NOT NULL THEN
2424: p_exception := 'Y';
2425: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2426: fnd_file.put_line(fnd_file.log,fnd_message.get());
2427: fnd_file.put_line(FND_FILE.LOG,' ');
2428: --** proc level logging.
2429: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2430: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2431: l_debug_str := 'Exiting corp_validate_parameters. values are: ';

Line 2447: fnd_file.put_line(fnd_file.log,fnd_message.get());

2443: --As letter has been submitted with select type as List
2444: --Only List Name should be specified
2445: p_exception := 'Y';
2446: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2447: fnd_file.put_line(fnd_file.log,fnd_message.get());
2448: fnd_file.put_line(FND_FILE.LOG,' ');
2449: --** proc level logging.
2450: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2451: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2448: fnd_file.put_line(FND_FILE.LOG,' ');

2444: --Only List Name should be specified
2445: p_exception := 'Y';
2446: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2447: fnd_file.put_line(fnd_file.log,fnd_message.get());
2448: fnd_file.put_line(FND_FILE.LOG,' ');
2449: --** proc level logging.
2450: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2451: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2452: l_debug_str := 'Exiting corp_validate_parameters. values are: ';

Line 2470: fnd_file.put_line(fnd_file.log,fnd_message.get());

2466: --Only List Name should be specified
2467: --
2468: p_exception := 'Y';
2469: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2470: fnd_file.put_line(fnd_file.log,fnd_message.get());
2471: fnd_file.put_line(FND_FILE.LOG,' ');
2472: --** proc level logging.
2473: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2474: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2471: fnd_file.put_line(FND_FILE.LOG,' ');

2467: --
2468: p_exception := 'Y';
2469: fnd_message.set_name('IGS','IGS_CO_LIST_PRAM');
2470: fnd_file.put_line(fnd_file.log,fnd_message.get());
2471: fnd_file.put_line(FND_FILE.LOG,' ');
2472: --** proc level logging.
2473: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2474: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2475: l_debug_str := 'Exiting corp_validate_parameters as p_select_type is L, none of the nested if condition is satisfied and ';

Line 2493: fnd_file.put_line(fnd_file.log,fnd_message.get());

2489: p_parameter_9 IS NOT NULL THEN
2490: p_exception := 'Y';
2491:
2492: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2493: fnd_file.put_line(fnd_file.log,fnd_message.get());
2494: fnd_file.put_line(FND_FILE.LOG,' ');
2495: --** proc level logging.
2496: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2497: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2494: fnd_file.put_line(FND_FILE.LOG,' ');

2490: p_exception := 'Y';
2491:
2492: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2493: fnd_file.put_line(fnd_file.log,fnd_message.get());
2494: fnd_file.put_line(FND_FILE.LOG,' ');
2495: --** proc level logging.
2496: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2497: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2498: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2514: fnd_file.put_line(fnd_file.log,fnd_message.get());

2510: --As letter has been submitted with select type as List
2511: --Only List Name should be specified
2512: p_exception := 'Y';
2513: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2514: fnd_file.put_line(fnd_file.log,fnd_message.get());
2515: fnd_file.put_line(FND_FILE.LOG,' ');
2516: --** proc level logging.
2517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2518: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2515: fnd_file.put_line(FND_FILE.LOG,' ');

2511: --Only List Name should be specified
2512: p_exception := 'Y';
2513: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2514: fnd_file.put_line(fnd_file.log,fnd_message.get());
2515: fnd_file.put_line(FND_FILE.LOG,' ');
2516: --** proc level logging.
2517: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2518: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2519: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2537: fnd_file.put_line(fnd_file.log,fnd_message.get());

2533:
2534:
2535: p_exception := 'Y';
2536: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2537: fnd_file.put_line(fnd_file.log,fnd_message.get());
2538: fnd_file.put_line(FND_FILE.LOG,' ');
2539: --** proc level logging.
2540: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2541: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2538: fnd_file.put_line(FND_FILE.LOG,' ');

2534:
2535: p_exception := 'Y';
2536: fnd_message.set_name('IGS','IGS_CO_STUD_PRAM');
2537: fnd_file.put_line(fnd_file.log,fnd_message.get());
2538: fnd_file.put_line(FND_FILE.LOG,' ');
2539: --** proc level logging.
2540: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2541: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2542: l_debug_str := 'Exiting corp_validate_parameters as p_select_type is S, none of the nested if condition is satisfied and ';

Line 2565: fnd_file.put_line(fnd_file.log,fnd_message.get());

2561: END IF;
2562: IF NOT( l_all_null = 'TRUE' OR l_all_not_null = 'TRUE') THEN
2563: p_exception := 'Y';
2564: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get());
2566: fnd_file.put_line(FND_FILE.LOG,' ');
2567: --** proc level logging.
2568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2569: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2566: fnd_file.put_line(FND_FILE.LOG,' ');

2562: IF NOT( l_all_null = 'TRUE' OR l_all_not_null = 'TRUE') THEN
2563: p_exception := 'Y';
2564: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2565: fnd_file.put_line(fnd_file.log,fnd_message.get());
2566: fnd_file.put_line(FND_FILE.LOG,' ');
2567: --** proc level logging.
2568: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2569: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2570: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2592: fnd_file.put_line(fnd_file.log,fnd_message.get());

2588: -- either Person ID Group or other parameters should be selected. Both cannot be specified.
2589: --
2590: p_exception := 'Y';
2591: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2592: fnd_file.put_line(fnd_file.log,fnd_message.get());
2593: fnd_file.put_line(FND_FILE.LOG,' ');
2594: --** proc level logging.
2595: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2596: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2593: fnd_file.put_line(FND_FILE.LOG,' ');

2589: --
2590: p_exception := 'Y';
2591: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2592: fnd_file.put_line(fnd_file.log,fnd_message.get());
2593: fnd_file.put_line(FND_FILE.LOG,' ');
2594: --** proc level logging.
2595: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2596: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2597: l_debug_str := 'Exiting corp_validate_parameters for p_select_type P and all other values as none of the if conditions are satisfied.';

Line 2676: fnd_file.put_line(fnd_file.log,fnd_message.get());

2672: --As letter has been submitted with select type as Group
2673: --Only Group Name should be specified
2674: p_exception := 'Y';
2675: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2676: fnd_file.put_line(fnd_file.log,fnd_message.get());
2677: fnd_file.put_line(FND_FILE.LOG,' ');
2678: --** proc level logging.
2679: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2680: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2677: fnd_file.put_line(FND_FILE.LOG,' ');

2673: --Only Group Name should be specified
2674: p_exception := 'Y';
2675: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2676: fnd_file.put_line(fnd_file.log,fnd_message.get());
2677: fnd_file.put_line(FND_FILE.LOG,' ');
2678: --** proc level logging.
2679: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2680: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2681: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2697: fnd_file.put_line(fnd_file.log,fnd_message.get());

2693: --As letter has been submitted with select type as Group
2694: --Only Group Name should be specified
2695: p_exception := 'Y';
2696: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2697: fnd_file.put_line(fnd_file.log,fnd_message.get());
2698: fnd_file.put_line(FND_FILE.LOG,' ');
2699: --** proc level logging.
2700: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2701: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2698: fnd_file.put_line(FND_FILE.LOG,' ');

2694: --Only Group Name should be specified
2695: p_exception := 'Y';
2696: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2697: fnd_file.put_line(fnd_file.log,fnd_message.get());
2698: fnd_file.put_line(FND_FILE.LOG,' ');
2699: --** proc level logging.
2700: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2701: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2702: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2720: fnd_file.put_line(fnd_file.log,fnd_message.get());

2716: -- either Person ID Group or other parameters should be selected. Both cannot be specified.
2717: --
2718: p_exception := 'Y';
2719: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2720: fnd_file.put_line(fnd_file.log,fnd_message.get());
2721: fnd_file.put_line(FND_FILE.LOG,' ');
2722: --** proc level logging.
2723: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2724: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2721: fnd_file.put_line(FND_FILE.LOG,' ');

2717: --
2718: p_exception := 'Y';
2719: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2720: fnd_file.put_line(fnd_file.log,fnd_message.get());
2721: fnd_file.put_line(FND_FILE.LOG,' ');
2722: --** proc level logging.
2723: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2724: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2725: l_debug_str := 'Exiting corp_validate_parameters. values: ';

Line 2744: fnd_file.put_line(fnd_file.log,fnd_message.get());

2740: --
2741:
2742: p_exception := 'N';
2743: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2744: fnd_file.put_line(fnd_file.log,fnd_message.get());
2745: fnd_file.put_line(FND_FILE.LOG,' ');
2746: --** proc level logging.
2747: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2748: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2745: fnd_file.put_line(FND_FILE.LOG,' ');

2741:
2742: p_exception := 'N';
2743: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2744: fnd_file.put_line(fnd_file.log,fnd_message.get());
2745: fnd_file.put_line(FND_FILE.LOG,' ');
2746: --** proc level logging.
2747: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2748: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2749: l_debug_str := 'Exiting corp_validate_parameters as ';

Line 2761: fnd_file.put_line(fnd_file.log,fnd_message.get());

2757:
2758: IF p_parameter_1 IS NULL THEN
2759: p_exception := 'Y';
2760: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2761: fnd_file.put_line(fnd_file.log,fnd_message.get());
2762: fnd_file.put_line(FND_FILE.LOG,' ');
2763: END IF;
2764: END IF; -- final end IF for selection type.
2765:

Line 2762: fnd_file.put_line(FND_FILE.LOG,' ');

2758: IF p_parameter_1 IS NULL THEN
2759: p_exception := 'Y';
2760: fnd_message.set_name('IGS','IGS_CO_PER_LIS_PRAM');
2761: fnd_file.put_line(fnd_file.log,fnd_message.get());
2762: fnd_file.put_line(FND_FILE.LOG,' ');
2763: END IF;
2764: END IF; -- final end IF for selection type.
2765:
2766: --

Line 2772: fnd_file.put_line(fnd_file.log,fnd_message.get());

2768: --
2769: IF l_error_flag = 'TRUE' THEN
2770: p_exception := 'Y';
2771: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2772: fnd_file.put_line(fnd_file.log,fnd_message.get());
2773: fnd_file.put_line(FND_FILE.LOG,' ');
2774: --** proc level logging.
2775: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2776: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';

Line 2773: fnd_file.put_line(FND_FILE.LOG,' ');

2769: IF l_error_flag = 'TRUE' THEN
2770: p_exception := 'Y';
2771: fnd_message.set_name('IGS','IGS_AD_INVALID_PARAM_COMB');
2772: fnd_file.put_line(fnd_file.log,fnd_message.get());
2773: fnd_file.put_line(FND_FILE.LOG,' ');
2774: --** proc level logging.
2775: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2776: l_label := 'igs.plsql.igs_co_process.corp_validate_parameters';
2777: l_debug_str := 'Exiting corp_validate_parameters as l_error_flag is TRUE';