eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ORG_PAYMENT_METHOD_API dependencies on HR_UTILITY

Line 330: hr_utility.set_location('Entering:'|| l_proc, 10);

326: where external_account_id = v_external_account_id;
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Issue a savepoint
333: --
334: savepoint create_org_payment_method;

Line 349: hr_utility.set_location(l_proc, 20);

345: --
346: l_language_code := p_language_code;
347: hr_api.validate_language_code(p_language_code => l_language_code);
348: --
349: hr_utility.set_location(l_proc, 20);
350: --
351: -- Call Before Process User Hook
352: --
353: begin

Line 575: hr_utility.set_location(l_proc, 25);

571: ,p_hook_type => 'BP'
572: );
573: end;
574: --
575: hr_utility.set_location(l_proc, 25);
576: -- Validation in addition to Row Handlers
577: --
578: -- Process Logic
579: --

Line 599: hr_utility.set_location(l_proc, 30);

595: fnd_message.raise_error;
596: end if;
597: close csr_territory_code;
598: --
599: hr_utility.set_location(l_proc, 30);
600: IF (P_PMETH_INFORMATION1 IS NOT NULL OR
601: P_PMETH_INFORMATION2 IS NOT NULL OR
602: P_PMETH_INFORMATION3 IS NOT NULL OR
603: P_PMETH_INFORMATION4 IS NOT NULL OR

Line 632: hr_utility.set_location(l_proc, 35);

628: end if;
629: close csr_pmeth_category;
630: END IF;
631: --
632: hr_utility.set_location(l_proc, 35);
633: --
634: open csr_currency_code(p_payment_type_id);
635: fetch csr_currency_code into l_currency_code;
636: if (csr_currency_code%notfound) then

Line 647: hr_utility.set_location(l_proc, 40);

643: if (p_currency_code is not null) then
644: l_currency_code := p_currency_code;
645: end if;
646: --
647: hr_utility.set_location(l_proc, 40);
648: --
649: if (p_segment1 is not null or
650: p_segment2 is not null or
651: p_segment3 is not null or

Line 723: hr_utility.set_location(l_proc, 45);

719: end if;
720: --
721: -- Determine the Assest definition by calling ins_or_sel.
722: --
723: hr_utility.set_location(l_proc, 45);
724: l_set_of_books_id := p_sets_of_book_id;
725: l_gl_cash_ac_id := null;
726: l_gl_cash_clearing_ac_id := null;
727: l_gl_control_ac_id := null;

Line 822: hr_utility.set_location(l_proc, 50);

818: );
819: l_ASSET_CODE_COMBINATION_ID := l_gl_cash_ac_id;
820: --
821: end if;
822: hr_utility.set_location(l_proc, 50);
823: if (p_gl_ctrl_segment1 is not null or
824: p_gl_ctrl_segment2 is not null or
825: p_gl_ctrl_segment3 is not null or
826: p_gl_ctrl_segment4 is not null or

Line 894: hr_utility.set_location(l_proc, 55);

890: ,p_concat_segments_out => l_gl_control_concat_segment
891: );
892: --
893: end if;
894: hr_utility.set_location(l_proc, 55);
895: if (p_gl_ccrl_segment1 is not null or
896: p_gl_ccrl_segment2 is not null or
897: p_gl_ccrl_segment3 is not null or
898: p_gl_ccrl_segment4 is not null or

Line 966: hr_utility.set_location(l_proc, 60);

962: ,p_concat_segments_out => l_gl_csh_clr_concat_segment
963: );
964: --
965: end if;
966: hr_utility.set_location(l_proc, 60);
967: if (p_gl_err_segment1 is not null or
968: p_gl_err_segment2 is not null or
969: p_gl_err_segment3 is not null or
970: p_gl_err_segment4 is not null or

Line 1043: hr_utility.set_location(l_proc, 65);

1039: end if;
1040: --
1041: end if;
1042: --
1043: hr_utility.set_location(l_proc, 65);
1044: --
1045: -- Obtains the defined balance id based on the 3rd Party Payment Flag.
1046: --
1047: if (P_THIRD_PARTY_PAYMENT = 'Y') then

Line 1065: hr_utility.set_location(l_proc, 70);

1061: end if;
1062: close csr_def_balance;
1063: end if;
1064:
1065: hr_utility.set_location(l_proc, 70);
1066: --
1067: pay_opm_ins.ins
1068: (p_effective_date => l_effective_date
1069: ,p_business_group_id => p_business_group_id

Line 1130: hr_utility.set_location(l_proc, 75);

1126: ,p_effective_end_date => l_effective_end_date
1127: ,p_comment_id => l_comment_id
1128: );
1129: --
1130: hr_utility.set_location(l_proc, 75);
1131: --
1132: pay_opt_ins.ins_tl
1133: (p_language_code => l_language_code
1134: ,p_org_payment_method_id => l_org_payment_method_id

Line 1138: hr_utility.set_location(l_proc, 80);

1134: ,p_org_payment_method_id => l_org_payment_method_id
1135: ,p_org_payment_method_name => p_org_payment_method_name
1136: );
1137: --
1138: hr_utility.set_location(l_proc, 80);
1139: --
1140: hr_utility.set_location(l_proc, 85);
1141: if((L_DEFAULT_GL_ACCOUNT IS NULL OR L_DEFAULT_GL_ACCOUNT = 'N')
1142: and l_external_account_id is not null and

Line 1140: hr_utility.set_location(l_proc, 85);

1136: );
1137: --
1138: hr_utility.set_location(l_proc, 80);
1139: --
1140: hr_utility.set_location(l_proc, 85);
1141: if((L_DEFAULT_GL_ACCOUNT IS NULL OR L_DEFAULT_GL_ACCOUNT = 'N')
1142: and l_external_account_id is not null and
1143: PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS(l_external_account_id) is NULL ) then
1144: L_DEFAULT_GL_ACCOUNT := 'Y';

Line 1216: hr_utility.set_location(l_proc, 90);

1212: end if;
1213: --
1214: --Inserting the values into PAY_PAYMENT_GL_ACCOUNTS table.
1215:
1216: hr_utility.set_location(l_proc, 90);
1217: PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW (
1218: P_PAY_GL_ACCOUNT_ID => l_pay_gl_account_id,
1219: P_EFFECTIVE_START_DATE => l_effective_start_date,
1220: P_EFFECTIVE_END_DATE => l_effective_end_date,

Line 1230: hr_utility.set_location(l_proc, 95);

1226: P_EXTERNAL_ACCOUNT_ID => l_external_account_id,
1227: P_ORG_PAYMENT_METHOD_ID => l_org_payment_method_id,
1228: P_DEFAULT_GL_ACCOUNT => L_DEFAULT_GL_ACCOUNT);
1229: --
1230: hr_utility.set_location(l_proc, 95);
1231: --
1232: -- Call After Process User Hook
1233: --
1234: begin

Line 1479: hr_utility.set_location(' Leaving:'||l_proc, 100);

1475: p_effective_start_date := l_effective_start_date;
1476: p_effective_end_date := l_effective_end_date;
1477: p_asset_code_combination_id := l_asset_code_combination_id;
1478: --
1479: hr_utility.set_location(' Leaving:'||l_proc, 100);
1480: --
1481: exception
1482: when hr_api.validate_enabled then
1483: --

Line 1501: hr_utility.set_location(' Leaving:'||l_proc, 110);

1497: p_effective_start_date := null;
1498: p_effective_end_date := null;
1499: p_asset_code_combination_id := null;
1500: --
1501: hr_utility.set_location(' Leaving:'||l_proc, 110);
1502: when others then
1503: --
1504: -- A validation or unexpected error has occured
1505: --

Line 1507: hr_utility.set_location(' Leaving:'||l_proc, 120);

1503: --
1504: -- A validation or unexpected error has occured
1505: --
1506: rollback to create_org_payment_method;
1507: hr_utility.set_location(' Leaving:'||l_proc, 120);
1508: p_ORG_PAYMENT_METHOD_ID := null;
1509: p_object_version_number := null;
1510: p_comment_id := null;
1511: p_external_account_id := null;

Line 1843: hr_utility.set_location('Entering:'|| l_proc, 10);

1839: where org_payment_method_id = v_org_payment_method_id
1840: and v_effective_date between effective_start_date and effective_end_date;
1841: --
1842: begin
1843: hr_utility.set_location('Entering:'|| l_proc, 10);
1844: l_copy_ov_number := p_object_version_number;
1845: l_gl_cash_ac_id := null;
1846: l_gl_cash_clearing_ac_id := null;
1847: l_gl_control_ac_id := null;

Line 1908: hr_utility.set_location(l_proc, 20);

1904: --
1905: l_language_code := p_language_code;
1906: hr_api.validate_language_code(p_language_code => l_language_code);
1907: --
1908: hr_utility.set_location(l_proc, 20);
1909: --
1910: -- Call Before Process User Hook
1911: --
1912: begin

Line 2147: hr_utility.set_location('Before determining the external A/C id : ' ||l_proc, 25);

2143: -- Call table handler pay_exa_upd to control the processing of the external
2144: -- account combination keyflex, discarding the returning parameter
2145: -- p_object_version_number
2146: --
2147: hr_utility.set_location('Before determining the external A/C id : ' ||l_proc, 25);
2148: if ((P_SEGMENT1 <> hr_api.g_varchar2) OR
2149: (P_SEGMENT2 <> hr_api.g_varchar2) OR
2150: (P_SEGMENT3 <> hr_api.g_varchar2) OR
2151: (P_SEGMENT4 <> hr_api.g_varchar2) OR

Line 2273: hr_utility.set_location(l_proc, 30);

2269: --
2270: --
2271: end if;
2272: --
2273: hr_utility.set_location(l_proc, 30);
2274: --
2275: -- Determine the Assest definition by calling upd_or_sel.
2276: --
2277: --

Line 2311: hr_utility.set_location('Before Determining cash A/C id : '||l_proc, 35);

2307: --
2308: end if;
2309: --
2310: end if;
2311: hr_utility.set_location('Before Determining cash A/C id : '||l_proc, 35);
2312: if (l_set_of_books_id is not null) then
2313: --
2314: if ((P_GL_SEGMENT1 <> hr_api.g_varchar2) OR
2315: (P_GL_SEGMENT2 <> hr_api.g_varchar2) OR

Line 2400: hr_utility.set_location('Before Determining Control A/C id : '||l_proc, 40);

2396: end if;
2397: --
2398: end if; --For GL Segments.
2399: --
2400: hr_utility.set_location('Before Determining Control A/C id : '||l_proc, 40);
2401: --
2402: if ((P_GL_CTRL_SEGMENT1 <> hr_api.g_varchar2) OR
2403: (P_GL_CTRL_SEGMENT2 <> hr_api.g_varchar2) OR
2404: (P_GL_CTRL_SEGMENT3 <> hr_api.g_varchar2) OR

Line 2479: hr_utility.set_location('Before Determining Cash Clearing A/C id : '||l_proc, 45);

2475: end if;
2476: --
2477: end if;
2478: --
2479: hr_utility.set_location('Before Determining Cash Clearing A/C id : '||l_proc, 45);
2480: --
2481: if ((P_GL_CCRL_SEGMENT1 <> hr_api.g_varchar2) OR
2482: (P_GL_CCRL_SEGMENT2 <> hr_api.g_varchar2) OR
2483: (P_GL_CCRL_SEGMENT3 <> hr_api.g_varchar2) OR

Line 2558: hr_utility.set_location('Before Determining Error A/C id : '||l_proc, 50);

2554: end if;
2555: --
2556: end if;
2557: --
2558: hr_utility.set_location('Before Determining Error A/C id : '||l_proc, 50);
2559: --
2560: if ((P_GL_ERR_SEGMENT1 <> hr_api.g_varchar2) OR
2561: (P_GL_ERR_SEGMENT2 <> hr_api.g_varchar2) OR
2562: (P_GL_ERR_SEGMENT3 <> hr_api.g_varchar2) OR

Line 2654: hr_utility.set_location('Validation for Sychrinizing A/Cids with flags : '||l_proc, 55);

2650: if (p_currency_code is not null) then
2651: l_currency_code := p_currency_code;
2652: end if;
2653: --
2654: hr_utility.set_location('Validation for Sychrinizing A/Cids with flags : '||l_proc, 55);
2655: -- Validation for the cost and cost cleared payments.
2656: -- If the cost cleared payment is set to 'Y' then all the Cash, Cash Clearing,
2657: -- Control and Error A/Cs should be specified.
2658: -- If the cost cleared or cost payment is set then Cash and Cash Clearing A/Cs

Line 2699: hr_utility.set_location('Before Row Handler of OPM : '||l_proc, 60);

2695: fnd_message.set_name('PAY', 'PAY_33421_INV_CST_IDS');
2696: fnd_message.raise_error;
2697: end if;
2698: --
2699: hr_utility.set_location('Before Row Handler of OPM : '||l_proc, 60);
2700: --
2701: pay_opm_upd.upd
2702: (p_effective_date => l_effective_date
2703: ,p_datetrack_mode => p_datetrack_update_mode

Line 2767: hr_utility.set_location('Before Updating Bank Accounts : '||l_proc, 65);

2763: ,p_org_payment_method_id => p_org_payment_method_id
2764: ,p_org_payment_method_name => p_org_payment_method_name
2765: );
2766: --
2767: hr_utility.set_location('Before Updating Bank Accounts : '||l_proc, 65);
2768: -- Updating the ap_bank_accounts_all
2769: if (pay_ce_support_pkg.pay_and_ce_licensed) then
2770: --
2771:

Line 2813: hr_utility.set_location('Before Updating GL Accounts : '||l_proc, 70);

2809: end if;
2810: --
2811: end if;
2812:
2813: hr_utility.set_location('Before Updating GL Accounts : '||l_proc, 70);
2814: PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW
2815: ( P_EFFECTIVE_START_DATE => l_effective_start_date,
2816: P_EFFECTIVE_END_DATE => l_effective_end_date,
2817: P_SET_OF_BOOKS_ID => l_set_of_books_id,

Line 3075: hr_utility.set_location(' Leaving:'||l_proc, 75);

3071: p_effective_start_date := l_effective_start_date;
3072: p_effective_end_date := l_effective_end_date;
3073: p_asset_code_combination_id := l_asset_code_combination_id;
3074: --
3075: hr_utility.set_location(' Leaving:'||l_proc, 75);
3076: hr_utility.trace_off;
3077: exception
3078: when hr_api.validate_enabled then
3079: --

Line 3076: hr_utility.trace_off;

3072: p_effective_end_date := l_effective_end_date;
3073: p_asset_code_combination_id := l_asset_code_combination_id;
3074: --
3075: hr_utility.set_location(' Leaving:'||l_proc, 75);
3076: hr_utility.trace_off;
3077: exception
3078: when hr_api.validate_enabled then
3079: --
3080: -- As the Validate_Enabled exception has been raised

Line 3095: hr_utility.set_location(' Leaving:'||l_proc, 80);

3091: p_effective_start_date := null;
3092: p_effective_end_date := null;
3093: p_asset_code_combination_id := null;
3094: --
3095: hr_utility.set_location(' Leaving:'||l_proc, 80);
3096: when others then
3097: --
3098: -- A validation or unexpected error has occured
3099: --

Line 3107: hr_utility.set_location(' Leaving:'||l_proc, 90);

3103: p_effective_start_date := null;
3104: p_effective_end_date := null;
3105: p_asset_code_combination_id := null;
3106: p_object_version_number := l_copy_ov_number;
3107: hr_utility.set_location(' Leaving:'||l_proc, 90);
3108: raise;
3109: end update_org_payment_method;
3110: --
3111: --

Line 3137: hr_utility.set_location('Entering:'|| l_proc, 5);

3133: l_copy_ov_number number;
3134: --
3135: --
3136: begin
3137: hr_utility.set_location('Entering:'|| l_proc, 5);
3138: l_copy_ov_number := p_object_version_number;
3139: --
3140: -- Issue a savepoint if operating in validation only mode.
3141: --

Line 3167: hr_utility.set_location(l_proc, 7);

3163: );
3164: end;
3165: --
3166: --
3167: hr_utility.set_location(l_proc, 7);
3168: --
3169: -- Process Logic
3170: --
3171: if (p_datetrack_delete_mode = hr_api.g_zap) then

Line 3175: hr_utility.set_location( l_proc, 30);

3171: if (p_datetrack_delete_mode = hr_api.g_zap) then
3172: --
3173: -- Need to lock main table to maintain the locking ladder order
3174: --
3175: hr_utility.set_location( l_proc, 30);
3176: --
3177: pay_opm_shd.lck
3178: (p_effective_date => l_effective_date
3179: ,p_datetrack_mode => p_datetrack_delete_mode

Line 3188: hr_utility.set_location( l_proc, 35);

3184: );
3185: --
3186: -- Remove all matching translation rows
3187: --
3188: hr_utility.set_location( l_proc, 35);
3189: --
3190: pay_opt_del.del_tl
3191: (P_ORG_PAYMENT_METHOD_ID => P_ORG_PAYMENT_METHOD_ID
3192: );

Line 3198: hr_utility.set_location( l_proc, 40);

3194: end if;
3195: --
3196: -- Remove non-translated data row
3197: --
3198: hr_utility.set_location( l_proc, 40);
3199: --
3200: pay_opm_del.del
3201: (p_effective_date => l_effective_date
3202: ,p_datetrack_mode => P_DATETRACK_DELETE_MODE

Line 3217: hr_utility.set_location( l_proc, 45);

3213: --Bug No. 4644827
3214: pay_maintain_bank_acct.remove_redundant_bank_detail;
3215: end if;
3216: --
3217: hr_utility.set_location( l_proc, 45);
3218: PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW (
3219: p_org_payment_method_id => p_org_payment_method_id
3220: ,p_effective_date => l_effective_date
3221: ,p_datetrack_mode => P_DATETRACK_DELETE_MODE

Line 3225: hr_utility.set_location(l_proc, 20);

3221: ,p_datetrack_mode => P_DATETRACK_DELETE_MODE
3222: ,p_org_eff_start_date => l_effective_start_date
3223: ,p_org_eff_end_date => l_effective_end_date);
3224: --
3225: hr_utility.set_location(l_proc, 20);
3226: --
3227: --
3228: -- Call After Process User Hook
3229: --

Line 3259: hr_utility.set_location(' Leaving:'||l_proc, 21);

3255: p_object_version_number := l_object_version_number;
3256: p_effective_start_date := l_effective_start_date;
3257: p_effective_end_date := l_effective_end_date;
3258: --
3259: hr_utility.set_location(' Leaving:'||l_proc, 21);
3260: exception
3261: when hr_api.validate_enabled then
3262: --
3263: -- As the Validate_Enabled exception has been raised

Line 3268: hr_utility.set_location(' Leaving:'||l_proc, 22);

3264: -- we must rollback to the savepoint
3265: --
3266: ROLLBACK TO delete_org_payment_method;
3267: --
3268: hr_utility.set_location(' Leaving:'||l_proc, 22);
3269: --
3270: when others then
3271: --
3272: --