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

Line 331: ----------------------- FND Logging -----------------------------------

327:
328: -- Initialize API return status to SUCCESS
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: ----------------------- FND Logging -----------------------------------
332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
333: THEN
334: FND_LOG.String
335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

328: -- Initialize API return status to SUCCESS
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: ----------------------- FND Logging -----------------------------------
332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
333: THEN
334: FND_LOG.String
335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
336: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 334: FND_LOG.String

330:
331: ----------------------- FND Logging -----------------------------------
332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
333: THEN
334: FND_LOG.String
335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
336: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
337: );
338: FND_LOG.String

Line 335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

331: ----------------------- FND Logging -----------------------------------
332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
333: THEN
334: FND_LOG.String
335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
336: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
337: );
338: FND_LOG.String
339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 338: FND_LOG.String

334: FND_LOG.String
335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
336: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
337: );
338: FND_LOG.String
339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
340: , 'P_Api_Version_Number:' || P_Api_Version_Number
341: );
342: FND_LOG.String

Line 339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

335: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
336: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
337: );
338: FND_LOG.String
339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
340: , 'P_Api_Version_Number:' || P_Api_Version_Number
341: );
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 342: FND_LOG.String

338: FND_LOG.String
339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
340: , 'P_Api_Version_Number:' || P_Api_Version_Number
341: );
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
344: , 'p_init_msg_list:' || p_init_msg_list
345: );
346: FND_LOG.String

Line 343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

339: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
340: , 'P_Api_Version_Number:' || P_Api_Version_Number
341: );
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
344: , 'p_init_msg_list:' || p_init_msg_list
345: );
346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 346: FND_LOG.String

342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
344: , 'p_init_msg_list:' || p_init_msg_list
345: );
346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'p_commit:' || p_commit
349: );
350: FND_LOG.String

Line 347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

343: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
344: , 'p_init_msg_list:' || p_init_msg_list
345: );
346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'p_commit:' || p_commit
349: );
350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 350: FND_LOG.String

346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'p_commit:' || p_commit
349: );
350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: ,'incident_id :' || p_sbe_record.incident_id
353: );
354: FND_LOG.String

Line 351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'p_commit:' || p_commit
349: );
350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: ,'incident_id :' || p_sbe_record.incident_id
353: );
354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 354: FND_LOG.String

350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: ,'incident_id :' || p_sbe_record.incident_id
353: );
354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: ,'business_process_id :' || p_sbe_record.business_process_id
357: );
358: FND_LOG.String

Line 355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: ,'incident_id :' || p_sbe_record.incident_id
353: );
354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: ,'business_process_id :' || p_sbe_record.business_process_id
357: );
358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 358: FND_LOG.String

354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: ,'business_process_id :' || p_sbe_record.business_process_id
357: );
358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
361: );
362: FND_LOG.String

Line 359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: ,'business_process_id :' || p_sbe_record.business_process_id
357: );
358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
361: );
362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 362: FND_LOG.String

358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
361: );
362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
365: );
366: FND_LOG.String

Line 363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
361: );
362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
365: );
366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 366: FND_LOG.String

362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
365: );
366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'line_category_code :' || p_sbe_record.line_category_code
369: );
370: FND_LOG.String

Line 367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
365: );
366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'line_category_code :' || p_sbe_record.line_category_code
369: );
370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 370: FND_LOG.String

366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'line_category_code :' || p_sbe_record.line_category_code
369: );
370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'contract_id :' || p_sbe_record.contract_id
373: );
374: FND_LOG.String

Line 371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'line_category_code :' || p_sbe_record.line_category_code
369: );
370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'contract_id :' || p_sbe_record.contract_id
373: );
374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 374: FND_LOG.String

370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'contract_id :' || p_sbe_record.contract_id
373: );
374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'contract_line_id :' || p_sbe_record.contract_line_id
377: );
378: FND_LOG.String

Line 375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'contract_id :' || p_sbe_record.contract_id
373: );
374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'contract_line_id :' || p_sbe_record.contract_line_id
377: );
378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 378: FND_LOG.String

374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'contract_line_id :' || p_sbe_record.contract_line_id
377: );
378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'price_list_id :' || p_sbe_record.price_list_id
381: );
382: FND_LOG.String

Line 379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'contract_line_id :' || p_sbe_record.contract_line_id
377: );
378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'price_list_id :' || p_sbe_record.price_list_id
381: );
382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 382: FND_LOG.String

378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'price_list_id :' || p_sbe_record.price_list_id
381: );
382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'currency_code :' || p_sbe_record.currency_code
385: );
386: FND_LOG.String

Line 383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'price_list_id :' || p_sbe_record.price_list_id
381: );
382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'currency_code :' || p_sbe_record.currency_code
385: );
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 386: FND_LOG.String

382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'currency_code :' || p_sbe_record.currency_code
385: );
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'service_date :' || p_sbe_record.service_date
389: );
390: FND_LOG.String

Line 387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'currency_code :' || p_sbe_record.currency_code
385: );
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'service_date :' || p_sbe_record.service_date
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 390: FND_LOG.String

386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'service_date :' || p_sbe_record.service_date
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
393: );
394: FND_LOG.String

Line 391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'service_date :' || p_sbe_record.service_date
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 394: FND_LOG.String

390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
397: );
398: FND_LOG.String

Line 395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 398: FND_LOG.String

394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
401: );
402: FND_LOG.String

Line 399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
401: );
402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 402: FND_LOG.String

398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
401: );
402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'serial_number :' || p_sbe_record.serial_number
405: );
406: FND_LOG.String

Line 403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
401: );
402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'serial_number :' || p_sbe_record.serial_number
405: );
406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 406: FND_LOG.String

402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'serial_number :' || p_sbe_record.serial_number
405: );
406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'item_revision :' || p_sbe_record.item_revision
409: );
410: FND_LOG.String

Line 407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'serial_number :' || p_sbe_record.serial_number
405: );
406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'item_revision :' || p_sbe_record.item_revision
409: );
410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 410: FND_LOG.String

406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'item_revision :' || p_sbe_record.item_revision
409: );
410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
413: );
414: FND_LOG.String

Line 411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'item_revision :' || p_sbe_record.item_revision
409: );
410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
413: );
414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 414: FND_LOG.String

410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
413: );
414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'quantity :' || p_sbe_record.quantity
417: );
418: FND_LOG.String

Line 415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
413: );
414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'quantity :' || p_sbe_record.quantity
417: );
418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 418: FND_LOG.String

414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'quantity :' || p_sbe_record.quantity
417: );
418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
421: );
422: FND_LOG.String

Line 419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'quantity :' || p_sbe_record.quantity
417: );
418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
421: );
422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 422: FND_LOG.String

418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
421: );
422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'return_reason_code :' || p_sbe_record.return_reason_code
425: );
426: FND_LOG.String

Line 423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
421: );
422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'return_reason_code :' || p_sbe_record.return_reason_code
425: );
426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 426: FND_LOG.String

422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'return_reason_code :' || p_sbe_record.return_reason_code
425: );
426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
429: );
430: FND_LOG.String

Line 427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'return_reason_code :' || p_sbe_record.return_reason_code
425: );
426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
429: );
430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 430: FND_LOG.String

