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 815: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

946: x_msg_data => x_exception_msg,
947: x_response => l_result_rec
948: );
949:
950: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
951: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
952: ' IBY API Validation Status ' || x_status);
953: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
954: ' IBY API Validation msg count ' || l_msg_count);

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

947: x_response => l_result_rec
948: );
949:
950: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
951: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
952: ' IBY API Validation Status ' || x_status);
953: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
954: ' IBY API Validation msg count ' || l_msg_count);
955: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

949:
950: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
951: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
952: ' IBY API Validation Status ' || x_status);
953: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
954: ' IBY API Validation msg count ' || l_msg_count);
955: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
956: ' IBY API Validation exception msg ' || x_exception_msg);
957: END IF;

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

951: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
952: ' IBY API Validation Status ' || x_status);
953: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
954: ' IBY API Validation msg count ' || l_msg_count);
955: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
956: ' IBY API Validation exception msg ' || x_exception_msg);
957: END IF;
958:
959: l_step := 8;

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

959: l_step := 8;
960:
961: end if;
962:
963: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
964: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
965: ' End validate_account ');
966: END IF;
967:

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

960:
961: end if;
962:
963: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
964: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
965: ' End validate_account ');
966: END IF;
967:
968: EXCEPTION

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

1045:
1046: BEGIN
1047:
1048: l_step := 0;
1049: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1050: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1051: ' Begin assign_site_to_account ');
1052: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1053: ' p_vendor_site_id ' || p_vendor_site_id);

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

1046: BEGIN
1047:
1048: l_step := 0;
1049: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1050: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1051: ' Begin assign_site_to_account ');
1052: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1053: ' p_vendor_site_id ' || p_vendor_site_id);
1054: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1048: l_step := 0;
1049: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1050: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1051: ' Begin assign_site_to_account ');
1052: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1053: ' p_vendor_site_id ' || p_vendor_site_id);
1054: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1055: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1056: END IF;

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

1050: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1051: ' Begin assign_site_to_account ');
1052: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1053: ' p_vendor_site_id ' || p_vendor_site_id);
1054: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1055: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1056: END IF;
1057:
1058: l_step := 1;

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

1097: l_pay_assign_rec.End_Date := null;
1098:
1099: l_step := 6;
1100:
1101: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1102: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1103: ' Calling Set_Payee_Instr_Assignment ');
1104: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1105: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);

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

1098:
1099: l_step := 6;
1100:
1101: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1102: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1103: ' Calling Set_Payee_Instr_Assignment ');
1104: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1105: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1106: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1100:
1101: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1102: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1103: ' Calling Set_Payee_Instr_Assignment ');
1104: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1105: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1106: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1107: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1108: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1102: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1103: ' Calling Set_Payee_Instr_Assignment ');
1104: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1105: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1106: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1107: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1108: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1109: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1110: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1104: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1105: ' l_payee_rec.Party_id ' || l_payee_rec.Party_id);
1106: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1107: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1108: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1109: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1110: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1111: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1112: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1106: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1107: ' l_payee_rec.Payment_Function ' || l_payee_rec.Payment_Function);
1108: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1109: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1110: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1111: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1112: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1113: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1114: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1108: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1109: ' l_payee_rec.Supplier_Site_id ' || l_payee_rec.Supplier_Site_id);
1110: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1111: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1112: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1113: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1114: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1115: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1116: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1110: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1111: ' l_pay_instr_rec.Instrument_Type ' || l_pay_instr_rec.Instrument_Type);
1112: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1113: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1114: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1115: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1116: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1117: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1118: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1112: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1113: ' l_pay_instr_rec.Instrument_Id ' || l_pay_instr_rec.Instrument_Id);
1114: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1115: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1116: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1117: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1118: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1119: ' l_pay_assign_rec.End_Date ' || l_pay_assign_rec.End_Date);
1120: END IF;

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

