APPS.POS_SBD_IBY_PKG dependencies on FND_LOG

Line 15: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

11: l_step NUMBER;
12: BEGIN
13: l_step := 0;
14:
15: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
16: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
17: ' Begin remove_iby_temp_account ');
18: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
19: ' p_iby_temp_ext_bank_account_id ' || p_iby_temp_ext_bank_account_id);

Line 16: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

12: BEGIN
13: l_step := 0;
14:
15: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
16: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
17: ' Begin remove_iby_temp_account ');
18: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
19: ' p_iby_temp_ext_bank_account_id ' || p_iby_temp_ext_bank_account_id);
20: END IF;

Line 18: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

14:
15: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
16: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
17: ' Begin remove_iby_temp_account ');
18: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
19: ' p_iby_temp_ext_bank_account_id ' || p_iby_temp_ext_bank_account_id);
20: END IF;
21:
22: delete from iby_temp_ext_bank_accts

Line 26: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

22: delete from iby_temp_ext_bank_accts
23: where temp_ext_bank_acct_id = p_iby_temp_ext_bank_account_id;
24:
25:
26: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
27: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
28: ' End remove_iby_temp_account ');
29: END IF;
30:

Line 27: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

23: where temp_ext_bank_acct_id = p_iby_temp_ext_bank_account_id;
24:
25:
26: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
27: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
28: ' End remove_iby_temp_account ');
29: END IF;
30:
31: l_step := 1;

Line 114: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

110:
111: BEGIN
112: l_step := 0;
113:
114: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
115: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
116: ' Begin create_iby_temp_account ');
117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
118: ' p_party_id ' || p_party_id);

Line 115: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

111: BEGIN
112: l_step := 0;
113:
114: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
115: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
116: ' Begin create_iby_temp_account ');
117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
118: ' p_party_id ' || p_party_id);
119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

113:
114: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
115: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
116: ' Begin create_iby_temp_account ');
117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
118: ' p_party_id ' || p_party_id);
119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
120: ' p_bank_id ' || p_bank_id);
121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

115: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
116: ' Begin create_iby_temp_account ');
117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
118: ' p_party_id ' || p_party_id);
119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
120: ' p_bank_id ' || p_bank_id);
121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
122: ' p_branch_id ' || p_branch_id);
123: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

117: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
118: ' p_party_id ' || p_party_id);
119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
120: ' p_bank_id ' || p_bank_id);
121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
122: ' p_branch_id ' || p_branch_id);
123: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
124: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
125: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 123: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

119: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
120: ' p_bank_id ' || p_bank_id);
121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
122: ' p_branch_id ' || p_branch_id);
123: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
124: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
125: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
126: ' p_status ' || p_status);
127: END IF;

Line 125: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

121: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
122: ' p_branch_id ' || p_branch_id);
123: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
124: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
125: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
126: ' p_status ' || p_status);
127: END IF;
128:
129: if p_bank_id is null and p_bank_name is not null then

Line 278: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

274: , p_NOTES
275: , p_NOTE_ALT
276: );
277:
278: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
279: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
280: ' End create_iby_temp_account ');
281: END IF;
282:

Line 279: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

275: , p_NOTE_ALT
276: );
277:
278: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
279: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
280: ' End create_iby_temp_account ');
281: END IF;
282:
283: l_step := 3;

Line 374: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

370:
371: BEGIN
372: l_step := 0;
373:
374: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
375: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
376: ' Begin update_iby_temp_account ');
377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
378: ' p_temp_ext_account_id ' || p_temp_ext_bank_acct_id);

Line 375: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

371: BEGIN
372: l_step := 0;
373:
374: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
375: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
376: ' Begin update_iby_temp_account ');
377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
378: ' p_temp_ext_account_id ' || p_temp_ext_bank_acct_id);
379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

373:
374: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
375: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
376: ' Begin update_iby_temp_account ');
377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
378: ' p_temp_ext_account_id ' || p_temp_ext_bank_acct_id);
379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
380: ' p_party_id ' || p_party_id);
381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

375: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
376: ' Begin update_iby_temp_account ');
377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
378: ' p_temp_ext_account_id ' || p_temp_ext_bank_acct_id);
379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
380: ' p_party_id ' || p_party_id);
381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
382: ' p_bank_id ' || p_bank_id);
383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

377: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
378: ' p_temp_ext_account_id ' || p_temp_ext_bank_acct_id);
379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
380: ' p_party_id ' || p_party_id);
381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
382: ' p_bank_id ' || p_bank_id);
383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
384: ' p_branch_id ' || p_branch_id);
385: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

379: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
380: ' p_party_id ' || p_party_id);
381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
382: ' p_bank_id ' || p_bank_id);
383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
384: ' p_branch_id ' || p_branch_id);
385: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
386: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
387: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 385: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

381: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
382: ' p_bank_id ' || p_bank_id);
383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
384: ' p_branch_id ' || p_branch_id);
385: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
386: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
387: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
388: ' p_status ' || p_status);
389: END IF;

Line 387: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

383: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
384: ' p_branch_id ' || p_branch_id);
385: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
386: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
387: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
388: ' p_status ' || p_status);
389: END IF;
390:
391: open l_bank_branch_loc_cur;

Line 550: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

546: where temp_ext_bank_acct_id = p_temp_ext_bank_acct_id;
547:
548: l_step := 4;
549:
550: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
552: ' End update_iby_temp_account ');
553: END IF;
554:

Line 551: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

547:
548: l_step := 4;
549:
550: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
551: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
552: ' End update_iby_temp_account ');
553: END IF;
554:
555: x_status :='S';

Line 589: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

585: l_location_rec hz_location_v2pub.LOCATION_REC_TYPE;
586:
587: BEGIN
588:
589: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
591: ' Begin create_location ');
592: END IF;
593:

Line 590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

586:
587: BEGIN
588:
589: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
591: ' Begin create_location ');
592: END IF;
593:
594: if p_country is not null and p_address1 is not null then

Line 621: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

617: else
618: x_status := 'S';
619: end if;
620:
621: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
622: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
623: ' End create_location ');
624: END IF;
625:

Line 622: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

618: x_status := 'S';
619: end if;
620:
621: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
622: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
623: ' End create_location ');
624: END IF;
625:
626:

Line 664: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

660: BEGIN
661:
662: l_step := 0;
663:
664: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
665: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
666: ' Begin update_location ');
667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
668: ' p_location_id ' || p_location_id);

Line 665: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

661:
662: l_step := 0;
663:
664: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
665: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
666: ' Begin update_location ');
667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
668: ' p_location_id ' || p_location_id);
669: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

663:
664: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
665: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
666: ' Begin update_location ');
667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
668: ' p_location_id ' || p_location_id);
669: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
670: ' p_country ' || p_country);
671: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 669: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

665: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
666: ' Begin update_location ');
667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
668: ' p_location_id ' || p_location_id);
669: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
670: ' p_country ' || p_country);
671: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
672: ' p_address1 ' || p_address1);
673: END IF;

Line 671: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

667: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
668: ' p_location_id ' || p_location_id);
669: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
670: ' p_country ' || p_country);
671: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
672: ' p_address1 ' || p_address1);
673: END IF;
674:
675: select object_version_number, created_by_module

Line 725: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

721: );
722:
723: l_step := 2;
724:
725: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
726: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
727: ' End update_location ');
728: END IF;
729:

Line 726: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

722:
723: l_step := 2;
724:
725: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
726: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
727: ' End update_location ');
728: END IF;
729:
730: EXCEPTION

Line 816: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

812:
813: l_create_flag varchar2(1);
814: BEGIN
815:
816: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
817: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
818: ' Begin validate_account ');
819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
820: ' p_mapping_id ' || p_mapping_id);

Line 817: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

813: l_create_flag varchar2(1);
814: BEGIN
815:
816: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
817: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
818: ' Begin validate_account ');
819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
820: ' p_mapping_id ' || p_mapping_id);
821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