426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
429: );
430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'customer_product_id :' || p_sbe_record.customer_product_id
433: );
434: FND_LOG.String

Line 431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
429: );
430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'customer_product_id :' || p_sbe_record.customer_product_id
433: );
434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 434: FND_LOG.String

430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'customer_product_id :' || p_sbe_record.customer_product_id
433: );
434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
437: );
438: FND_LOG.String

Line 435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'customer_product_id :' || p_sbe_record.customer_product_id
433: );
434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
437: );
438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 438: FND_LOG.String

434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
437: );
438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
441: );
442: FND_LOG.String

Line 439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
437: );
438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
441: );
442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 442: FND_LOG.String

438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
441: );
442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'original_source_id :' || p_sbe_record.original_source_id
445: );
446: FND_LOG.String

Line 443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
441: );
442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'original_source_id :' || p_sbe_record.original_source_id
445: );
446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 446: FND_LOG.String

442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'original_source_id :' || p_sbe_record.original_source_id
445: );
446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'original_source_code :' || p_sbe_record.original_source_code
449: );
450: FND_LOG.String

Line 447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'original_source_id :' || p_sbe_record.original_source_id
445: );
446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'original_source_code :' || p_sbe_record.original_source_code
449: );
450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 450: FND_LOG.String

446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'original_source_code :' || p_sbe_record.original_source_code
449: );
450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'source_id :' || p_sbe_record.source_id
453: );
454: FND_LOG.String

Line 451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'original_source_code :' || p_sbe_record.original_source_code
449: );
450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'source_id :' || p_sbe_record.source_id
453: );
454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 454: FND_LOG.String

450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'source_id :' || p_sbe_record.source_id
453: );
454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'source_code :' || p_sbe_record.source_code
457: );
458: FND_LOG.String

Line 455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'source_id :' || p_sbe_record.source_id
453: );
454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'source_code :' || p_sbe_record.source_code
457: );
458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 458: FND_LOG.String

454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'source_code :' || p_sbe_record.source_code
457: );
458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: , 'p_final_charge_flag:' || p_final_charge_flag
461: );
462: END IF;

Line 459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'source_code :' || p_sbe_record.source_code
457: );
458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: , 'p_final_charge_flag:' || p_final_charge_flag
461: );
462: END IF;
463:

Line 464: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

460: , 'p_final_charge_flag:' || p_final_charge_flag
461: );
462: END IF;
463:
464: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
465: THEN
466: FND_LOG.String
467: ( FND_LOG.level_statement
468: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')

Line 466: FND_LOG.String

462: END IF;
463:
464: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
465: THEN
466: FND_LOG.String
467: ( FND_LOG.level_statement
468: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
469: );
470: FND_LOG.String

Line 467: ( FND_LOG.level_statement

463:
464: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
465: THEN
466: FND_LOG.String
467: ( FND_LOG.level_statement
468: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
469: );
470: FND_LOG.String
471: ( FND_LOG.level_statement

Line 470: FND_LOG.String

466: FND_LOG.String
467: ( FND_LOG.level_statement
468: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
469: );
470: FND_LOG.String
471: ( FND_LOG.level_statement
472: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
473: );
474: FND_LOG.String

Line 471: ( FND_LOG.level_statement

467: ( FND_LOG.level_statement
468: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
469: );
470: FND_LOG.String
471: ( FND_LOG.level_statement
472: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
473: );
474: FND_LOG.String
475: ( FND_LOG.level_statement

Line 474: FND_LOG.String

470: FND_LOG.String
471: ( FND_LOG.level_statement
472: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
473: );
474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
477: );
478: FND_LOG.String

Line 475: ( FND_LOG.level_statement

471: ( FND_LOG.level_statement
472: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
473: );
474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
477: );
478: FND_LOG.String
479: ( FND_LOG.level_statement

Line 478: FND_LOG.String

474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
477: );
478: FND_LOG.String
479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
481: );
482: FND_LOG.String

Line 479: ( FND_LOG.level_statement

475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
477: );
478: FND_LOG.String
479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
481: );
482: FND_LOG.String
483: ( FND_LOG.level_statement

Line 482: FND_LOG.String

478: FND_LOG.String
479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
481: );
482: FND_LOG.String
483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
485: );
486: FND_LOG.String

Line 483: ( FND_LOG.level_statement

479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
481: );
482: FND_LOG.String
483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
485: );
486: FND_LOG.String
487: ( FND_LOG.level_statement

Line 486: FND_LOG.String

482: FND_LOG.String
483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
485: );
486: FND_LOG.String
487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
489: );
490: FND_LOG.String

Line 487: ( FND_LOG.level_statement

483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
485: );
486: FND_LOG.String
487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
489: );
490: FND_LOG.String
491: ( FND_LOG.level_statement

Line 490: FND_LOG.String

486: FND_LOG.String
487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
489: );
490: FND_LOG.String
491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
493: );
494: FND_LOG.String

Line 491: ( FND_LOG.level_statement

487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
489: );
490: FND_LOG.String
491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
493: );
494: FND_LOG.String
495: ( FND_LOG.level_statement

Line 494: FND_LOG.String

490: FND_LOG.String
491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
493: );
494: FND_LOG.String
495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
497: );
498: FND_LOG.String

Line 495: ( FND_LOG.level_statement

491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
493: );
494: FND_LOG.String
495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
497: );
498: FND_LOG.String
499: ( FND_LOG.level_statement

Line 498: FND_LOG.String

494: FND_LOG.String
495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
497: );
498: FND_LOG.String
499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
501: );
502: FND_LOG.String

Line 499: ( FND_LOG.level_statement

495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
497: );
498: FND_LOG.String
499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
501: );
502: FND_LOG.String
503: ( FND_LOG.level_statement

Line 502: FND_LOG.String

498: FND_LOG.String
499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
501: );
502: FND_LOG.String
503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
505: );
506: FND_LOG.String

Line 503: ( FND_LOG.level_statement

499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
501: );
502: FND_LOG.String
503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
505: );
506: FND_LOG.String
507: ( FND_LOG.level_statement

Line 506: FND_LOG.String

502: FND_LOG.String
503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
505: );
506: FND_LOG.String
507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.labor_start_date_time = ' || TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
509: );
510: FND_LOG.String

Line 507: ( FND_LOG.level_statement

503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
505: );
506: FND_LOG.String
507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.labor_start_date_time = ' || TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
509: );
510: FND_LOG.String
511: ( FND_LOG.level_statement

Line 510: FND_LOG.String

506: FND_LOG.String
507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.labor_start_date_time = ' || TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
509: );
510: FND_LOG.String
511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.labor_end_date_time = ' || TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
513: );
514: FND_LOG.String

Line 511: ( FND_LOG.level_statement

507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.labor_start_date_time = ' || TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
509: );
510: FND_LOG.String
511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.labor_end_date_time = ' || TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
513: );
514: FND_LOG.String
515: ( FND_LOG.level_statement

Line 514: FND_LOG.String

510: FND_LOG.String
511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.labor_end_date_time = ' || TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
513: );
514: FND_LOG.String
515: ( FND_LOG.level_statement
516: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
517: );
518: FND_LOG.String