1114: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1115: ' l_pay_assign_rec.Priority ' || l_pay_assign_rec.Priority);
1116: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1117: ' l_pay_assign_rec.Start_Date ' || l_pay_assign_rec.Start_Date );
1118: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1119: ' l_pay_assign_rec.End_Date ' || l_pay_assign_rec.End_Date);
1120: END IF;
1121:
1122: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(

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

1132: x_response => l_result_rec
1133: );
1134: l_step := 7;
1135:
1136: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1137: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1138: ' After Set_Payee_Instr_Assignment ');
1139: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1140: ' x_return_status ' || x_status);

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

1133: );
1134: l_step := 7;
1135:
1136: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1137: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1138: ' After Set_Payee_Instr_Assignment ');
1139: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1140: ' x_return_status ' || x_status);
1141: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1135:
1136: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1137: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1138: ' After Set_Payee_Instr_Assignment ');
1139: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1140: ' x_return_status ' || x_status);
1141: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1142: ' x_msg_count ' || l_msg_count);
1143: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1137: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1138: ' After Set_Payee_Instr_Assignment ');
1139: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1140: ' x_return_status ' || x_status);
1141: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1142: ' x_msg_count ' || l_msg_count);
1143: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1144: ' x_msg_data ' || x_exception_msg);
1145: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1139: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1140: ' x_return_status ' || x_status);
1141: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1142: ' x_msg_count ' || l_msg_count);
1143: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1144: ' x_msg_data ' || x_exception_msg);
1145: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1146: ' x_assign_id ' || l_payee_assignment_id);
1147: END IF;

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

1141: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1142: ' x_msg_count ' || l_msg_count);
1143: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1144: ' x_msg_data ' || x_exception_msg);
1145: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1146: ' x_assign_id ' || l_payee_assignment_id);
1147: END IF;
1148:
1149: if l_payee_assignment_id is null OR x_status is null OR x_status <> 'S' then

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

1152: end if;
1153:
1154: end loop;
1155:
1156: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' END assign_site_to_account ');
1159: END IF;
1160:

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

1153:
1154: end loop;
1155:
1156: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1157: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1158: ' END assign_site_to_account ');
1159: END IF;
1160:
1161: EXCEPTION

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

1177: l_step number;
1178: BEGIN
1179:
1180: l_step := 0;
1181: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1182: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1183: ' Begin prenote_iby_temp_account ');
1184: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1185: ' p_vendor_site_id ' || p_vendor_site_id);

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

1178: BEGIN
1179:
1180: l_step := 0;
1181: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1182: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1183: ' Begin prenote_iby_temp_account ');
1184: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1185: ' p_vendor_site_id ' || p_vendor_site_id);
1186: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1180: l_step := 0;
1181: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1182: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1183: ' Begin prenote_iby_temp_account ');
1184: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1185: ' p_vendor_site_id ' || p_vendor_site_id);
1186: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1187: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1188: END IF;

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

1182: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1183: ' Begin prenote_iby_temp_account ');
1184: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1185: ' p_vendor_site_id ' || p_vendor_site_id);
1186: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1187: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1188: END IF;
1189:
1190: -- Create/Update the account

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

1202: , x_status => x_status
1203: , x_exception_msg => x_exception_msg
1204: );
1205:
1206: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1207: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1208: ' END prenote_iby_temp_account ');
1209: END IF;
1210:

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

1203: , x_exception_msg => x_exception_msg
1204: );
1205:
1206: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1207: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1208: ' END prenote_iby_temp_account ');
1209: END IF;
1210:
1211: EXCEPTION

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

1287: x_status := 'S';
1288:
1289: l_step := 0;
1290:
1291: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1292: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1293: ' BEGIN approve_iby_temp_account ');
1294: END IF;
1295:

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

1288:
1289: l_step := 0;
1290:
1291: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1292: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1293: ' BEGIN approve_iby_temp_account ');
1294: END IF;
1295:
1296: for l_temp_account_rec in l_temp_account_cur loop

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

1313: l_ext_bank_rec.institution_type := 'BANK';
1314: l_ext_bank_rec.country_code := l_temp_account_rec.country_code;
1315: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1316:
1317: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1318: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);

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