815:
816: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
817: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
818: ' Begin validate_account ');
819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
820: ' p_mapping_id ' || p_mapping_id);
821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
822: ' p_bank_id ' || p_bank_id);
823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

817: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
818: ' Begin validate_account ');
819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
820: ' p_mapping_id ' || p_mapping_id);
821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
822: ' p_bank_id ' || p_bank_id);
823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
824: ' p_branch_id ' || p_branch_id);
825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

819: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
820: ' p_mapping_id ' || p_mapping_id);
821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
822: ' p_bank_id ' || p_bank_id);
823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
824: ' p_branch_id ' || p_branch_id);
825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
826: ' p_bank_name ' || p_bank_name);
827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

821: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
822: ' p_bank_id ' || p_bank_id);
823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
824: ' p_branch_id ' || p_branch_id);
825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
826: ' p_bank_name ' || p_bank_name);
827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
828: ' p_branch_name ' || p_branch_name);
829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

823: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
824: ' p_branch_id ' || p_branch_id);
825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
826: ' p_bank_name ' || p_bank_name);
827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
828: ' p_branch_name ' || p_branch_name);
829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
830: ' p_bank_number ' || p_bank_number);
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

825: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
826: ' p_bank_name ' || p_bank_name);
827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
828: ' p_branch_name ' || p_branch_name);
829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
830: ' p_bank_number ' || p_bank_number);
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
832: ' p_branch_number ' || p_branch_number);
833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

827: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
828: ' p_branch_name ' || p_branch_name);
829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
830: ' p_bank_number ' || p_bank_number);
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
832: ' p_branch_number ' || p_branch_number);
833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
834: ' p_bank_account_number ' || p_bank_account_number);
835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

829: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
830: ' p_bank_number ' || p_bank_number);
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
832: ' p_branch_number ' || p_branch_number);
833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
834: ' p_bank_account_number ' || p_bank_account_number);
835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
836: ' p_bank_account_name ' || p_bank_account_name);
837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

831: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
832: ' p_branch_number ' || p_branch_number);
833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
834: ' p_bank_account_number ' || p_bank_account_number);
835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
836: ' p_bank_account_name ' || p_bank_account_name);
837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
838: ' p_currency_code ' || p_currency_code);
839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

833: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
834: ' p_bank_account_number ' || p_bank_account_number);
835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
836: ' p_bank_account_name ' || p_bank_account_name);
837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
838: ' p_currency_code ' || p_currency_code);
839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
840: ' p_country_code ' || p_country_code);
841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

835: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
836: ' p_bank_account_name ' || p_bank_account_name);
837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
838: ' p_currency_code ' || p_currency_code);
839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
840: ' p_country_code ' || p_country_code);
841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
842: ' p_iban ' || p_iban);
843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

837: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
838: ' p_currency_code ' || p_currency_code);
839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
840: ' p_country_code ' || p_country_code);
841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
842: ' p_iban ' || p_iban);
843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
844: ' p_check_digits ' || p_check_digits);
845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

839: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
840: ' p_country_code ' || p_country_code);
841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
842: ' p_iban ' || p_iban);
843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
844: ' p_check_digits ' || p_check_digits);
845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
846: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
847: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

841: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
842: ' p_iban ' || p_iban);
843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
844: ' p_check_digits ' || p_check_digits);
845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
846: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
847: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
848: ' p_account_request_ud ' || p_account_request_id);
849: END IF;

Line 847: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

843: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
844: ' p_check_digits ' || p_check_digits);
845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
846: ' p_ext_bank_account_id ' || p_ext_bank_account_id);
847: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
848: ' p_account_request_ud ' || p_account_request_id);
849: END IF;
850:
851: l_step := 0;

Line 968: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

964: x_msg_data => x_exception_msg,
965: x_response => l_result_rec
966: );
967:
968: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
969: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
970: ' IBY API Validation Status ' || x_status);
971: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
972: ' IBY API Validation msg count ' || l_msg_count);

Line 969: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

