51: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER :'
52: || ' p_cons_detail_id = ' || p_cons_detail_id);
53: FND_FILE.NEW_LINE(FND_FILE.LOG);
54:
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
56: fnd_log.STRING (fnd_log.level_procedure,
57: g_pkg_name || '.' || l_api_name,
58: gcs_utility_pkg.g_module_enter
59: || ' p_cons_detail_id = '
52: || ' p_cons_detail_id = ' || p_cons_detail_id);
53: FND_FILE.NEW_LINE(FND_FILE.LOG);
54:
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
56: fnd_log.STRING (fnd_log.level_procedure,
57: g_pkg_name || '.' || l_api_name,
58: gcs_utility_pkg.g_module_enter
59: || ' p_cons_detail_id = '
60: || p_cons_detail_id
220:
221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT ');
222: FND_FILE.NEW_LINE(FND_FILE.LOG);
223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
225: fnd_log.STRING (fnd_log.level_procedure,
226: g_pkg_name || '.' || l_api_name,
227: gcs_utility_pkg.g_module_success
228: || ' '
221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT ');
222: FND_FILE.NEW_LINE(FND_FILE.LOG);
223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
225: fnd_log.STRING (fnd_log.level_procedure,
226: g_pkg_name || '.' || l_api_name,
227: gcs_utility_pkg.g_module_success
228: || ' '
229: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
254: BEGIN
255:
256: fnd_file.put_line(fnd_file.log, 'Within raise impact notification');
257:
258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
259: fnd_log.STRING (fnd_log.level_procedure,
260: g_pkg_name || '.' || l_api_name,
261: gcs_utility_pkg.g_module_enter
262: || ' p_run_name = '
255:
256: fnd_file.put_line(fnd_file.log, 'Within raise impact notification');
257:
258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
259: fnd_log.STRING (fnd_log.level_procedure,
260: g_pkg_name || '.' || l_api_name,
261: gcs_utility_pkg.g_module_enter
262: || ' p_run_name = '
263: || p_run_name
350: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
351:
352: COMMIT;
353:
354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
355: fnd_log.STRING (fnd_log.level_procedure,
356: g_pkg_name || '.' || l_api_name,
357: gcs_utility_pkg.g_module_success
358: || ' '
351:
352: COMMIT;
353:
354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
355: fnd_log.STRING (fnd_log.level_procedure,
356: g_pkg_name || '.' || l_api_name,
357: gcs_utility_pkg.g_module_success
358: || ' '
359: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
378: -- Bug fix 5245250
379: l_seq NUMBER;
380: BEGIN
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: fnd_log.STRING (fnd_log.level_procedure,
384: g_pkg_name || '.' || l_api_name,
385: gcs_utility_pkg.g_module_enter
386: || ' p_run_name = '
379: l_seq NUMBER;
380: BEGIN
381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: fnd_log.STRING (fnd_log.level_procedure,
384: g_pkg_name || '.' || l_api_name,
385: gcs_utility_pkg.g_module_enter
386: || ' p_run_name = '
387: || p_run_name
460: WF_ENGINE.StartProcess('FCHNTFWF', l_event_key);
461:
462: COMMIT;
463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
465: fnd_log.STRING (fnd_log.level_procedure,
466: g_pkg_name || '.' || l_api_name,
467: gcs_utility_pkg.g_module_success
468: || ' '
461:
462: COMMIT;
463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
465: fnd_log.STRING (fnd_log.level_procedure,
466: g_pkg_name || '.' || l_api_name,
467: gcs_utility_pkg.g_module_success
468: || ' '
469: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
483: l_api_name VARCHAR2(80) := 'check_attachment_required';
484:
485: BEGIN
486:
487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
488: fnd_log.STRING (fnd_log.level_procedure,
489: g_pkg_name || '.' || l_api_name,
490: gcs_utility_pkg.g_module_enter
491: || ' '
484:
485: BEGIN
486:
487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
488: fnd_log.STRING (fnd_log.level_procedure,
489: g_pkg_name || '.' || l_api_name,
490: gcs_utility_pkg.g_module_enter
491: || ' '
492: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
500: ELSE
501: p_result := 'COMPLETE:T';
502: END IF;
503:
504: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
505: fnd_log.STRING (fnd_log.level_procedure,
506: g_pkg_name || '.' || l_api_name,
507: gcs_utility_pkg.g_module_success
508: || ' '
501: p_result := 'COMPLETE:T';
502: END IF;
503:
504: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
505: fnd_log.STRING (fnd_log.level_procedure,
506: g_pkg_name || '.' || l_api_name,
507: gcs_utility_pkg.g_module_success
508: || ' '
509: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
523: l_api_name VARCHAR2(80) := 'check_impacted';
524:
525: BEGIN
526:
527: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
528: fnd_log.STRING (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: gcs_utility_pkg.g_module_enter
531: || ' '
524:
525: BEGIN
526:
527: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
528: fnd_log.STRING (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: gcs_utility_pkg.g_module_enter
531: || ' '
532: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
540: ELSE
541: p_result := 'COMPLETE:F';
542: END IF;
543:
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: fnd_log.STRING (fnd_log.level_procedure,
546: g_pkg_name || '.' || l_api_name,
547: gcs_utility_pkg.g_module_success
548: || ' '
541: p_result := 'COMPLETE:F';
542: END IF;
543:
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: fnd_log.STRING (fnd_log.level_procedure,
546: g_pkg_name || '.' || l_api_name,
547: gcs_utility_pkg.g_module_success
548: || ' '
549: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
572: AND wias.item_key = p_item_key;
573: */
574: BEGIN
575:
576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
577: fnd_log.STRING (fnd_log.level_procedure,
578: g_pkg_name || '.' || l_api_name,
579: gcs_utility_pkg.g_module_enter
580: || ' '
573: */
574: BEGIN
575:
576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
577: fnd_log.STRING (fnd_log.level_procedure,
578: g_pkg_name || '.' || l_api_name,
579: gcs_utility_pkg.g_module_enter
580: || ' '
581: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
598: END IF;
599: */
600: p_result := 'COMPLETE:T';
601:
602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
603: fnd_log.STRING (fnd_log.level_procedure,
604: g_pkg_name || '.' || l_api_name,
605: gcs_utility_pkg.g_module_success
606: || ' '
599: */
600: p_result := 'COMPLETE:T';
601:
602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
603: fnd_log.STRING (fnd_log.level_procedure,
604: g_pkg_name || '.' || l_api_name,
605: gcs_utility_pkg.g_module_success
606: || ' '
607: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')