1314: l_ext_bank_rec.country_code := l_temp_account_rec.country_code;
1315: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1316:
1317: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1318: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1316:
1317: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1318: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1323: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1324: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1318: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1323: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1324: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1325: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1326: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1323: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1324: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1325: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1326: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1327: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1328: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1323: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);
1324: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1325: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1326: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1327: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1328: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1329: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1330: END IF;

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

1324: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1325: ' l_ext_bank_rec.institution_type ' || l_ext_bank_rec.institution_type );
1326: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1327: ' l_ext_bank_rec.country_code ' || l_ext_bank_rec.country_code);
1328: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1329: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1330: END IF;
1331:
1332: -- Create a bank

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

1340: x_msg_data => x_exception_msg,
1341: x_response => l_result_rec
1342: );
1343:
1344: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);

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

1341: x_response => l_result_rec
1342: );
1343:
1344: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);
1349: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1343:
1344: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);
1349: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1350: ' x_msg_count ' || l_msg_count);
1351: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);
1349: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1350: ' x_msg_count ' || l_msg_count);
1351: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1352: ' x_msg_data ' || x_exception_msg);
1353: END IF;

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

1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);
1349: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1350: ' x_msg_count ' || l_msg_count);
1351: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1352: ' x_msg_data ' || x_exception_msg);
1353: END IF;
1354:
1355: if l_bank_id is null OR x_status <> 'S' then

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

1390: l_ext_bank_branch_rec.alternate_branch_name := l_temp_account_rec.branch_name_alt;
1391: l_ext_bank_branch_rec.bic := l_temp_account_rec.bic;
1392: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1393:
1394: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1395: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);

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

1391: l_ext_bank_branch_rec.bic := l_temp_account_rec.bic;
1392: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1393:
1394: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1395: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1393:
1394: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1395: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1400: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1401: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1395: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1400: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1401: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1402: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1403: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1400: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1401: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1402: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1403: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1404: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1405: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1400: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);
1401: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1402: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1403: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1404: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1405: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1406: ' l_ext_bank_branch_rec.alternate_branch_name '
1407: || l_ext_bank_branch_rec.alternate_branch_name);

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

1401: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1402: ' l_ext_bank_branch_rec.branch_number ' || l_ext_bank_branch_rec.branch_number);
1403: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1404: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1405: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1406: ' l_ext_bank_branch_rec.alternate_branch_name '
1407: || l_ext_bank_branch_rec.alternate_branch_name);
1408: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1409: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );

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

1404: ' l_ext_bank_branch_rec.branch_type ' || l_ext_bank_branch_rec.branch_type);
1405: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1406: ' l_ext_bank_branch_rec.alternate_branch_name '
1407: || l_ext_bank_branch_rec.alternate_branch_name);
1408: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1409: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );
1410: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1411: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1412: END IF;

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

1406: ' l_ext_bank_branch_rec.alternate_branch_name '
1407: || l_ext_bank_branch_rec.alternate_branch_name);
1408: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1409: ' l_ext_bank_branch_rec.bic ' || l_ext_bank_branch_rec.bic );
1410: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1411: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1412: END IF;
1413:
1414: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (

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

1421: x_msg_data => x_exception_msg,
1422: x_response => l_result_rec
1423: );
1424:
1425: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1426: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1427: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);

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

1422: x_response => l_result_rec
1423: );
1424:
1425: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1426: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1427: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);
1430: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1424:
1425: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1426: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1427: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);
1430: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1431: ' x_msg_count ' || l_msg_count);
1432: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1426: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1427: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);
1430: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1431: ' x_msg_count ' || l_msg_count);
1432: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1433: ' x_msg_data ' || x_exception_msg);
1434: END IF;

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

1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);
1430: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1431: ' x_msg_count ' || l_msg_count);
1432: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1433: ' x_msg_data ' || x_exception_msg);
1434: END IF;
1435:
1436: if l_branch_id is null OR x_status <> 'S' then

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

1529: l_ext_bank_acct_rec.start_date := l_temp_account_rec.start_date;
1530: l_ext_bank_acct_rec.description := l_temp_account_rec.description;
1531:
1532:
1533: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1534: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1535: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);

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