965: x_response => l_result_rec
966: );
967:
968: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
969: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
970: ' IBY API Validation Status ' || x_status);
971: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
972: ' IBY API Validation msg count ' || l_msg_count);
973: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 971: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

967:
968: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
969: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
970: ' IBY API Validation Status ' || x_status);
971: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
972: ' IBY API Validation msg count ' || l_msg_count);
973: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
974: ' IBY API Validation exception msg ' || x_exception_msg);
975: END IF;

Line 973: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

969: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
970: ' IBY API Validation Status ' || x_status);
971: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
972: ' IBY API Validation msg count ' || l_msg_count);
973: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
974: ' IBY API Validation exception msg ' || x_exception_msg);
975: END IF;
976:
977: l_step := 8;

Line 981: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

977: l_step := 8;
978:
979: end if;
980:
981: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
982: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
983: ' End validate_account ');
984: END IF;
985:

Line 982: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

978:
979: end if;
980:
981: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
982: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
983: ' End validate_account ');
984: END IF;
985:
986: EXCEPTION

Line 1067: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1063:
1064: BEGIN
1065:
1066: l_step := 0;
1067: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1068: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1069: ' Begin assign_site_to_account ');
1070: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1071: ' p_vendor_site_id ' || p_vendor_site_id);

Line 1068: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1064: BEGIN
1065:
1066: l_step := 0;
1067: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1068: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1069: ' Begin assign_site_to_account ');
1070: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1071: ' p_vendor_site_id ' || p_vendor_site_id);
1072: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1070: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1066: l_step := 0;
1067: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1068: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1069: ' Begin assign_site_to_account ');
1070: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1071: ' p_vendor_site_id ' || p_vendor_site_id);
1072: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1073: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1074: END IF;

Line 1072: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1068: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1069: ' Begin assign_site_to_account ');
1070: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1071: ' p_vendor_site_id ' || p_vendor_site_id);
1072: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1073: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1074: END IF;
1075:
1076: l_step := 1;

Line 1119: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1115: l_pay_assign_rec.End_Date := null;
1116:
1117: l_step := 6;
1118:
1119: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1120: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1121: ' Calling Set_Payee_Instr_Assignment ');
1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1123: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);

Line 1120: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1116:
1117: l_step := 6;
1118:
1119: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1120: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1121: ' Calling Set_Payee_Instr_Assignment ');
1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1123: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1118:
1119: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1120: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1121: ' Calling Set_Payee_Instr_Assignment ');
1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1123: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1125: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1120: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1121: ' Calling Set_Payee_Instr_Assignment ');
1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1123: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1125: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1127: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1122: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1123: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1125: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1127: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1129: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1125: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1127: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1129: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1131: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1126: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1127: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1129: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1131: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1133: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1134: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1128: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1129: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1131: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1133: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1134: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1135: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1136: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1134: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1130: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1131: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1133: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1134: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1135: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1136: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1137: ' l_pay_assign_rec.End_Date ' || l_pay_assign_rec.End_Date);
1138: END IF;

Line 1136: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1132: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1133: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1134: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1135: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1136: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1137: ' l_pay_assign_rec.End_Date ' || l_pay_assign_rec.End_Date);
1138: END IF;
1139:
1140: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(

Line 1154: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1150: x_response => l_result_rec
1151: );
1152: l_step := 7;
1153:
1154: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1155: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1156: ' After Set_Payee_Instr_Assignment ');
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' x_return_status ' || x_status);

Line 1155: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1151: );
1152: l_step := 7;
1153:
1154: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1155: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1156: ' After Set_Payee_Instr_Assignment ');
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' x_return_status ' || x_status);
1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1153:
1154: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1155: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1156: ' After Set_Payee_Instr_Assignment ');
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' x_return_status ' || x_status);
1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1160: ' x_msg_count ' || l_msg_count);
1161: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1155: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1156: ' After Set_Payee_Instr_Assignment ');
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' x_return_status ' || x_status);
1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1160: ' x_msg_count ' || l_msg_count);
1161: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1162: ' x_msg_data ' || x_exception_msg);
1163: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1161: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' x_return_status ' || x_status);
1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1160: ' x_msg_count ' || l_msg_count);
1161: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1162: ' x_msg_data ' || x_exception_msg);
1163: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1164: ' x_assign_id ' || l_payee_assignment_id);
1165: END IF;