Line 515: ( FND_LOG.level_statement

511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.labor_end_date_time = ' || TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
513: );
514: FND_LOG.String
515: ( FND_LOG.level_statement
516: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
517: );
518: FND_LOG.String
519: ( FND_LOG.level_statement

Line 518: FND_LOG.String

514: FND_LOG.String
515: ( FND_LOG.level_statement
516: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
517: );
518: FND_LOG.String
519: ( FND_LOG.level_statement
520: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
521: );
522: FND_LOG.String

Line 519: ( FND_LOG.level_statement

515: ( FND_LOG.level_statement
516: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
517: );
518: FND_LOG.String
519: ( FND_LOG.level_statement
520: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
521: );
522: FND_LOG.String
523: ( FND_LOG.level_statement

Line 522: FND_LOG.String

518: FND_LOG.String
519: ( FND_LOG.level_statement
520: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
521: );
522: FND_LOG.String
523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
525: );
526: FND_LOG.String

Line 523: ( FND_LOG.level_statement

519: ( FND_LOG.level_statement
520: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
521: );
522: FND_LOG.String
523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
525: );
526: FND_LOG.String
527: ( FND_LOG.level_statement

Line 526: FND_LOG.String

522: FND_LOG.String
523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
525: );
526: FND_LOG.String
527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
529: );
530: FND_LOG.String

Line 527: ( FND_LOG.level_statement

523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
525: );
526: FND_LOG.String
527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
529: );
530: FND_LOG.String
531: ( FND_LOG.level_statement

Line 530: FND_LOG.String

526: FND_LOG.String
527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
529: );
530: FND_LOG.String
531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_final_charge_flag = ' || p_final_charge_flag
533: );
534: END IF;

Line 531: ( FND_LOG.level_statement

527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
529: );
530: FND_LOG.String
531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_final_charge_flag = ' || p_final_charge_flag
533: );
534: END IF;
535:

Line 658: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