1530: l_ext_bank_acct_rec.description := l_temp_account_rec.description;
1531:
1532:
1533: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1534: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1535: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1532:
1533: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1534: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1535: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1539: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1540: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1534: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1535: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1539: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1540: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1541: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1542: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1539: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1540: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1541: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1542: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1543: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1544: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1539: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);
1540: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1541: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1542: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1543: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1544: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1545: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1546: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1540: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1541: ' l_ext_bank_acct_rec.branch_id ' || l_ext_bank_acct_rec.branch_id);
1542: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1543: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1544: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1545: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1546: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1547: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1548: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1542: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1543: ' l_ext_bank_acct_rec.bank_id ' || l_ext_bank_acct_rec.bank_id);
1544: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1545: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1546: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1547: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1548: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1549: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1550: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1544: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1545: ' l_ext_bank_acct_rec.acct_owner_party_id ' || l_ext_bank_acct_rec.acct_owner_party_id);
1546: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1547: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1548: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1549: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1550: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1551: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1552: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1546: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1547: ' l_ext_bank_acct_rec.bank_account_name ' || l_ext_bank_acct_rec.bank_account_name);
1548: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1549: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1550: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1551: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1552: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1553: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1548: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1549: ' l_ext_bank_acct_rec.bank_account_num ' || l_ext_bank_acct_rec.bank_account_num);
1550: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1551: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1552: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1553: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1555: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1556: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1550: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1551: ' l_ext_bank_acct_rec.currency ' || l_ext_bank_acct_rec.currency);
1552: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1553: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1555: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1556: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1557: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1558: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1552: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1553: ' l_ext_bank_acct_rec.iban ' || l_ext_bank_acct_rec.iban);
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1555: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1556: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1557: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1558: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1559: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1560: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1555: ' l_ext_bank_acct_rec.check_digits ' || l_ext_bank_acct_rec.check_digits);
1556: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1557: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1558: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1559: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1560: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1561: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1562: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1556: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1557: ' l_ext_bank_acct_rec.alternate_acct_name ' || l_ext_bank_acct_rec.alternate_acct_name);
1558: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1559: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1560: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1561: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1562: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1563: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1564: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1558: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1559: ' l_ext_bank_acct_rec.acct_type ' || l_ext_bank_acct_rec.acct_type);
1560: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1561: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1562: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1563: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1564: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1565: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1566: || l_ext_bank_acct_rec.foreign_payment_use_flag);

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

1560: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1561: ' l_ext_bank_acct_rec.acct_suffix ' || l_ext_bank_acct_rec.acct_suffix);
1562: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1563: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1564: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1565: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1566: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);

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

1563: ' l_ext_bank_acct_rec.agency_location_code ' || l_ext_bank_acct_rec.agency_location_code);
1564: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1565: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1566: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
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: ' l_ext_bank_acct_rec.foreign_payment_use_flag '
1566: || l_ext_bank_acct_rec.foreign_payment_use_flag);
1567: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1568: ' l_ext_bank_acct_rec.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.start_date ' || l_ext_bank_acct_rec.start_date);
1573: END IF;

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.payment_factor_flag ' || l_ext_bank_acct_rec.payment_factor_flag);
1569: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1570: ' l_ext_bank_acct_rec.end_date ' || l_ext_bank_acct_rec.end_date);
1571: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1572: ' l_ext_bank_acct_rec.start_date ' || l_ext_bank_acct_rec.start_date);
1573: END IF;
1574:
1575:

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

1578: l_ext_bank_acct_rec.exchange_rate_agreement_num := l_temp_account_rec.exchange_rate_agreement_num;
1579: l_ext_bank_acct_rec.exchange_rate_agreement_type := l_temp_account_rec.exchange_rate_agreement_type;
1580: l_ext_bank_acct_rec.exchange_rate := l_temp_account_rec.exchange_rate;
1581:
1582: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1585: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1579: l_ext_bank_acct_rec.exchange_rate_agreement_type := l_temp_account_rec.exchange_rate_agreement_type;
1580: l_ext_bank_acct_rec.exchange_rate := l_temp_account_rec.exchange_rate;
1581:
1582: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1585: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '

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