Line 1163: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1159: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1160: ' x_msg_count ' || l_msg_count);
1161: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1162: ' x_msg_data ' || x_exception_msg);
1163: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1164: ' x_assign_id ' || l_payee_assignment_id);
1165: END IF;
1166:
1167: if l_payee_assignment_id is null OR x_status is null OR x_status <> 'S' then

Line 1174: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1170: end if;
1171:
1172: end loop;
1173:
1174: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1175: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1176: ' END assign_site_to_account ');
1177: END IF;
1178:

Line 1175: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1171:
1172: end loop;
1173:
1174: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1175: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1176: ' END assign_site_to_account ');
1177: END IF;
1178:
1179: EXCEPTION

Line 1199: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1195: l_step number;
1196: BEGIN
1197:
1198: l_step := 0;
1199: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1200: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1201: ' Begin prenote_iby_temp_account ');
1202: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1203: ' p_vendor_site_id ' || p_vendor_site_id);

Line 1200: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1196: BEGIN
1197:
1198: l_step := 0;
1199: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1200: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1201: ' Begin prenote_iby_temp_account ');
1202: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1203: ' p_vendor_site_id ' || p_vendor_site_id);
1204: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1202: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1198: l_step := 0;
1199: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1200: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1201: ' Begin prenote_iby_temp_account ');
1202: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1203: ' p_vendor_site_id ' || p_vendor_site_id);
1204: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1205: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1206: END IF;

Line 1204: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1200: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1201: ' Begin prenote_iby_temp_account ');
1202: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1203: ' p_vendor_site_id ' || p_vendor_site_id);
1204: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1205: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1206: END IF;
1207:
1208: -- Create/Update the account

Line 1224: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1220: , x_status => x_status
1221: , x_exception_msg => x_exception_msg
1222: );
1223:
1224: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1225: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1226: ' END prenote_iby_temp_account ');
1227: END IF;
1228:

Line 1225: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1221: , x_exception_msg => x_exception_msg
1222: );
1223:
1224: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1225: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1226: ' END prenote_iby_temp_account ');
1227: END IF;
1228:
1229: EXCEPTION

Line 1310: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1306: x_status := 'S';
1307:
1308: l_step := 0;
1309:
1310: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1312: ' BEGIN approve_iby_temp_account ');
1313: END IF;
1314:

Line 1311: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1307:
1308: l_step := 0;
1309:
1310: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1312: ' BEGIN approve_iby_temp_account ');
1313: END IF;
1314:
1315: for l_temp_account_rec in l_temp_account_cur loop

Line 1336: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1332: l_ext_bank_rec.institution_type := 'BANK';
1333: l_ext_bank_rec.country_code := l_temp_account_rec.country_code;
1334: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1335:
1336: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);

Line 1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1333: l_ext_bank_rec.country_code := l_temp_account_rec.country_code;
1334: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1335:
1336: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1335:
1336: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1342: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1342: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1344: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1342: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1344: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1342: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1344: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1349: END IF;

Line 1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1343: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1344: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1349: END IF;
1350:
1351: -- Create a bank

Line 1363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1359: x_msg_data => x_exception_msg,
1360: x_response => l_result_rec
1361: );
1362:
1363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);

Line 1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1360: x_response => l_result_rec
1361: );
1362:
1363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);
1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1362:
1363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);
1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1369: ' x_msg_count ' || l_msg_count);
1370: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);
1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1369: ' x_msg_count ' || l_msg_count);
1370: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1371: ' x_msg_data ' || x_exception_msg);
1372: END IF;

Line 1370: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);
1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1369: ' x_msg_count ' || l_msg_count);
1370: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1371: ' x_msg_data ' || x_exception_msg);
1372: END IF;
1373:
1374: if l_bank_id is null OR x_status <> 'S' then

Line 1413: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1409: l_ext_bank_branch_rec.alternate_branch_name := l_temp_account_rec.branch_name_alt;
1410: l_ext_bank_branch_rec.bic := l_temp_account_rec.bic;
1411: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1412:
1413: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);

Line 1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1410: l_ext_bank_branch_rec.bic := l_temp_account_rec.bic;
1411: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1412:
1413: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1412:
1413: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1419: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1419: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1421: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1422: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1419: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1421: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1422: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1423: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1424: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1422: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1419: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1421: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1422: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1423: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1424: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1425: ' l_ext_bank_branch_rec.alternate_branch_name '
1426: || l_ext_bank_branch_rec.alternate_branch_name);

Line 1424: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1420: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1421: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1422: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1423: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1424: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1425: ' l_ext_bank_branch_rec.alternate_branch_name '
1426: || l_ext_bank_branch_rec.alternate_branch_name);
1427: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1428: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );

Line 1427: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1423: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1424: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1425: ' l_ext_bank_branch_rec.alternate_branch_name '
1426: || l_ext_bank_branch_rec.alternate_branch_name);
1427: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1428: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );
1429: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1430: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1431: END IF;

Line 1429: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1425: ' l_ext_bank_branch_rec.alternate_branch_name '
1426: || l_ext_bank_branch_rec.alternate_branch_name);
1427: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1428: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );
1429: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1430: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1431: END IF;
1432:
1433: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (

Line 1444: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1440: x_msg_data => x_exception_msg,
1441: x_response => l_result_rec
1442: );
1443:
1444: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);

Line 1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1441: x_response => l_result_rec
1442: );
1443:
1444: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);
1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1443:
1444: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);
1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1450: ' x_msg_count ' || l_msg_count);
1451: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);
1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1450: ' x_msg_count ' || l_msg_count);
1451: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1452: ' x_msg_data ' || x_exception_msg);
1453: END IF;

Line 1451: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);
1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1450: ' x_msg_count ' || l_msg_count);
1451: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1452: ' x_msg_data ' || x_exception_msg);
1453: END IF;
1454:
1455: if l_branch_id is null OR x_status <> 'S' then

Line 1552: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1548: l_ext_bank_acct_rec.start_date := l_temp_account_rec.start_date;
1549: l_ext_bank_acct_rec.description := l_temp_account_rec.description;
1550:
1551:
1552: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);

Line 1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1549: l_ext_bank_acct_rec.description := l_temp_account_rec.description;
1550:
1551:
1552: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1551:
1552: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1558: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1558: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1560: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1558: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1560: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1562: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1558: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1560: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1562: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1564: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1559: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1560: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1562: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1564: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1566: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1562: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1564: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1566: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1563: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1564: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1566: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1565: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1566: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1574: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1574: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1576: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1574: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1576: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1578: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1573: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1574: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1576: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1578: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1580: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1581: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1575: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1576: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1578: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1580: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1581: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1582: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1581: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1577: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1578: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1580: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1581: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1582: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1585: || l_ext_bank_acct_rec.foreign_payment_use_flag);

Line 1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1579: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1580: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1581: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1582: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1585: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);

Line 1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1582: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1585: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1588: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1589: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
1590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1588: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1584: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1585: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1588: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1589: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
1590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1591: ' l_ext_bank_acct_rec.start_date ' || l_ext_bank_acct_rec.start_date);
1592: END IF;

Line 1590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1588: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1589: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
1590: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1591: ' l_ext_bank_acct_rec.start_date ' || l_ext_bank_acct_rec.start_date);
1592: END IF;
1593:
1594:

Line 1601: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1597: l_ext_bank_acct_rec.exchange_rate_agreement_num := l_temp_account_rec.exchange_rate_agreement_num;
1598: l_ext_bank_acct_rec.exchange_rate_agreement_type := l_temp_account_rec.exchange_rate_agreement_type;
1599: l_ext_bank_acct_rec.exchange_rate := l_temp_account_rec.exchange_rate;
1600:
1601: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1603: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1604: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1605: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1602: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1598: l_ext_bank_acct_rec.exchange_rate_agreement_type := l_temp_account_rec.exchange_rate_agreement_type;
1599: l_ext_bank_acct_rec.exchange_rate := l_temp_account_rec.exchange_rate;
1600:
1601: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1603: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1604: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1605: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1606: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '

Line 1605: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1601: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1603: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1604: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1605: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1606: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '
1607: || l_ext_bank_acct_rec.exchange_rate_agreement_type);
1608: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1609: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);

Line 1608: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1604: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1605: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1606: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '
1607: || l_ext_bank_acct_rec.exchange_rate_agreement_type);
1608: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1609: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1610: END IF;
1611:
1612: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1612: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1608: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1609: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1610: END IF;
1611:
1612: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1613: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1614: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1615: END IF;
1616:

Line 1613: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1609: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1610: END IF;
1611:
1612: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1613: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1614: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1615: END IF;
1616:
1617: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (

Line 1628: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1624: x_msg_data => x_exception_msg,
1625: x_response => l_result_rec
1626: );
1627:
1628: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);

Line 1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1625: x_response => l_result_rec
1626: );
1627:
1628: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);
1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1627:
1628: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);
1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1634: ' x_msg_count ' || l_msg_count);
1635: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);
1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1634: ' x_msg_count ' || l_msg_count);
1635: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1636: ' x_msg_data ' || x_exception_msg);
1637: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1635: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);
1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1634: ' x_msg_count ' || l_msg_count);
1635: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1636: ' x_msg_data ' || x_exception_msg);
1637: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1638: ' x_acct_id ' || l_ext_bank_account_id);
1639:

Line 1637: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1634: ' x_msg_count ' || l_msg_count);
1635: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1636: ' x_msg_data ' || x_exception_msg);
1637: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1638: ' x_acct_id ' || l_ext_bank_account_id);
1639:
1640: END IF;
1641:

Line 1648: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1644: END IF;
1645:
1646: else
1647:
1648: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1649: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1650: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1651: END IF;
1652:

Line 1649: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1645:
1646: else
1647:
1648: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1649: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1650: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1651: END IF;
1652:
1653: open l_cur_act_cur;

Line 1685: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1681: x_msg_data => x_exception_msg,
1682: x_response => l_result_rec
1683: );
1684:
1685: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);

Line 1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1682: x_response => l_result_rec
1683: );
1684:
1685: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);
1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1684:
1685: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);
1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1691: ' x_msg_count ' || l_msg_count);
1692: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

Line 1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);
1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1691: ' x_msg_count ' || l_msg_count);
1692: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1693: ' x_msg_data ' || x_exception_msg);
1694: END IF;

Line 1692: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);
1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1691: ' x_msg_count ' || l_msg_count);
1692: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1693: ' x_msg_data ' || x_exception_msg);
1694: END IF;
1695:
1696: IF x_status <> 'S' then

Line 1714: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1710: );
1711:
1712: end loop;
1713:
1714: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1715: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1716: ' End approve_iby_temp_account');
1717: END IF;
1718: EXCEPTION

Line 1715: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1711:
1712: end loop;
1713:
1714: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1715: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1716: ' End approve_iby_temp_account');
1717: END IF;
1718: EXCEPTION
1719: WHEN OTHERS THEN

Line 1879: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1875: BEGIN
1876:
1877: l_step := 0;
1878:
1879: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1880: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1881: ' Begin check_for_duplicates ');
1882: END IF;
1883:

Line 1880: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1876:
1877: l_step := 0;
1878:
1879: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1880: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1881: ' Begin check_for_duplicates ');
1882: END IF;
1883:
1884: x_need_validation := 'Y';

Line 1975: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1971: x_need_validation := 'N';
1972: end if;
1973: end if;
1974:
1975: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1976: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1977: ' End check_for_duplicates ');
1978: END IF;
1979:

Line 1976: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

1972: end if;
1973: end if;
1974:
1975: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1976: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1977: ' End check_for_duplicates ');
1978: END IF;
1979:
1980: EXCEPTION