654: l_charges_rec.transaction_inventory_org := p_sbe_record.transaction_inventory_org_id;
655: l_charges_rec.transaction_sub_inventory := p_sbe_record.transaction_sub_inventory;
656:
657:
658: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
659: THEN
660: FND_LOG.String
661: ( FND_LOG.level_statement
662: , L_LOG_MODULE, 'l_charges_rec.contract_id = ' || l_charges_rec.contract_id

Line 660: FND_LOG.String

656:
657:
658: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
659: THEN
660: FND_LOG.String
661: ( FND_LOG.level_statement
662: , L_LOG_MODULE, 'l_charges_rec.contract_id = ' || l_charges_rec.contract_id
663: );
664: FND_LOG.String

Line 661: ( FND_LOG.level_statement

657:
658: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
659: THEN
660: FND_LOG.String
661: ( FND_LOG.level_statement
662: , L_LOG_MODULE, 'l_charges_rec.contract_id = ' || l_charges_rec.contract_id
663: );
664: FND_LOG.String
665: ( FND_LOG.level_statement

Line 664: FND_LOG.String

660: FND_LOG.String
661: ( FND_LOG.level_statement
662: , L_LOG_MODULE, 'l_charges_rec.contract_id = ' || l_charges_rec.contract_id
663: );
664: FND_LOG.String
665: ( FND_LOG.level_statement
666: , L_LOG_MODULE, 'l_charges_rec.coverage_id = ' || l_charges_rec.coverage_id
667: );
668: FND_LOG.String

Line 665: ( FND_LOG.level_statement

661: ( FND_LOG.level_statement
662: , L_LOG_MODULE, 'l_charges_rec.contract_id = ' || l_charges_rec.contract_id
663: );
664: FND_LOG.String
665: ( FND_LOG.level_statement
666: , L_LOG_MODULE, 'l_charges_rec.coverage_id = ' || l_charges_rec.coverage_id
667: );
668: FND_LOG.String
669: ( FND_LOG.level_statement

Line 668: FND_LOG.String

664: FND_LOG.String
665: ( FND_LOG.level_statement
666: , L_LOG_MODULE, 'l_charges_rec.coverage_id = ' || l_charges_rec.coverage_id
667: );
668: FND_LOG.String
669: ( FND_LOG.level_statement
670: , L_LOG_MODULE, 'l_charges_rec.coverage_txn_group_id = ' || l_charges_rec.coverage_txn_group_id
671: );
672: END IF;

Line 669: ( FND_LOG.level_statement

665: ( FND_LOG.level_statement
666: , L_LOG_MODULE, 'l_charges_rec.coverage_id = ' || l_charges_rec.coverage_id
667: );
668: FND_LOG.String
669: ( FND_LOG.level_statement
670: , L_LOG_MODULE, 'l_charges_rec.coverage_txn_group_id = ' || l_charges_rec.coverage_txn_group_id
671: );
672: END IF;
673: --DBMS_OUTPUT.PUT_LINE('l_charges_rec.contract_id = ' || l_charges_rec.contract_id);

Line 697: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

693: -- If inventory_item_id is null (labor for sure), get the labor coverages and billing rates
694: -- based on the Contracts Labor Coverages and Time Material Labor Schedules.
695: IF p_sbe_record.inventory_item_id IS NULL THEN
696:
697: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
698: THEN
699: FND_LOG.String
700: ( FND_LOG.level_statement
701: , L_LOG_MODULE, '--- p_sbe_record.inventory_item_id is null.'

Line 699: FND_LOG.String

695: IF p_sbe_record.inventory_item_id IS NULL THEN
696:
697: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
698: THEN
699: FND_LOG.String
700: ( FND_LOG.level_statement
701: , L_LOG_MODULE, '--- p_sbe_record.inventory_item_id is null.'
702: );
703: END IF;

Line 700: ( FND_LOG.level_statement

696:
697: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
698: THEN
699: FND_LOG.String
700: ( FND_LOG.level_statement
701: , L_LOG_MODULE, '--- p_sbe_record.inventory_item_id is null.'
702: );
703: END IF;
704:

Line 795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

791:
792:
793: END IF;
794:
795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: ( FND_LOG.level_statement
799: , L_LOG_MODULE, 'l_resource_id' || l_resource_id

Line 797: FND_LOG.String

793: END IF;
794:
795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: ( FND_LOG.level_statement
799: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
800: );
801: FND_LOG.String

Line 798: ( FND_LOG.level_statement

794:
795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: ( FND_LOG.level_statement
799: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
800: );
801: FND_LOG.String
802: ( FND_LOG.level_statement

Line 801: FND_LOG.String

797: FND_LOG.String
798: ( FND_LOG.level_statement
799: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
800: );
801: FND_LOG.String
802: ( FND_LOG.level_statement
803: , L_LOG_MODULE, 'l_task_id' || l_task_id
804: );
805: FND_LOG.String

Line 802: ( FND_LOG.level_statement

798: ( FND_LOG.level_statement
799: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
800: );
801: FND_LOG.String
802: ( FND_LOG.level_statement
803: , L_LOG_MODULE, 'l_task_id' || l_task_id
804: );
805: FND_LOG.String
806: ( FND_LOG.level_statement

Line 805: FND_LOG.String

801: FND_LOG.String
802: ( FND_LOG.level_statement
803: , L_LOG_MODULE, 'l_task_id' || l_task_id
804: );
805: FND_LOG.String
806: ( FND_LOG.level_statement
807: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
808: );
809: FND_LOG.String

Line 806: ( FND_LOG.level_statement

802: ( FND_LOG.level_statement
803: , L_LOG_MODULE, 'l_task_id' || l_task_id
804: );
805: FND_LOG.String
806: ( FND_LOG.level_statement
807: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
808: );
809: FND_LOG.String
810: ( FND_LOG.level_statement

Line 809: FND_LOG.String

805: FND_LOG.String
806: ( FND_LOG.level_statement
807: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
808: );
809: FND_LOG.String
810: ( FND_LOG.level_statement
811: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
812: );
813: FND_LOG.String

Line 810: ( FND_LOG.level_statement

806: ( FND_LOG.level_statement
807: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
808: );
809: FND_LOG.String
810: ( FND_LOG.level_statement
811: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
812: );
813: FND_LOG.String
814: ( FND_LOG.level_statement

Line 813: FND_LOG.String

809: FND_LOG.String
810: ( FND_LOG.level_statement
811: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
812: );
813: FND_LOG.String
814: ( FND_LOG.level_statement
815: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
816: );
817: FND_LOG.String

Line 814: ( FND_LOG.level_statement

810: ( FND_LOG.level_statement
811: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
812: );
813: FND_LOG.String
814: ( FND_LOG.level_statement
815: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
816: );
817: FND_LOG.String
818: ( FND_LOG.level_statement

Line 817: FND_LOG.String

813: FND_LOG.String
814: ( FND_LOG.level_statement
815: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
816: );
817: FND_LOG.String
818: ( FND_LOG.level_statement
819: , L_LOG_MODULE, 'lx_labor_end_date_time' || lx_labor_end_date_time
820: );
821: END IF;

Line 818: ( FND_LOG.level_statement

814: ( FND_LOG.level_statement
815: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
816: );
817: FND_LOG.String
818: ( FND_LOG.level_statement
819: , L_LOG_MODULE, 'lx_labor_end_date_time' || lx_labor_end_date_time
820: );
821: END IF;
822: -- END IF; -- timezone profile

Line 834: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

830: END IF;
831: CLOSE base_uom_csr; */
832: l_base_uom := fnd_profile.value('CSF_UOM_HOURS');
833:
834: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
835: THEN
836: FND_LOG.String
837: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
838: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom

Line 836: FND_LOG.String

832: l_base_uom := fnd_profile.value('CSF_UOM_HOURS');
833:
834: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
835: THEN
836: FND_LOG.String
837: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
838: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
839: );
840: END IF;

Line 837: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

833:
834: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
835: THEN
836: FND_LOG.String
837: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
838: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
839: );
840: END IF;
841: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 841: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

837: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
838: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
839: );
840: END IF;
841: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
842: THEN
843: FND_LOG.String
844: ( FND_LOG.level_statement
845: , L_LOG_MODULE, 'l_base_uom = ' || l_base_uom

Line 843: FND_LOG.String

839: );
840: END IF;
841: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
842: THEN
843: FND_LOG.String
844: ( FND_LOG.level_statement
845: , L_LOG_MODULE, 'l_base_uom = ' || l_base_uom
846: );
847: END IF;

Line 844: ( FND_LOG.level_statement

840: END IF;
841: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
842: THEN
843: FND_LOG.String
844: ( FND_LOG.level_statement
845: , L_LOG_MODULE, 'l_base_uom = ' || l_base_uom
846: );
847: END IF;
848: --DBMS_OUTPUT.PUT_LINE('l_base_uom = ' || l_base_uom);

Line 869: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

865: FND_MSG_PUB.ADD;
866: RAISE EXCP_USER_DEFINED;
867: END IF;
868:
869: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
870: THEN
871: FND_LOG.String
872: ( FND_LOG.level_statement
873: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id

Line 871: FND_LOG.String

867: END IF;
868:
869: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
870: THEN
871: FND_LOG.String
872: ( FND_LOG.level_statement
873: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id
874: );
875: END IF;

Line 872: ( FND_LOG.level_statement

868:
869: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
870: THEN
871: FND_LOG.String
872: ( FND_LOG.level_statement
873: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id
874: );
875: END IF;
876:

Line 917: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

913: l_activity_end_date_time := l_labor_end_date_time;
914: l_add_one_minute := 'N';
915: END IF;
916:
917: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
918: THEN
919: FND_LOG.String
920: ( FND_LOG.level_statement
921: , L_LOG_MODULE, '-- Process break up date => ' || TO_CHAR(l_activity_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' ~ ' || TO_CHAR(l_activity_end_date_time, 'DD-MON-YYYY HH24:MI:SS')

Line 919: FND_LOG.String

915: END IF;
916:
917: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
918: THEN
919: FND_LOG.String
920: ( FND_LOG.level_statement
921: , L_LOG_MODULE, '-- Process break up date => ' || TO_CHAR(l_activity_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' ~ ' || TO_CHAR(l_activity_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
922: );
923: END IF;

Line 920: ( FND_LOG.level_statement

916:
917: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
918: THEN
919: FND_LOG.String
920: ( FND_LOG.level_statement
921: , L_LOG_MODULE, '-- Process break up date => ' || TO_CHAR(l_activity_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' ~ ' || TO_CHAR(l_activity_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
922: );
923: END IF;
924: --DBMS_OUTPUT.PUT_LINE('-- Process break up date => ' || TO_CHAR(l_activity_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' ~ ' || TO_CHAR(l_activity_end_date_time, 'DD-MON-YYYY HH24:MI:SS'));

Line 931: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

927: -- Fixed the issue to resolve Bug # 5024792
928:
929: IF l_contract_service_id IS NOT NULL THEN -- If contract exists.
930:
931: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
932: THEN
933: FND_LOG.String
934: ( FND_LOG.level_statement
935: , L_LOG_MODULE, '-- Contract exists.'

Line 933: FND_LOG.String

929: IF l_contract_service_id IS NOT NULL THEN -- If contract exists.
930:
931: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
932: THEN
933: FND_LOG.String
934: ( FND_LOG.level_statement
935: , L_LOG_MODULE, '-- Contract exists.'
936: );
937: END IF;

Line 934: ( FND_LOG.level_statement

930:
931: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
932: THEN
933: FND_LOG.String
934: ( FND_LOG.level_statement
935: , L_LOG_MODULE, '-- Contract exists.'
936: );
937: END IF;
938: --DBMS_OUTPUT.PUT_LINE('-- Contract exists.');

Line 976: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

972: Consolidate_Labor_Coverages(
973: p_lbr_in_tbl => l_con_lbr_coverage_tbl,
974: x_lbr_out_tbl => x_con_lbr_coverage_tbl);
975:
976: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
977: THEN
978: FND_LOG.String
979: ( FND_LOG.level_statement
980: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count

Line 978: FND_LOG.String

974: x_lbr_out_tbl => x_con_lbr_coverage_tbl);
975:
976: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
977: THEN
978: FND_LOG.String
979: ( FND_LOG.level_statement
980: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count
981: );
982: END IF;

Line 979: ( FND_LOG.level_statement

975:
976: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
977: THEN
978: FND_LOG.String
979: ( FND_LOG.level_statement
980: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count
981: );
982: END IF;
983: --DBMS_OUTPUT.PUT_LINE('x_con_lbr_coverage_tbl.count = ' || x_con_lbr_coverage_tbl.count);

Line 994: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

990: -- If covered by contract.
991: IF x_con_lbr_coverage_tbl(i).labor_item_id IS NOT NULL OR
992: x_con_lbr_coverage_tbl(i).flat_rate IS NOT NULL THEN
993:
994: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
995: THEN
996: FND_LOG.String
997: ( FND_LOG.level_statement
998: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'

Line 996: FND_LOG.String

992: x_con_lbr_coverage_tbl(i).flat_rate IS NOT NULL THEN
993:
994: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
995: THEN
996: FND_LOG.String
997: ( FND_LOG.level_statement
998: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'
999: );
1000: END IF;

Line 997: ( FND_LOG.level_statement

993:
994: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
995: THEN
996: FND_LOG.String
997: ( FND_LOG.level_statement
998: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'
999: );
1000: END IF;
1001: --DBMS_OUTPUT.PUT_LINE('-- Covered by Contract Labor Coverage.');

Line 1050: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1046: l_charges_rec.rate_type_code := NULL;
1047: END IF;
1048:
1049:
1050: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1051: THEN
1052: FND_LOG.String
1053: ( FND_LOG.level_statement
1054: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')

Line 1052: FND_LOG.String

1048:
1049:
1050: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1051: THEN
1052: FND_LOG.String
1053: ( FND_LOG.level_statement
1054: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1055: );
1056: FND_LOG.String

Line 1053: ( FND_LOG.level_statement

1049:
1050: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1051: THEN
1052: FND_LOG.String
1053: ( FND_LOG.level_statement
1054: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1055: );
1056: FND_LOG.String
1057: ( FND_LOG.level_statement

Line 1056: FND_LOG.String

1052: FND_LOG.String
1053: ( FND_LOG.level_statement
1054: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1055: );
1056: FND_LOG.String
1057: ( FND_LOG.level_statement
1058: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1059: );
1060: FND_LOG.String

Line 1057: ( FND_LOG.level_statement

1053: ( FND_LOG.level_statement
1054: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1055: );
1056: FND_LOG.String
1057: ( FND_LOG.level_statement
1058: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1059: );
1060: FND_LOG.String
1061: ( FND_LOG.level_statement

Line 1060: FND_LOG.String

1056: FND_LOG.String
1057: ( FND_LOG.level_statement
1058: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1059: );
1060: FND_LOG.String
1061: ( FND_LOG.level_statement
1062: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1063: );
1064: FND_LOG.String

Line 1061: ( FND_LOG.level_statement

1057: ( FND_LOG.level_statement
1058: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1059: );
1060: FND_LOG.String
1061: ( FND_LOG.level_statement
1062: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1063: );
1064: FND_LOG.String
1065: ( FND_LOG.level_statement

Line 1064: FND_LOG.String

1060: FND_LOG.String
1061: ( FND_LOG.level_statement
1062: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1063: );
1064: FND_LOG.String
1065: ( FND_LOG.level_statement
1066: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1067: );
1068: FND_LOG.String

Line 1065: ( FND_LOG.level_statement

1061: ( FND_LOG.level_statement
1062: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1063: );
1064: FND_LOG.String
1065: ( FND_LOG.level_statement
1066: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1067: );
1068: FND_LOG.String
1069: ( FND_LOG.level_statement

Line 1068: FND_LOG.String

1064: FND_LOG.String
1065: ( FND_LOG.level_statement
1066: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1067: );
1068: FND_LOG.String
1069: ( FND_LOG.level_statement
1070: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1071: );
1072: FND_LOG.String

Line 1069: ( FND_LOG.level_statement

1065: ( FND_LOG.level_statement
1066: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1067: );
1068: FND_LOG.String
1069: ( FND_LOG.level_statement
1070: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1071: );
1072: FND_LOG.String
1073: ( FND_LOG.level_statement

Line 1072: FND_LOG.String

1068: FND_LOG.String
1069: ( FND_LOG.level_statement
1070: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1071: );
1072: FND_LOG.String
1073: ( FND_LOG.level_statement
1074: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1075: );
1076: FND_LOG.String

Line 1073: ( FND_LOG.level_statement

1069: ( FND_LOG.level_statement
1070: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1071: );
1072: FND_LOG.String
1073: ( FND_LOG.level_statement
1074: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1075: );
1076: FND_LOG.String
1077: ( FND_LOG.level_statement

Line 1076: FND_LOG.String

1072: FND_LOG.String
1073: ( FND_LOG.level_statement
1074: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1075: );
1076: FND_LOG.String
1077: ( FND_LOG.level_statement
1078: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1079: );
1080: FND_LOG.String

Line 1077: ( FND_LOG.level_statement

1073: ( FND_LOG.level_statement
1074: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1075: );
1076: FND_LOG.String
1077: ( FND_LOG.level_statement
1078: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1079: );
1080: FND_LOG.String
1081: ( FND_LOG.level_statement

Line 1080: FND_LOG.String

1076: FND_LOG.String
1077: ( FND_LOG.level_statement
1078: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1079: );
1080: FND_LOG.String
1081: ( FND_LOG.level_statement
1082: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1083: );
1084: FND_LOG.String

Line 1081: ( FND_LOG.level_statement

1077: ( FND_LOG.level_statement
1078: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1079: );
1080: FND_LOG.String
1081: ( FND_LOG.level_statement
1082: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1083: );
1084: FND_LOG.String
1085: ( FND_LOG.level_statement

Line 1084: FND_LOG.String

1080: FND_LOG.String
1081: ( FND_LOG.level_statement
1082: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1083: );
1084: FND_LOG.String
1085: ( FND_LOG.level_statement
1086: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1087: );
1088: FND_LOG.String

Line 1085: ( FND_LOG.level_statement

1081: ( FND_LOG.level_statement
1082: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1083: );
1084: FND_LOG.String
1085: ( FND_LOG.level_statement
1086: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1087: );
1088: FND_LOG.String
1089: ( FND_LOG.level_statement

Line 1088: FND_LOG.String

1084: FND_LOG.String
1085: ( FND_LOG.level_statement
1086: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1087: );
1088: FND_LOG.String
1089: ( FND_LOG.level_statement
1090: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1091: );
1092: END IF;

Line 1089: ( FND_LOG.level_statement

1085: ( FND_LOG.level_statement
1086: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1087: );
1088: FND_LOG.String
1089: ( FND_LOG.level_statement
1090: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1091: );
1092: END IF;
1093: --DBMS_OUTPUT.PUT_LINE('x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS'));

Line 1134: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1130: END IF;
1131:
1132: ELSE -- Not covered by contract.
1133:
1134: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1135: THEN
1136: FND_LOG.String
1137: ( FND_LOG.level_statement
1138: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'

Line 1136: FND_LOG.String

1132: ELSE -- Not covered by contract.
1133:
1134: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1135: THEN
1136: FND_LOG.String
1137: ( FND_LOG.level_statement
1138: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1139: );
1140: FND_LOG.String

Line 1137: ( FND_LOG.level_statement

1133:
1134: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1135: THEN
1136: FND_LOG.String
1137: ( FND_LOG.level_statement
1138: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1139: );
1140: FND_LOG.String
1141: ( FND_LOG.level_statement

Line 1140: FND_LOG.String

1136: FND_LOG.String
1137: ( FND_LOG.level_statement
1138: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1139: );
1140: FND_LOG.String
1141: ( FND_LOG.level_statement
1142: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1143: );
1144: FND_LOG.String

Line 1141: ( FND_LOG.level_statement

1137: ( FND_LOG.level_statement
1138: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1139: );
1140: FND_LOG.String
1141: ( FND_LOG.level_statement
1142: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1143: );
1144: FND_LOG.String
1145: ( FND_LOG.level_statement

Line 1144: FND_LOG.String

1140: FND_LOG.String
1141: ( FND_LOG.level_statement
1142: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1143: );
1144: FND_LOG.String
1145: ( FND_LOG.level_statement
1146: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1147: );
1148: END IF;

Line 1145: ( FND_LOG.level_statement

1141: ( FND_LOG.level_statement
1142: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').start_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).start_datetime, 'DD-MON-YYYY HH24:MI:SS')
1143: );
1144: FND_LOG.String
1145: ( FND_LOG.level_statement
1146: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').end_datetime = ' || TO_CHAR(x_con_lbr_coverage_tbl(i).end_datetime, 'DD-MON-YYYY HH24:MI:SS')
1147: );
1148: END IF;
1149: --DBMS_OUTPUT.PUT_LINE('-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...');

Line 1172: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1168: FND_MSG_PUB.ADD;
1169: RAISE EXCP_USER_DEFINED;
1170: END IF;
1171:
1172: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1173: THEN
1174: FND_LOG.String
1175: ( FND_LOG.level_statement
1176: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count

Line 1174: FND_LOG.String

1170: END IF;
1171:
1172: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1173: THEN
1174: FND_LOG.String
1175: ( FND_LOG.level_statement
1176: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count
1177: );
1178: END IF;

Line 1175: ( FND_LOG.level_statement

1171:
1172: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1173: THEN
1174: FND_LOG.String
1175: ( FND_LOG.level_statement
1176: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count
1177: );
1178: END IF;
1179: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count);

Line 1207: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1203: Null, 2, l_duration, l_base_uom, l_primary_uom, NULL, NULL);
1204: l_charges_rec.list_price := NULL;
1205: l_charges_rec.con_pct_over_list_price := NULL;
1206:
1207: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1208: THEN
1209: FND_LOG.String
1210: ( FND_LOG.level_statement
1211: , L_LOG_MODULE, '- TM Labor Coverage.'

Line 1209: FND_LOG.String

1205: l_charges_rec.con_pct_over_list_price := NULL;
1206:
1207: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1208: THEN
1209: FND_LOG.String
1210: ( FND_LOG.level_statement
1211: , L_LOG_MODULE, '- TM Labor Coverage.'
1212: );
1213: FND_LOG.String

Line 1210: ( FND_LOG.level_statement

1206:
1207: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1208: THEN
1209: FND_LOG.String
1210: ( FND_LOG.level_statement
1211: , L_LOG_MODULE, '- TM Labor Coverage.'
1212: );
1213: FND_LOG.String
1214: ( FND_LOG.level_statement

Line 1213: FND_LOG.String

1209: FND_LOG.String
1210: ( FND_LOG.level_statement
1211: , L_LOG_MODULE, '- TM Labor Coverage.'
1212: );
1213: FND_LOG.String
1214: ( FND_LOG.level_statement
1215: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1216: );
1217: FND_LOG.String

Line 1214: ( FND_LOG.level_statement

1210: ( FND_LOG.level_statement
1211: , L_LOG_MODULE, '- TM Labor Coverage.'
1212: );
1213: FND_LOG.String
1214: ( FND_LOG.level_statement
1215: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1216: );
1217: FND_LOG.String
1218: ( FND_LOG.level_statement

Line 1217: FND_LOG.String

1213: FND_LOG.String
1214: ( FND_LOG.level_statement
1215: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1216: );
1217: FND_LOG.String
1218: ( FND_LOG.level_statement
1219: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1220: );
1221: FND_LOG.String

Line 1218: ( FND_LOG.level_statement

1214: ( FND_LOG.level_statement
1215: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1216: );
1217: FND_LOG.String
1218: ( FND_LOG.level_statement
1219: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1220: );
1221: FND_LOG.String
1222: ( FND_LOG.level_statement

Line 1221: FND_LOG.String

1217: FND_LOG.String
1218: ( FND_LOG.level_statement
1219: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1220: );
1221: FND_LOG.String
1222: ( FND_LOG.level_statement
1223: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1224: );
1225: FND_LOG.String

Line 1222: ( FND_LOG.level_statement

1218: ( FND_LOG.level_statement
1219: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1220: );
1221: FND_LOG.String
1222: ( FND_LOG.level_statement
1223: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1224: );
1225: FND_LOG.String
1226: ( FND_LOG.level_statement

Line 1225: FND_LOG.String

1221: FND_LOG.String
1222: ( FND_LOG.level_statement
1223: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1224: );
1225: FND_LOG.String
1226: ( FND_LOG.level_statement
1227: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1228: );
1229: FND_LOG.String

Line 1226: ( FND_LOG.level_statement

1222: ( FND_LOG.level_statement
1223: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1224: );
1225: FND_LOG.String
1226: ( FND_LOG.level_statement
1227: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1228: );
1229: FND_LOG.String
1230: ( FND_LOG.level_statement

Line 1229: FND_LOG.String

1225: FND_LOG.String
1226: ( FND_LOG.level_statement
1227: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1228: );
1229: FND_LOG.String
1230: ( FND_LOG.level_statement
1231: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1232: );
1233: FND_LOG.String

Line 1230: ( FND_LOG.level_statement

1226: ( FND_LOG.level_statement
1227: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1228: );
1229: FND_LOG.String
1230: ( FND_LOG.level_statement
1231: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1232: );
1233: FND_LOG.String
1234: ( FND_LOG.level_statement

Line 1233: FND_LOG.String

1229: FND_LOG.String
1230: ( FND_LOG.level_statement
1231: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1232: );
1233: FND_LOG.String
1234: ( FND_LOG.level_statement
1235: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1236: );
1237: FND_LOG.String

Line 1234: ( FND_LOG.level_statement

1230: ( FND_LOG.level_statement
1231: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1232: );
1233: FND_LOG.String
1234: ( FND_LOG.level_statement
1235: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1236: );
1237: FND_LOG.String
1238: ( FND_LOG.level_statement

Line 1237: FND_LOG.String

1233: FND_LOG.String
1234: ( FND_LOG.level_statement
1235: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1236: );
1237: FND_LOG.String
1238: ( FND_LOG.level_statement
1239: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1240: );
1241: FND_LOG.String

Line 1238: ( FND_LOG.level_statement

1234: ( FND_LOG.level_statement
1235: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1236: );
1237: FND_LOG.String
1238: ( FND_LOG.level_statement
1239: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1240: );
1241: FND_LOG.String
1242: ( FND_LOG.level_statement

Line 1241: FND_LOG.String

1237: FND_LOG.String
1238: ( FND_LOG.level_statement
1239: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1240: );
1241: FND_LOG.String
1242: ( FND_LOG.level_statement
1243: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1244: );
1245: END IF;

Line 1242: ( FND_LOG.level_statement

1238: ( FND_LOG.level_statement
1239: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1240: );
1241: FND_LOG.String
1242: ( FND_LOG.level_statement
1243: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1244: );
1245: END IF;
1246: --DBMS_OUTPUT.PUT_LINE('- TM Labor Coverage.');

Line 1291: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1287: END LOOP;
1288:
1289: ELSE -- No contract.
1290:
1291: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1292: THEN
1293: FND_LOG.String
1294: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1295: );

Line 1293: FND_LOG.String

1289: ELSE -- No contract.
1290:
1291: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1292: THEN
1293: FND_LOG.String
1294: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1295: );
1296: END IF;
1297: --DBMS_OUTPUT.PUT_LINE('-- No contract. Calling TM Labor Coverage...');

Line 1294: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'

1290:
1291: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1292: THEN
1293: FND_LOG.String
1294: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1295: );
1296: END IF;
1297: --DBMS_OUTPUT.PUT_LINE('-- No contract. Calling TM Labor Coverage...');
1298:

Line 1318: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1314: FND_MSG_PUB.ADD;
1315: RAISE EXCP_USER_DEFINED;
1316: END IF;
1317:
1318: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1319: THEN
1320: FND_LOG.String
1321: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1322: , x_tm_coverage_tbl.count

Line 1320: FND_LOG.String

1316: END IF;
1317:
1318: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1319: THEN
1320: FND_LOG.String
1321: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1322: , x_tm_coverage_tbl.count
1323: );
1324: END IF;

Line 1321: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '

1317:
1318: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1319: THEN
1320: FND_LOG.String
1321: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1322: , x_tm_coverage_tbl.count
1323: );
1324: END IF;
1325: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count);

Line 1353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1349: Null, 2, l_duration, l_base_uom, l_primary_uom, NULL, NULL);
1350: l_charges_rec.list_price := NULL;
1351: l_charges_rec.con_pct_over_list_price := NULL;
1352:
1353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1354: THEN
1355: FND_LOG.String
1356: ( FND_LOG.level_statement
1357: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id

Line 1355: FND_LOG.String

1351: l_charges_rec.con_pct_over_list_price := NULL;
1352:
1353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1354: THEN
1355: FND_LOG.String
1356: ( FND_LOG.level_statement
1357: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1358: );
1359: FND_LOG.String

Line 1356: ( FND_LOG.level_statement

1352:
1353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1354: THEN
1355: FND_LOG.String
1356: ( FND_LOG.level_statement
1357: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1358: );
1359: FND_LOG.String
1360: ( FND_LOG.level_statement

Line 1359: FND_LOG.String

1355: FND_LOG.String
1356: ( FND_LOG.level_statement
1357: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1358: );
1359: FND_LOG.String
1360: ( FND_LOG.level_statement
1361: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1362: );
1363: FND_LOG.String

Line 1360: ( FND_LOG.level_statement

1356: ( FND_LOG.level_statement
1357: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1358: );
1359: FND_LOG.String
1360: ( FND_LOG.level_statement
1361: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1362: );
1363: FND_LOG.String
1364: ( FND_LOG.level_statement

Line 1363: FND_LOG.String

1359: FND_LOG.String
1360: ( FND_LOG.level_statement
1361: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1362: );
1363: FND_LOG.String
1364: ( FND_LOG.level_statement
1365: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1366: );
1367: FND_LOG.String

Line 1364: ( FND_LOG.level_statement

1360: ( FND_LOG.level_statement
1361: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_start_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
1362: );
1363: FND_LOG.String
1364: ( FND_LOG.level_statement
1365: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1366: );
1367: FND_LOG.String
1368: ( FND_LOG.level_statement

Line 1367: FND_LOG.String

1363: FND_LOG.String
1364: ( FND_LOG.level_statement
1365: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1366: );
1367: FND_LOG.String
1368: ( FND_LOG.level_statement
1369: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1370: );
1371: FND_LOG.String

Line 1368: ( FND_LOG.level_statement

1364: ( FND_LOG.level_statement
1365: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').labor_end_date_time = ' || TO_CHAR(x_tm_coverage_tbl(j).labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
1366: );
1367: FND_LOG.String
1368: ( FND_LOG.level_statement
1369: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1370: );
1371: FND_LOG.String
1372: ( FND_LOG.level_statement

Line 1371: FND_LOG.String

1367: FND_LOG.String
1368: ( FND_LOG.level_statement
1369: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1370: );
1371: FND_LOG.String
1372: ( FND_LOG.level_statement
1373: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1374: );
1375: FND_LOG.String

Line 1372: ( FND_LOG.level_statement

1368: ( FND_LOG.level_statement
1369: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1370: );
1371: FND_LOG.String
1372: ( FND_LOG.level_statement
1373: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1374: );
1375: FND_LOG.String
1376: ( FND_LOG.level_statement

Line 1375: FND_LOG.String

1371: FND_LOG.String
1372: ( FND_LOG.level_statement
1373: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1374: );
1375: FND_LOG.String
1376: ( FND_LOG.level_statement
1377: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1378: );
1379: FND_LOG.String

Line 1376: ( FND_LOG.level_statement

1372: ( FND_LOG.level_statement
1373: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1374: );
1375: FND_LOG.String
1376: ( FND_LOG.level_statement
1377: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1378: );
1379: FND_LOG.String
1380: ( FND_LOG.level_statement

Line 1379: FND_LOG.String

1375: FND_LOG.String
1376: ( FND_LOG.level_statement
1377: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1378: );
1379: FND_LOG.String
1380: ( FND_LOG.level_statement
1381: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1382: );
1383: FND_LOG.String

Line 1380: ( FND_LOG.level_statement

1376: ( FND_LOG.level_statement
1377: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1378: );
1379: FND_LOG.String
1380: ( FND_LOG.level_statement
1381: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1382: );
1383: FND_LOG.String
1384: ( FND_LOG.level_statement

Line 1383: FND_LOG.String

1379: FND_LOG.String
1380: ( FND_LOG.level_statement
1381: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1382: );
1383: FND_LOG.String
1384: ( FND_LOG.level_statement
1385: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1386: );
1387: END IF;

Line 1384: ( FND_LOG.level_statement

1380: ( FND_LOG.level_statement
1381: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1382: );
1383: FND_LOG.String
1384: ( FND_LOG.level_statement
1385: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1386: );
1387: END IF;
1388: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id);

Line 1449: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1445: CLOSE billing_category;
1446: -- End bug 7229344
1447:
1448:
1449: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1450: THEN
1451: FND_LOG.String
1452: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1453: );

Line 1451: FND_LOG.String

1447:
1448:
1449: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1450: THEN
1451: FND_LOG.String
1452: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1453: );
1454: END IF;
1455: -- DBMS_OUTPUT.PUT_LINE('--- p_sbe_record.inventory_item_id is not null.');

Line 1452: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'

1448:
1449: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1450: THEN
1451: FND_LOG.String
1452: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1453: );
1454: END IF;
1455: -- DBMS_OUTPUT.PUT_LINE('--- p_sbe_record.inventory_item_id is not null.');
1456:

Line 1575: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1571: END IF;
1572:
1573: END IF; -- inventory_item_id check
1574:
1575: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1576: THEN
1577: FND_LOG.String
1578: ( FND_LOG.level_statement, L_LOG_MODULE, '----- Private API:' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
1579: );

Line 1577: FND_LOG.String

1573: END IF; -- inventory_item_id check
1574:
1575: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1576: THEN
1577: FND_LOG.String
1578: ( FND_LOG.level_statement, L_LOG_MODULE, '----- Private API:' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
1579: );
1580: END IF;
1581: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));

Line 1578: ( FND_LOG.level_statement, L_LOG_MODULE, '----- Private API:' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')

1574:
1575: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1576: THEN
1577: FND_LOG.String
1578: ( FND_LOG.level_statement, L_LOG_MODULE, '----- Private API:' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
1579: );
1580: END IF;
1581: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));
1582: --DBMS_OUTPUT.PUT_LINE('Return status = ' || x_return_status);

Line 1691: ----------------------- FND Logging -----------------------------------

1687: THEN
1688: FND_MSG_PUB.initialize;
1689: END IF;
1690:
1691: ----------------------- FND Logging -----------------------------------
1692: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1693: THEN
1694: FND_LOG.String
1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 1692: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1688: FND_MSG_PUB.initialize;
1689: END IF;
1690:
1691: ----------------------- FND Logging -----------------------------------
1692: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1693: THEN
1694: FND_LOG.String
1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1696: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 1694: FND_LOG.String

1690:
1691: ----------------------- FND Logging -----------------------------------
1692: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1693: THEN
1694: FND_LOG.String
1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1696: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1697: );
1698: FND_LOG.String

Line 1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

1691: ----------------------- FND Logging -----------------------------------
1692: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1693: THEN
1694: FND_LOG.String
1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1696: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1697: );
1698: FND_LOG.String
1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1698: FND_LOG.String

1694: FND_LOG.String
1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1696: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1697: );
1698: FND_LOG.String
1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1700: , 'P_Api_Version_Number:' || P_Api_Version_Number
1701: );
1702: FND_LOG.String

Line 1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1695: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1696: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1697: );
1698: FND_LOG.String
1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1700: , 'P_Api_Version_Number:' || P_Api_Version_Number
1701: );
1702: FND_LOG.String
1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1702: FND_LOG.String

1698: FND_LOG.String
1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1700: , 'P_Api_Version_Number:' || P_Api_Version_Number
1701: );
1702: FND_LOG.String
1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1704: , 'p_init_msg_list:' || p_init_msg_list
1705: );
1706: FND_LOG.String

Line 1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1699: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1700: , 'P_Api_Version_Number:' || P_Api_Version_Number
1701: );
1702: FND_LOG.String
1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1704: , 'p_init_msg_list:' || p_init_msg_list
1705: );
1706: FND_LOG.String
1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1706: FND_LOG.String

1702: FND_LOG.String
1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1704: , 'p_init_msg_list:' || p_init_msg_list
1705: );
1706: FND_LOG.String
1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1708: , 'p_commit:' || p_commit
1709: );
1710: FND_LOG.String

Line 1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1703: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1704: , 'p_init_msg_list:' || p_init_msg_list
1705: );
1706: FND_LOG.String
1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1708: , 'p_commit:' || p_commit
1709: );
1710: FND_LOG.String
1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1710: FND_LOG.String

1706: FND_LOG.String
1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1708: , 'p_commit:' || p_commit
1709: );
1710: FND_LOG.String
1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1712: , 'p_incident_id:' || p_incident_id
1713: );
1714: FND_LOG.String

Line 1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1708: , 'p_commit:' || p_commit
1709: );
1710: FND_LOG.String
1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1712: , 'p_incident_id:' || p_incident_id
1713: );
1714: FND_LOG.String
1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1714: FND_LOG.String

1710: FND_LOG.String
1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1712: , 'p_incident_id:' || p_incident_id
1713: );
1714: FND_LOG.String
1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1716: , 'p_debrief_header_id:' || p_debrief_header_id
1717: );
1718: FND_LOG.String

Line 1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1711: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1712: , 'p_incident_id:' || p_incident_id
1713: );
1714: FND_LOG.String
1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1716: , 'p_debrief_header_id:' || p_debrief_header_id
1717: );
1718: FND_LOG.String
1719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1718: FND_LOG.String

1714: FND_LOG.String
1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1716: , 'p_debrief_header_id:' || p_debrief_header_id
1717: );
1718: FND_LOG.String
1719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1720: , 'p_debrief_line_id:' || p_debrief_line_id
1721: );
1722: END IF;

Line 1719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

1715: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1716: , 'p_debrief_header_id:' || p_debrief_header_id
1717: );
1718: FND_LOG.String
1719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1720: , 'p_debrief_line_id:' || p_debrief_line_id
1721: );
1722: END IF;
1723:

Line 1724: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1720: , 'p_debrief_line_id:' || p_debrief_line_id
1721: );
1722: END IF;
1723:
1724: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1725: THEN
1726: FND_LOG.String
1727: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1728: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')

Line 1726: FND_LOG.String

1722: END IF;
1723:
1724: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1725: THEN
1726: FND_LOG.String
1727: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1728: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1729: );
1730: END IF;

Line 1727: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'

1723:
1724: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1725: THEN
1726: FND_LOG.String
1727: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1728: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1729: );
1730: END IF;
1731: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1771: LOOP
1772: FETCH in_progress_charges_csr into l_estimate_detail_id;
1773: EXIT WHEN in_progress_charges_csr%NOTFOUND;
1774:
1775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1776: THEN
1777: FND_LOG.String
1778: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1779: , l_estimate_detail_id

Line 1777: FND_LOG.String

1773: EXIT WHEN in_progress_charges_csr%NOTFOUND;
1774:
1775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1776: THEN
1777: FND_LOG.String
1778: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1779: , l_estimate_detail_id
1780: );
1781: END IF;

Line 1778: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '

1774:
1775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1776: THEN
1777: FND_LOG.String
1778: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1779: , l_estimate_detail_id
1780: );
1781: END IF;
1782: --DBMS_OUTPUT.PUT_LINE('Delete l_estimate_detail_id = ' || l_estimate_detail_id);

Line 1811: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1807: IF FND_API.to_Boolean(p_commit) THEN
1808: COMMIT;
1809: END IF;
1810:
1811: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1812: THEN
1813: FND_LOG.String
1814: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1815: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')

Line 1813: FND_LOG.String

1809: END IF;
1810:
1811: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1812: THEN
1813: FND_LOG.String
1814: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1815: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1816: );
1817: END IF;

Line 1814: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'

1810:
1811: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1812: THEN
1813: FND_LOG.String
1814: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1815: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1816: );
1817: END IF;
1818: --DBMS_OUTPUT.PUT_LINE('Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));