1582: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1583: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1584: ' l_ext_bank_acct_rec.exchange_rate_agreement_num '
1585: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '
1588: || l_ext_bank_acct_rec.exchange_rate_agreement_type);
1589: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1590: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);

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

1585: || l_ext_bank_acct_rec.exchange_rate_agreement_num);
1586: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1587: ' l_ext_bank_acct_rec.exchange_rate_agreement_type '
1588: || l_ext_bank_acct_rec.exchange_rate_agreement_type);
1589: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1590: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1591: END IF;
1592:
1593: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

1589: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1590: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1591: END IF;
1592:
1593: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1595: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1596: END IF;
1597:

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

1590: ' l_ext_bank_acct_rec.exchange_rate ' || l_ext_bank_acct_rec.exchange_rate);
1591: END IF;
1592:
1593: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1595: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1596: END IF;
1597:
1598: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (

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

1605: x_msg_data => x_exception_msg,
1606: x_response => l_result_rec
1607: );
1608:
1609: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1610: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1611: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);

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

1606: x_response => l_result_rec
1607: );
1608:
1609: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1610: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1611: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);
1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1608:
1609: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1610: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1611: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);
1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1615: ' x_msg_count ' || l_msg_count);
1616: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1610: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1611: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);
1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1615: ' x_msg_count ' || l_msg_count);
1616: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1617: ' x_msg_data ' || x_exception_msg);
1618: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);
1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1615: ' x_msg_count ' || l_msg_count);
1616: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1617: ' x_msg_data ' || x_exception_msg);
1618: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1619: ' x_acct_id ' || l_ext_bank_account_id);
1620:

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

1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1615: ' x_msg_count ' || l_msg_count);
1616: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1617: ' x_msg_data ' || x_exception_msg);
1618: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1619: ' x_acct_id ' || l_ext_bank_account_id);
1620:
1621: END IF;
1622:

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

1625: END IF;
1626:
1627: else
1628:
1629: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1630: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1631: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1632: END IF;
1633:

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

1626:
1627: else
1628:
1629: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1630: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1631: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1632: END IF;
1633:
1634: open l_cur_act_cur;

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

1646: x_msg_data => x_exception_msg,
1647: x_response => l_result_rec
1648: );
1649:
1650: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1651: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1652: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);

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

1647: x_response => l_result_rec
1648: );
1649:
1650: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1651: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1652: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);
1655: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1649:
1650: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1651: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1652: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);
1655: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1656: ' x_msg_count ' || l_msg_count);
1657: FND_LOG.string(fnd_log.level_statement, g_log_module_name,

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

1651: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1652: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);
1655: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1656: ' x_msg_count ' || l_msg_count);
1657: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1658: ' x_msg_data ' || x_exception_msg);
1659: END IF;

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

1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);
1655: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1656: ' x_msg_count ' || l_msg_count);
1657: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1658: ' x_msg_data ' || x_exception_msg);
1659: END IF;
1660:
1661: IF x_status <> 'S' then

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

1675: );
1676:
1677: end loop;
1678:
1679: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1680: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1681: ' End approve_iby_temp_account');
1682: END IF;
1683: EXCEPTION

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

1676:
1677: end loop;
1678:
1679: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1680: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1681: ' End approve_iby_temp_account');
1682: END IF;
1683: EXCEPTION
1684: WHEN OTHERS THEN

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

1840: BEGIN
1841:
1842: l_step := 0;
1843:
1844: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1846: ' Begin check_for_duplicates ');
1847: END IF;
1848:

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

1841:
1842: l_step := 0;
1843:
1844: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1845: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1846: ' Begin check_for_duplicates ');
1847: END IF;
1848:
1849: x_need_validation := 'Y';

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

1936: x_need_validation := 'N';
1937: end if;
1938: end if;
1939:
1940: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1941: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1942: ' End check_for_duplicates ');
1943: END IF;
1944:

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

1937: end if;
1938: end if;
1939:
1940: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1941: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1942: ' End check_for_duplicates ');
1943: END IF;
1944:
1945: EXCEPTION