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.AP_AUTOMATIC_PROPAGATION_PKG dependencies on FND_LOG

Line 101: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

97: P_org_id ap_invoices.org_id%TYPE DEFAULT NULL
98: ) RETURN NUMBER IS
99: l_affected_invoices NUMBER := 0;
100:
101: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
102: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
103: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP_AUTOMATIC_PROPAGATION_PKG';
104:
105: l_api_name VARCHAR2(100) := 'Get_Selected_Invoices_Count';

Line 102: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

98: ) RETURN NUMBER IS
99: l_affected_invoices NUMBER := 0;
100:
101: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
102: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
103: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP_AUTOMATIC_PROPAGATION_PKG';
104:
105: l_api_name VARCHAR2(100) := 'Get_Selected_Invoices_Count';
106: l_debug_info varchar2(3000);

Line 112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

108: BEGIN
109: -- Added debug messages for bug 10634847
110: l_debug_info := 'ENTER Get_Selected_Invoices_Count';
111: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
113: END IF;
114:
115: l_debug_info := 'P_org_Id :'||P_org_Id;
116: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

113: END IF;
114:
115: l_debug_info := 'P_org_Id :'||P_org_Id;
116: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
118: END IF;
119:
120: l_debug_info := 'p_vendor_id :'||p_vendor_id;
121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

118: END IF;
119:
120: l_debug_info := 'p_vendor_id :'||p_vendor_id;
121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
123: END IF;
124:
125:
126: l_debug_info := 'P_party_Site_Id :'||P_party_Site_Id;

Line 128: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

124:
125:
126: l_debug_info := 'P_party_Site_Id :'||P_party_Site_Id;
127: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
129: END IF;
130:
131: BEGIN
132: --Address + OU level checking

Line 203: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

199: WHEN OTHERS THEN
200: l_affected_invoices := 0;
201: l_debug_info := 'Exception occured in Get_Selected_Invoices_Count :'||SQLERRM;
202: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
204: END IF;
205: END;
206: RETURN l_affected_invoices;
207: END Get_Selected_Invoices_Count;

Line 220: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

216: P_party_id ap_suppliers.party_id%TYPE DEFAULT NULL -- Added for bug 9410719
217: ) IS
218:
219: -- Added for bug 9410719
220: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
221: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
222: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP_AUTOMATIC_PROPAGATION_PKG';
223:
224: l_api_name VARCHAR2(100) := 'Update_Payment_Schedules';

Line 221: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

217: ) IS
218:
219: -- Added for bug 9410719
220: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
221: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
222: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'AP_AUTOMATIC_PROPAGATION_PKG';
223:
224: l_api_name VARCHAR2(100) := 'Update_Payment_Schedules';
225: l_debug_info varchar2(3000);

Line 235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

231: BEGIN
232: -- Added debug messages for bug 9410719
233: l_debug_info := 'ENTER Update_Payment_Schedules';
234: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
236: END IF;
237:
238: l_debug_info := 'P_org_Id :'||P_org_Id;
239: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 240: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

236: END IF;
237:
238: l_debug_info := 'P_org_Id :'||P_org_Id;
239: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
240: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
241: END IF;
242:
243: l_debug_info := 'P_from_bank_account_id :'||p_from_bank_account_id;
244: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

241: END IF;
242:
243: l_debug_info := 'P_from_bank_account_id :'||p_from_bank_account_id;
244: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
246: END IF;
247:
248: l_debug_info := 'p_vendor_id :'||p_vendor_id;
249: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 250: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

246: END IF;
247:
248: l_debug_info := 'p_vendor_id :'||p_vendor_id;
249: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
251: END IF;
252:
253: l_debug_info := 'p_party_id :'||p_party_id;
254: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 255: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

251: END IF;
252:
253: l_debug_info := 'p_party_id :'||p_party_id;
254: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
255: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
256: END IF;
257:
258: l_debug_info := 'P_party_Site_Id :'||P_party_Site_Id;
259: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 260: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

256: END IF;
257:
258: l_debug_info := 'P_party_Site_Id :'||P_party_Site_Id;
259: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
261: END IF;
262:
263: l_debug_info := 'Calling IBY_DISBURSE_UI_API_PUB_PKG.intialize';
264: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

261: END IF;
262:
263: l_debug_info := 'Calling IBY_DISBURSE_UI_API_PUB_PKG.intialize';
264: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
266: END IF;
267:
268: IBY_DISBURSE_UI_API_PUB_PKG.initialize;
269:

Line 307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

303: );
304:
305: l_debug_info := '1. l_to_bank_account_id returned :'||p_to_bank_account_id;
306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
308: END IF;
309:
310:
311: UPDATE ap_payment_schedules_all aps

Line 352: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

348: EXCEPTION
349: WHEN OTHERS THEN
350: l_debug_info := 'Exception occured when party_site_id and org_id is not null :'||SQLERRM;
351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
352: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
353: END IF;
354: END;
355: END LOOP;
356:

Line 393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

389: );
390:
391: l_debug_info := '2. l_to_bank_account_id returned :'||p_to_bank_account_id;
392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
394: END IF;
395:
396: UPDATE ap_payment_schedules_all aps
397: SET aps.external_bank_account_id = l_to_bank_account_id,

Line 436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

432: EXCEPTION
433: WHEN OTHERS THEN
434: l_debug_info := 'Exception occured when party_site_id is not null :'||SQLERRM;
435: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
437: END IF;
438: END;
439: END LOOP;
440:

Line 470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

466: );
467:
468: l_debug_info := '3. l_to_bank_account_id returned :'||p_to_bank_account_id;
469: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
471: END IF;
472:
473: UPDATE ap_payment_schedules_all aps
474: SET aps.external_bank_account_id = l_to_bank_account_id,

Line 505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

501: EXCEPTION
502: WHEN OTHERS THEN
503: l_debug_info := 'Exception occured when vendor_site_id is not null :'||SQLERRM;
504: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
506: END IF;
507: END;
508: END LOOP;
509:

Line 538: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

534: );
535:
536: l_debug_info := '4. l_to_bank_account_id returned :'||p_to_bank_account_id;
537: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
539: END IF;
540:
541:
542: UPDATE ap_payment_schedules_all aps

Line 572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

568: EXCEPTION
569: WHEN OTHERS THEN
570: l_debug_info := 'Exception occured when vendor_id is not null :'||SQLERRM;
571: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
573: END IF;
574: END;
575: END LOOP;
576: END IF;

Line 580: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

576: END IF;
577: EXCEPTION WHEN OTHERS THEN
578: l_debug_info := 'Exception occured :'||SQLERRM;
579: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
581: END IF;
582:
583: END Update_Payment_Schedules;
584: