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.

[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_LOG

Line 339: ----------------------- FND Logging -----------------------------------

335:
336: -- Initialize API return status to SUCCESS
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: ----------------------- FND Logging -----------------------------------
340: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
341: THEN
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

336: -- Initialize API return status to SUCCESS
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: ----------------------- FND Logging -----------------------------------
340: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
341: THEN
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
344: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 342: FND_LOG.String

338:
339: ----------------------- FND Logging -----------------------------------
340: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
341: THEN
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
344: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
345: );
346: FND_LOG.String

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

339: ----------------------- FND Logging -----------------------------------
340: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
341: THEN
342: FND_LOG.String
343: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
344: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
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 || 'start'
344: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
345: );
346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'P_Api_Version_Number:' || P_Api_Version_Number
349: );
350: FND_LOG.String

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

343: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
344: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
345: );
346: FND_LOG.String
347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'P_Api_Version_Number:' || P_Api_Version_Number
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_Api_Version_Number:' || P_Api_Version_Number
349: );
350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: , 'p_init_msg_list:' || p_init_msg_list
353: );
354: FND_LOG.String

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

347: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
348: , 'P_Api_Version_Number:' || P_Api_Version_Number
349: );
350: FND_LOG.String
351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: , 'p_init_msg_list:' || p_init_msg_list
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: , 'p_init_msg_list:' || p_init_msg_list
353: );
354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: , 'p_commit:' || p_commit
357: );
358: FND_LOG.String

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

351: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
352: , 'p_init_msg_list:' || p_init_msg_list
353: );
354: FND_LOG.String
355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: , 'p_commit:' || p_commit
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: , 'p_commit:' || p_commit
357: );
358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'incident_id :' || p_sbe_record.incident_id
361: );
362: FND_LOG.String

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

355: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
356: , 'p_commit:' || p_commit
357: );
358: FND_LOG.String
359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'incident_id :' || p_sbe_record.incident_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: ,'incident_id :' || p_sbe_record.incident_id
361: );
362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'business_process_id :' || p_sbe_record.business_process_id
365: );
366: FND_LOG.String

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

359: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
360: ,'incident_id :' || p_sbe_record.incident_id
361: );
362: FND_LOG.String
363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'business_process_id :' || p_sbe_record.business_process_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: ,'business_process_id :' || p_sbe_record.business_process_id
365: );
366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
369: );
370: FND_LOG.String

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

363: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
364: ,'business_process_id :' || p_sbe_record.business_process_id
365: );
366: FND_LOG.String
367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
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: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
369: );
370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
373: );
374: FND_LOG.String

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

367: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
368: ,'transaction_type_id :' || p_sbe_record.transaction_type_id
369: );
370: FND_LOG.String
371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_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: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
373: );
374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'line_category_code :' || p_sbe_record.line_category_code
377: );
378: FND_LOG.String

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

371: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
372: ,'txn_billing_type_id :' || p_sbe_record.txn_billing_type_id
373: );
374: FND_LOG.String
375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'line_category_code :' || p_sbe_record.line_category_code
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: ,'line_category_code :' || p_sbe_record.line_category_code
377: );
378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'contract_id :' || p_sbe_record.contract_id
381: );
382: FND_LOG.String

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

375: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
376: ,'line_category_code :' || p_sbe_record.line_category_code
377: );
378: FND_LOG.String
379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'contract_id :' || p_sbe_record.contract_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: ,'contract_id :' || p_sbe_record.contract_id
381: );
382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'contract_line_id :' || p_sbe_record.contract_line_id
385: );
386: FND_LOG.String

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

379: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
380: ,'contract_id :' || p_sbe_record.contract_id
381: );
382: FND_LOG.String
383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'contract_line_id :' || p_sbe_record.contract_line_id
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: ,'contract_line_id :' || p_sbe_record.contract_line_id
385: );
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'price_list_id :' || p_sbe_record.price_list_id
389: );
390: FND_LOG.String

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

383: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
384: ,'contract_line_id :' || p_sbe_record.contract_line_id
385: );
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'price_list_id :' || p_sbe_record.price_list_id
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: ,'price_list_id :' || p_sbe_record.price_list_id
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'currency_code :' || p_sbe_record.currency_code
393: );
394: FND_LOG.String

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

387: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
388: ,'price_list_id :' || p_sbe_record.price_list_id
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'currency_code :' || p_sbe_record.currency_code
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: ,'currency_code :' || p_sbe_record.currency_code
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'service_date :' || p_sbe_record.service_date
397: );
398: FND_LOG.String

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

391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: ,'currency_code :' || p_sbe_record.currency_code
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'service_date :' || p_sbe_record.service_date
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: ,'service_date :' || p_sbe_record.service_date
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
401: );
402: FND_LOG.String

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

395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: ,'service_date :' || p_sbe_record.service_date
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
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: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
401: );
402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
405: );
406: FND_LOG.String

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

399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: ,'labor_start_date_time :' || p_sbe_record.labor_start_date_time
401: );
402: FND_LOG.String
403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
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: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
405: );
406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
409: );
410: FND_LOG.String

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

403: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
404: ,'labor_end_date_time :' || p_sbe_record.labor_end_date_time
405: );
406: FND_LOG.String
407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
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: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
409: );
410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'serial_number :' || p_sbe_record.serial_number
413: );
414: FND_LOG.String

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

407: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
408: ,'inventory_item_id :' || p_sbe_record.inventory_item_id
409: );
410: FND_LOG.String
411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'serial_number :' || p_sbe_record.serial_number
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: ,'serial_number :' || p_sbe_record.serial_number
413: );
414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'item_revision :' || p_sbe_record.item_revision
417: );
418: FND_LOG.String

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

411: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
412: ,'serial_number :' || p_sbe_record.serial_number
413: );
414: FND_LOG.String
415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'item_revision :' || p_sbe_record.item_revision
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: ,'item_revision :' || p_sbe_record.item_revision
417: );
418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
421: );
422: FND_LOG.String

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

415: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
416: ,'item_revision :' || p_sbe_record.item_revision
417: );
418: FND_LOG.String
419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
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: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
421: );
422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'quantity :' || p_sbe_record.quantity
425: );
426: FND_LOG.String

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

419: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
420: ,'unit_of_measure_code :' || p_sbe_record.unit_of_measure_code
421: );
422: FND_LOG.String
423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'quantity :' || p_sbe_record.quantity
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: ,'quantity :' || p_sbe_record.quantity
425: );
426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
429: );
430: FND_LOG.String

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

423: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
424: ,'quantity :' || p_sbe_record.quantity
425: );
426: FND_LOG.String
427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
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: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
429: );
430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'return_reason_code :' || p_sbe_record.return_reason_code
433: );
434: FND_LOG.String

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

427: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
428: ,'after_warranty_cost :' || p_sbe_record.after_warranty_cost
429: );
430: FND_LOG.String
431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'return_reason_code :' || p_sbe_record.return_reason_code
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: ,'return_reason_code :' || p_sbe_record.return_reason_code
433: );
434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
437: );
438: FND_LOG.String

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

431: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
432: ,'return_reason_code :' || p_sbe_record.return_reason_code
433: );
434: FND_LOG.String
435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
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: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
437: );
438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'customer_product_id :' || p_sbe_record.customer_product_id
441: );
442: FND_LOG.String

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

435: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
436: ,'installed_cp_return_by_date :' || p_sbe_record.installed_cp_return_by_date
437: );
438: FND_LOG.String
439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'customer_product_id :' || p_sbe_record.customer_product_id
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: ,'customer_product_id :' || p_sbe_record.customer_product_id
441: );
442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
445: );
446: FND_LOG.String

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

439: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
440: ,'customer_product_id :' || p_sbe_record.customer_product_id
441: );
442: FND_LOG.String
443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_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: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
445: );
446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
449: );
450: FND_LOG.String

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

443: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
444: ,'transaction_inventory_org_id :' || p_sbe_record.transaction_inventory_org_id
445: );
446: FND_LOG.String
447: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
448: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
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: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
449: );
450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'original_source_id :' || p_sbe_record.original_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: ,'transaction_sub_inventory :' || p_sbe_record.transaction_sub_inventory
449: );
450: FND_LOG.String
451: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
452: ,'original_source_id :' || p_sbe_record.original_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: ,'original_source_id :' || p_sbe_record.original_source_id
453: );
454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'original_source_code :' || p_sbe_record.original_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: ,'original_source_id :' || p_sbe_record.original_source_id
453: );
454: FND_LOG.String
455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'original_source_code :' || p_sbe_record.original_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: ,'original_source_code :' || p_sbe_record.original_source_code
457: );
458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: ,'source_id :' || p_sbe_record.source_id
461: );
462: FND_LOG.String

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

455: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
456: ,'original_source_code :' || p_sbe_record.original_source_code
457: );
458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: ,'source_id :' || p_sbe_record.source_id
461: );
462: FND_LOG.String
463: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 462: FND_LOG.String

458: FND_LOG.String
459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: ,'source_id :' || p_sbe_record.source_id
461: );
462: FND_LOG.String
463: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
464: ,'source_code :' || p_sbe_record.source_code
465: );
466: FND_LOG.String

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

459: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
460: ,'source_id :' || p_sbe_record.source_id
461: );
462: FND_LOG.String
463: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
464: ,'source_code :' || p_sbe_record.source_code
465: );
466: FND_LOG.String
467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 466: FND_LOG.String

462: FND_LOG.String
463: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
464: ,'source_code :' || p_sbe_record.source_code
465: );
466: FND_LOG.String
467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
468: , 'p_final_charge_flag:' || p_final_charge_flag
469: );
470: END IF;

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

463: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
464: ,'source_code :' || p_sbe_record.source_code
465: );
466: FND_LOG.String
467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
468: , 'p_final_charge_flag:' || p_final_charge_flag
469: );
470: END IF;
471:

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

468: , 'p_final_charge_flag:' || p_final_charge_flag
469: );
470: END IF;
471:
472: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
473: THEN
474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')

Line 474: FND_LOG.String

470: END IF;
471:
472: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
473: THEN
474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
477: );
478: FND_LOG.String

Line 475: ( FND_LOG.level_statement

471:
472: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
473: THEN
474: FND_LOG.String
475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
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, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
477: );
478: FND_LOG.String
479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
481: );
482: FND_LOG.String

Line 479: ( FND_LOG.level_statement

475: ( FND_LOG.level_statement
476: , L_LOG_MODULE, '----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS')
477: );
478: FND_LOG.String
479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_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.incident_id = ' || p_sbe_record.incident_id
481: );
482: FND_LOG.String
483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
485: );
486: FND_LOG.String

Line 483: ( FND_LOG.level_statement

479: ( FND_LOG.level_statement
480: , L_LOG_MODULE, 'p_sbe_record.incident_id = ' || p_sbe_record.incident_id
481: );
482: FND_LOG.String
483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_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.business_process_id = ' || p_sbe_record.business_process_id
485: );
486: FND_LOG.String
487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
489: );
490: FND_LOG.String

Line 487: ( FND_LOG.level_statement

483: ( FND_LOG.level_statement
484: , L_LOG_MODULE, 'p_sbe_record.business_process_id = ' || p_sbe_record.business_process_id
485: );
486: FND_LOG.String
487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
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.transaction_type_id = ' || p_sbe_record.transaction_type_id
489: );
490: FND_LOG.String
491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
493: );
494: FND_LOG.String

Line 491: ( FND_LOG.level_statement

487: ( FND_LOG.level_statement
488: , L_LOG_MODULE, 'p_sbe_record.transaction_type_id = ' || p_sbe_record.transaction_type_id
489: );
490: FND_LOG.String
491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_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.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
493: );
494: FND_LOG.String
495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
497: );
498: FND_LOG.String

Line 495: ( FND_LOG.level_statement

491: ( FND_LOG.level_statement
492: , L_LOG_MODULE, 'p_sbe_record.txn_billing_type_id = ' || p_sbe_record.txn_billing_type_id
493: );
494: FND_LOG.String
495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
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.line_category_code = ' || p_sbe_record.line_category_code
497: );
498: FND_LOG.String
499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
501: );
502: FND_LOG.String

Line 499: ( FND_LOG.level_statement

495: ( FND_LOG.level_statement
496: , L_LOG_MODULE, 'p_sbe_record.line_category_code = ' || p_sbe_record.line_category_code
497: );
498: FND_LOG.String
499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
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.contract_id = ' || p_sbe_record.contract_id
501: );
502: FND_LOG.String
503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
505: );
506: FND_LOG.String

Line 503: ( FND_LOG.level_statement

499: ( FND_LOG.level_statement
500: , L_LOG_MODULE, 'p_sbe_record.contract_id = ' || p_sbe_record.contract_id
501: );
502: FND_LOG.String
503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
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.price_list_id = ' || p_sbe_record.price_list_id
505: );
506: FND_LOG.String
507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
509: );
510: FND_LOG.String

Line 507: ( FND_LOG.level_statement

503: ( FND_LOG.level_statement
504: , L_LOG_MODULE, 'p_sbe_record.price_list_id = ' || p_sbe_record.price_list_id
505: );
506: FND_LOG.String
507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
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.currency_code = ' || p_sbe_record.currency_code
509: );
510: FND_LOG.String
511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
513: );
514: FND_LOG.String

Line 511: ( FND_LOG.level_statement

507: ( FND_LOG.level_statement
508: , L_LOG_MODULE, 'p_sbe_record.currency_code = ' || p_sbe_record.currency_code
509: );
510: FND_LOG.String
511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
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.service_date = ' || p_sbe_record.service_date
513: );
514: FND_LOG.String
515: ( FND_LOG.level_statement
516: , 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')
517: );
518: FND_LOG.String

Line 515: ( FND_LOG.level_statement

511: ( FND_LOG.level_statement
512: , L_LOG_MODULE, 'p_sbe_record.service_date = ' || p_sbe_record.service_date
513: );
514: FND_LOG.String
515: ( FND_LOG.level_statement
516: , 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')
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.labor_start_date_time = ' || TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS')
517: );
518: FND_LOG.String
519: ( FND_LOG.level_statement
520: , 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')
521: );
522: FND_LOG.String

Line 519: ( FND_LOG.level_statement

515: ( FND_LOG.level_statement
516: , 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')
517: );
518: FND_LOG.String
519: ( FND_LOG.level_statement
520: , 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')
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.labor_end_date_time = ' || TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS')
521: );
522: FND_LOG.String
523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
525: );
526: FND_LOG.String

Line 523: ( FND_LOG.level_statement

519: ( FND_LOG.level_statement
520: , 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')
521: );
522: FND_LOG.String
523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_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.inventory_item_id = ' || p_sbe_record.inventory_item_id
525: );
526: FND_LOG.String
527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
529: );
530: FND_LOG.String

Line 527: ( FND_LOG.level_statement

523: ( FND_LOG.level_statement
524: , L_LOG_MODULE, 'p_sbe_record.inventory_item_id = ' || p_sbe_record.inventory_item_id
525: );
526: FND_LOG.String
527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
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.quantity = ' || p_sbe_record.quantity
529: );
530: FND_LOG.String
531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
533: );
534: FND_LOG.String

Line 531: ( FND_LOG.level_statement

527: ( FND_LOG.level_statement
528: , L_LOG_MODULE, 'p_sbe_record.quantity = ' || p_sbe_record.quantity
529: );
530: FND_LOG.String
531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
533: );
534: FND_LOG.String
535: ( FND_LOG.level_statement

Line 534: FND_LOG.String

530: FND_LOG.String
531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
533: );
534: FND_LOG.String
535: ( FND_LOG.level_statement
536: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
537: );
538: FND_LOG.String

Line 535: ( FND_LOG.level_statement

531: ( FND_LOG.level_statement
532: , L_LOG_MODULE, 'p_sbe_record.original_source_code = ' || p_sbe_record.original_source_code || ' original_source_id = ' || p_sbe_record.original_source_id
533: );
534: FND_LOG.String
535: ( FND_LOG.level_statement
536: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
537: );
538: FND_LOG.String
539: ( FND_LOG.level_statement

Line 538: FND_LOG.String

534: FND_LOG.String
535: ( FND_LOG.level_statement
536: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
537: );
538: FND_LOG.String
539: ( FND_LOG.level_statement
540: , L_LOG_MODULE, 'p_final_charge_flag = ' || p_final_charge_flag
541: );
542: END IF;

Line 539: ( FND_LOG.level_statement

535: ( FND_LOG.level_statement
536: , L_LOG_MODULE, 'p_sbe_record.source_code = ' || p_sbe_record.source_code || ' source_id = ' || p_sbe_record.source_id
537: );
538: FND_LOG.String
539: ( FND_LOG.level_statement
540: , L_LOG_MODULE, 'p_final_charge_flag = ' || p_final_charge_flag
541: );
542: END IF;
543:

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

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:
698: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
699: THEN
700: FND_LOG.String
701: ( FND_LOG.level_statement
702: , L_LOG_MODULE, '--- p_sbe_record.inventory_item_id is null.'

Line 700: FND_LOG.String

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

Line 701: ( FND_LOG.level_statement

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

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

818: */
819:
820: END IF;
821:
822: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
823: THEN
824: FND_LOG.String
825: ( FND_LOG.level_statement
826: , L_LOG_MODULE, 'l_resource_id' || l_resource_id

Line 824: FND_LOG.String

820: END IF;
821:
822: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
823: THEN
824: FND_LOG.String
825: ( FND_LOG.level_statement
826: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
827: );
828: FND_LOG.String

Line 825: ( FND_LOG.level_statement

821:
822: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
823: THEN
824: FND_LOG.String
825: ( FND_LOG.level_statement
826: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
827: );
828: FND_LOG.String
829: ( FND_LOG.level_statement

Line 828: FND_LOG.String

824: FND_LOG.String
825: ( FND_LOG.level_statement
826: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
827: );
828: FND_LOG.String
829: ( FND_LOG.level_statement
830: , L_LOG_MODULE, 'l_task_id' || l_task_id
831: );
832: FND_LOG.String

Line 829: ( FND_LOG.level_statement

825: ( FND_LOG.level_statement
826: , L_LOG_MODULE, 'l_resource_id' || l_resource_id
827: );
828: FND_LOG.String
829: ( FND_LOG.level_statement
830: , L_LOG_MODULE, 'l_task_id' || l_task_id
831: );
832: FND_LOG.String
833: ( FND_LOG.level_statement

Line 832: FND_LOG.String

828: FND_LOG.String
829: ( FND_LOG.level_statement
830: , L_LOG_MODULE, 'l_task_id' || l_task_id
831: );
832: FND_LOG.String
833: ( FND_LOG.level_statement
834: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
835: );
836: FND_LOG.String

Line 833: ( FND_LOG.level_statement

829: ( FND_LOG.level_statement
830: , L_LOG_MODULE, 'l_task_id' || l_task_id
831: );
832: FND_LOG.String
833: ( FND_LOG.level_statement
834: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
835: );
836: FND_LOG.String
837: ( FND_LOG.level_statement

Line 836: FND_LOG.String

832: FND_LOG.String
833: ( FND_LOG.level_statement
834: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
835: );
836: FND_LOG.String
837: ( FND_LOG.level_statement
838: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
839: );
840: FND_LOG.String

Line 837: ( FND_LOG.level_statement

833: ( FND_LOG.level_statement
834: , L_LOG_MODULE, 'lx_timezone_id' || lx_timezone_id
835: );
836: FND_LOG.String
837: ( FND_LOG.level_statement
838: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
839: );
840: FND_LOG.String
841: ( FND_LOG.level_statement

Line 840: FND_LOG.String

836: FND_LOG.String
837: ( FND_LOG.level_statement
838: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
839: );
840: FND_LOG.String
841: ( FND_LOG.level_statement
842: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
843: );
844: FND_LOG.String

Line 841: ( FND_LOG.level_statement

837: ( FND_LOG.level_statement
838: , L_LOG_MODULE, 'lx_timezone_name' || lx_timezone_name
839: );
840: FND_LOG.String
841: ( FND_LOG.level_statement
842: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
843: );
844: FND_LOG.String
845: ( FND_LOG.level_statement

Line 844: FND_LOG.String

840: FND_LOG.String
841: ( FND_LOG.level_statement
842: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
843: );
844: FND_LOG.String
845: ( FND_LOG.level_statement
846: , L_LOG_MODULE, 'lx_labor_end_date_time' || lx_labor_end_date_time
847: );
848: END IF;

Line 845: ( FND_LOG.level_statement

841: ( FND_LOG.level_statement
842: , L_LOG_MODULE, 'lx_labor_start_date_time' || lx_labor_start_date_time
843: );
844: FND_LOG.String
845: ( FND_LOG.level_statement
846: , L_LOG_MODULE, 'lx_labor_end_date_time' || lx_labor_end_date_time
847: );
848: END IF;
849: -- END IF; -- timezone profile

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

857: END IF;
858: CLOSE base_uom_csr; */
859: l_base_uom := fnd_profile.value('CSF_UOM_HOURS');
860:
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
865: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom

Line 863: FND_LOG.String

859: l_base_uom := fnd_profile.value('CSF_UOM_HOURS');
860:
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
865: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
866: );
867: END IF;

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

860:
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
865: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
866: );
867: END IF;
868: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

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

864: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
865: , 'The Value of profile CSF_UOM_HOURS :' || l_base_uom
866: );
867: END IF;
868: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
869: THEN
870: FND_LOG.String
871: ( FND_LOG.level_statement
872: , L_LOG_MODULE, 'l_base_uom = ' || l_base_uom

Line 870: FND_LOG.String

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

Line 871: ( FND_LOG.level_statement

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

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

892: FND_MSG_PUB.ADD;
893: RAISE EXCP_USER_DEFINED;
894: END IF;
895:
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement
900: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id

Line 898: FND_LOG.String

894: END IF;
895:
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement
900: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id
901: );
902: END IF;

Line 899: ( FND_LOG.level_statement

895:
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement
900: , L_LOG_MODULE, 'l_charges_rec.txn_billing_type_id = ' || l_charges_rec.txn_billing_type_id
901: );
902: END IF;
903:

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

940: l_activity_end_date_time := l_labor_end_date_time;
941: l_add_one_minute := 'N';
942: END IF;
943:
944: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
945: THEN
946: FND_LOG.String
947: ( FND_LOG.level_statement
948: , 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 946: FND_LOG.String

942: END IF;
943:
944: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
945: THEN
946: FND_LOG.String
947: ( FND_LOG.level_statement
948: , 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')
949: );
950: END IF;

Line 947: ( FND_LOG.level_statement

943:
944: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
945: THEN
946: FND_LOG.String
947: ( FND_LOG.level_statement
948: , 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')
949: );
950: END IF;
951: --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 958: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

954: -- Fixed the issue to resolve Bug # 5024792
955:
956: IF l_contract_service_id IS NOT NULL THEN -- If contract exists.
957:
958: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
959: THEN
960: FND_LOG.String
961: ( FND_LOG.level_statement
962: , L_LOG_MODULE, '-- Contract exists.'

Line 960: FND_LOG.String

956: IF l_contract_service_id IS NOT NULL THEN -- If contract exists.
957:
958: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
959: THEN
960: FND_LOG.String
961: ( FND_LOG.level_statement
962: , L_LOG_MODULE, '-- Contract exists.'
963: );
964: END IF;

Line 961: ( FND_LOG.level_statement

957:
958: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
959: THEN
960: FND_LOG.String
961: ( FND_LOG.level_statement
962: , L_LOG_MODULE, '-- Contract exists.'
963: );
964: END IF;
965: --DBMS_OUTPUT.PUT_LINE('-- Contract exists.');

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

1001: Consolidate_Labor_Coverages(
1002: p_lbr_in_tbl => l_con_lbr_coverage_tbl,
1003: x_lbr_out_tbl => x_con_lbr_coverage_tbl);
1004:
1005: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1006: THEN
1007: FND_LOG.String
1008: ( FND_LOG.level_statement
1009: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count

Line 1007: FND_LOG.String

1003: x_lbr_out_tbl => x_con_lbr_coverage_tbl);
1004:
1005: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1006: THEN
1007: FND_LOG.String
1008: ( FND_LOG.level_statement
1009: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count
1010: );
1011: END IF;

Line 1008: ( FND_LOG.level_statement

1004:
1005: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1006: THEN
1007: FND_LOG.String
1008: ( FND_LOG.level_statement
1009: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl.count =' || x_con_lbr_coverage_tbl.count
1010: );
1011: END IF;
1012: --DBMS_OUTPUT.PUT_LINE('x_con_lbr_coverage_tbl.count = ' || x_con_lbr_coverage_tbl.count);

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

1019: -- If covered by contract.
1020: IF x_con_lbr_coverage_tbl(i).labor_item_id IS NOT NULL OR
1021: x_con_lbr_coverage_tbl(i).flat_rate IS NOT NULL THEN
1022:
1023: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1024: THEN
1025: FND_LOG.String
1026: ( FND_LOG.level_statement
1027: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'

Line 1025: FND_LOG.String

1021: x_con_lbr_coverage_tbl(i).flat_rate IS NOT NULL THEN
1022:
1023: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1024: THEN
1025: FND_LOG.String
1026: ( FND_LOG.level_statement
1027: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'
1028: );
1029: END IF;

Line 1026: ( FND_LOG.level_statement

1022:
1023: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1024: THEN
1025: FND_LOG.String
1026: ( FND_LOG.level_statement
1027: , L_LOG_MODULE, '-- Covered by Contract Labor Coverage.'
1028: );
1029: END IF;
1030: --DBMS_OUTPUT.PUT_LINE('-- Covered by Contract Labor Coverage.');

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

1075: l_charges_rec.rate_type_code := NULL;
1076: END IF;
1077:
1078:
1079: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1080: THEN
1081: FND_LOG.String
1082: ( FND_LOG.level_statement
1083: , 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 1081: FND_LOG.String

1077:
1078:
1079: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1080: THEN
1081: FND_LOG.String
1082: ( FND_LOG.level_statement
1083: , 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')
1084: );
1085: FND_LOG.String

Line 1082: ( FND_LOG.level_statement

1078:
1079: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1080: THEN
1081: FND_LOG.String
1082: ( FND_LOG.level_statement
1083: , 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')
1084: );
1085: FND_LOG.String
1086: ( FND_LOG.level_statement

Line 1085: FND_LOG.String

1081: FND_LOG.String
1082: ( FND_LOG.level_statement
1083: , 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')
1084: );
1085: FND_LOG.String
1086: ( FND_LOG.level_statement
1087: , 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')
1088: );
1089: FND_LOG.String

Line 1086: ( FND_LOG.level_statement

1082: ( FND_LOG.level_statement
1083: , 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')
1084: );
1085: FND_LOG.String
1086: ( FND_LOG.level_statement
1087: , 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')
1088: );
1089: FND_LOG.String
1090: ( FND_LOG.level_statement

Line 1089: FND_LOG.String

1085: FND_LOG.String
1086: ( FND_LOG.level_statement
1087: , 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')
1088: );
1089: FND_LOG.String
1090: ( FND_LOG.level_statement
1091: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1092: );
1093: FND_LOG.String

Line 1090: ( FND_LOG.level_statement

1086: ( FND_LOG.level_statement
1087: , 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')
1088: );
1089: FND_LOG.String
1090: ( FND_LOG.level_statement
1091: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1092: );
1093: FND_LOG.String
1094: ( FND_LOG.level_statement

Line 1093: FND_LOG.String

1089: FND_LOG.String
1090: ( FND_LOG.level_statement
1091: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1092: );
1093: FND_LOG.String
1094: ( FND_LOG.level_statement
1095: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1096: );
1097: FND_LOG.String

Line 1094: ( FND_LOG.level_statement

1090: ( FND_LOG.level_statement
1091: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').labor_item_id = ' || x_con_lbr_coverage_tbl(i).labor_item_id
1092: );
1093: FND_LOG.String
1094: ( FND_LOG.level_statement
1095: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1096: );
1097: FND_LOG.String
1098: ( FND_LOG.level_statement

Line 1097: FND_LOG.String

1093: FND_LOG.String
1094: ( FND_LOG.level_statement
1095: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1096: );
1097: FND_LOG.String
1098: ( FND_LOG.level_statement
1099: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1100: );
1101: FND_LOG.String

Line 1098: ( FND_LOG.level_statement

1094: ( FND_LOG.level_statement
1095: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate = ' || x_con_lbr_coverage_tbl(i).flat_rate
1096: );
1097: FND_LOG.String
1098: ( FND_LOG.level_statement
1099: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1100: );
1101: FND_LOG.String
1102: ( FND_LOG.level_statement

Line 1101: FND_LOG.String

1097: FND_LOG.String
1098: ( FND_LOG.level_statement
1099: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1100: );
1101: FND_LOG.String
1102: ( FND_LOG.level_statement
1103: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1104: );
1105: FND_LOG.String

Line 1102: ( FND_LOG.level_statement

1098: ( FND_LOG.level_statement
1099: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').flat_rate_uom_code = ' || x_con_lbr_coverage_tbl(i).flat_rate_uom_code
1100: );
1101: FND_LOG.String
1102: ( FND_LOG.level_statement
1103: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1104: );
1105: FND_LOG.String
1106: ( FND_LOG.level_statement

Line 1105: FND_LOG.String

1101: FND_LOG.String
1102: ( FND_LOG.level_statement
1103: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1104: );
1105: FND_LOG.String
1106: ( FND_LOG.level_statement
1107: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1108: );
1109: FND_LOG.String

Line 1106: ( FND_LOG.level_statement

1102: ( FND_LOG.level_statement
1103: , L_LOG_MODULE, 'x_con_lbr_coverage_tbl('||i||').percent_over_listprice = ' || x_con_lbr_coverage_tbl(i).percent_over_listprice
1104: );
1105: FND_LOG.String
1106: ( FND_LOG.level_statement
1107: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1108: );
1109: FND_LOG.String
1110: ( FND_LOG.level_statement

Line 1109: FND_LOG.String

1105: FND_LOG.String
1106: ( FND_LOG.level_statement
1107: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1108: );
1109: FND_LOG.String
1110: ( FND_LOG.level_statement
1111: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1112: );
1113: FND_LOG.String

Line 1110: ( FND_LOG.level_statement

1106: ( FND_LOG.level_statement
1107: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1108: );
1109: FND_LOG.String
1110: ( FND_LOG.level_statement
1111: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1112: );
1113: FND_LOG.String
1114: ( FND_LOG.level_statement

Line 1113: FND_LOG.String

1109: FND_LOG.String
1110: ( FND_LOG.level_statement
1111: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1112: );
1113: FND_LOG.String
1114: ( FND_LOG.level_statement
1115: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1116: );
1117: FND_LOG.String

Line 1114: ( FND_LOG.level_statement

1110: ( FND_LOG.level_statement
1111: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1112: );
1113: FND_LOG.String
1114: ( FND_LOG.level_statement
1115: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1116: );
1117: FND_LOG.String
1118: ( FND_LOG.level_statement

Line 1117: FND_LOG.String

1113: FND_LOG.String
1114: ( FND_LOG.level_statement
1115: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1116: );
1117: FND_LOG.String
1118: ( FND_LOG.level_statement
1119: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1120: );
1121: END IF;

Line 1118: ( FND_LOG.level_statement

1114: ( FND_LOG.level_statement
1115: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1116: );
1117: FND_LOG.String
1118: ( FND_LOG.level_statement
1119: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1120: );
1121: END IF;
1122: --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 1170: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1166: END IF;
1167:
1168: ELSE -- Not covered by contract.
1169:
1170: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1171: THEN
1172: FND_LOG.String
1173: ( FND_LOG.level_statement
1174: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'

Line 1172: FND_LOG.String

1168: ELSE -- Not covered by contract.
1169:
1170: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1171: THEN
1172: FND_LOG.String
1173: ( FND_LOG.level_statement
1174: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1175: );
1176: FND_LOG.String

Line 1173: ( FND_LOG.level_statement

1169:
1170: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1171: THEN
1172: FND_LOG.String
1173: ( FND_LOG.level_statement
1174: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1175: );
1176: FND_LOG.String
1177: ( FND_LOG.level_statement

Line 1176: FND_LOG.String

1172: FND_LOG.String
1173: ( FND_LOG.level_statement
1174: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1175: );
1176: FND_LOG.String
1177: ( FND_LOG.level_statement
1178: , 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')
1179: );
1180: FND_LOG.String

Line 1177: ( FND_LOG.level_statement

1173: ( FND_LOG.level_statement
1174: , L_LOG_MODULE, '-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...'
1175: );
1176: FND_LOG.String
1177: ( FND_LOG.level_statement
1178: , 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')
1179: );
1180: FND_LOG.String
1181: ( FND_LOG.level_statement

Line 1180: FND_LOG.String

1176: FND_LOG.String
1177: ( FND_LOG.level_statement
1178: , 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')
1179: );
1180: FND_LOG.String
1181: ( FND_LOG.level_statement
1182: , 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')
1183: );
1184: END IF;

Line 1181: ( FND_LOG.level_statement

1177: ( FND_LOG.level_statement
1178: , 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')
1179: );
1180: FND_LOG.String
1181: ( FND_LOG.level_statement
1182: , 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')
1183: );
1184: END IF;
1185: --DBMS_OUTPUT.PUT_LINE('-- Not covered by Contract Labor Coverage. Calling TM Labor Coverage...');

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

1204: FND_MSG_PUB.ADD;
1205: RAISE EXCP_USER_DEFINED;
1206: END IF;
1207:
1208: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1209: THEN
1210: FND_LOG.String
1211: ( FND_LOG.level_statement
1212: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count

Line 1210: FND_LOG.String

1206: END IF;
1207:
1208: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1209: THEN
1210: FND_LOG.String
1211: ( FND_LOG.level_statement
1212: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count
1213: );
1214: END IF;

Line 1211: ( FND_LOG.level_statement

1207:
1208: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1209: THEN
1210: FND_LOG.String
1211: ( FND_LOG.level_statement
1212: , L_LOG_MODULE, 'x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count
1213: );
1214: END IF;
1215: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count);

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

1239: Null, 2, l_duration, l_base_uom, l_primary_uom, NULL, NULL);
1240: l_charges_rec.list_price := NULL;
1241: l_charges_rec.con_pct_over_list_price := NULL;
1242:
1243: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1244: THEN
1245: FND_LOG.String
1246: ( FND_LOG.level_statement
1247: , L_LOG_MODULE, '- TM Labor Coverage.'

Line 1245: FND_LOG.String

1241: l_charges_rec.con_pct_over_list_price := NULL;
1242:
1243: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1244: THEN
1245: FND_LOG.String
1246: ( FND_LOG.level_statement
1247: , L_LOG_MODULE, '- TM Labor Coverage.'
1248: );
1249: FND_LOG.String

Line 1246: ( FND_LOG.level_statement

1242:
1243: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1244: THEN
1245: FND_LOG.String
1246: ( FND_LOG.level_statement
1247: , L_LOG_MODULE, '- TM Labor Coverage.'
1248: );
1249: FND_LOG.String
1250: ( FND_LOG.level_statement

Line 1249: FND_LOG.String

1245: FND_LOG.String
1246: ( FND_LOG.level_statement
1247: , L_LOG_MODULE, '- TM Labor Coverage.'
1248: );
1249: FND_LOG.String
1250: ( FND_LOG.level_statement
1251: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id
1252: );
1253: FND_LOG.String

Line 1250: ( FND_LOG.level_statement

1246: ( FND_LOG.level_statement
1247: , L_LOG_MODULE, '- TM Labor Coverage.'
1248: );
1249: FND_LOG.String
1250: ( FND_LOG.level_statement
1251: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id
1252: );
1253: FND_LOG.String
1254: ( FND_LOG.level_statement

Line 1253: FND_LOG.String

1249: FND_LOG.String
1250: ( FND_LOG.level_statement
1251: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id
1252: );
1253: FND_LOG.String
1254: ( FND_LOG.level_statement
1255: , 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')
1256: );
1257: FND_LOG.String

Line 1254: ( FND_LOG.level_statement

1250: ( FND_LOG.level_statement
1251: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id
1252: );
1253: FND_LOG.String
1254: ( FND_LOG.level_statement
1255: , 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')
1256: );
1257: FND_LOG.String
1258: ( FND_LOG.level_statement

Line 1257: FND_LOG.String

1253: FND_LOG.String
1254: ( FND_LOG.level_statement
1255: , 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')
1256: );
1257: FND_LOG.String
1258: ( FND_LOG.level_statement
1259: , 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')
1260: );
1261: FND_LOG.String

Line 1258: ( FND_LOG.level_statement

1254: ( FND_LOG.level_statement
1255: , 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')
1256: );
1257: FND_LOG.String
1258: ( FND_LOG.level_statement
1259: , 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')
1260: );
1261: FND_LOG.String
1262: ( FND_LOG.level_statement

Line 1261: FND_LOG.String

1257: FND_LOG.String
1258: ( FND_LOG.level_statement
1259: , 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')
1260: );
1261: FND_LOG.String
1262: ( FND_LOG.level_statement
1263: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1264: );
1265: FND_LOG.String

Line 1262: ( FND_LOG.level_statement

1258: ( FND_LOG.level_statement
1259: , 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')
1260: );
1261: FND_LOG.String
1262: ( FND_LOG.level_statement
1263: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1264: );
1265: FND_LOG.String
1266: ( FND_LOG.level_statement

Line 1265: FND_LOG.String

1261: FND_LOG.String
1262: ( FND_LOG.level_statement
1263: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1264: );
1265: FND_LOG.String
1266: ( FND_LOG.level_statement
1267: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1268: );
1269: FND_LOG.String

Line 1266: ( FND_LOG.level_statement

1262: ( FND_LOG.level_statement
1263: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' || TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1264: );
1265: FND_LOG.String
1266: ( FND_LOG.level_statement
1267: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1268: );
1269: FND_LOG.String
1270: ( FND_LOG.level_statement

Line 1269: FND_LOG.String

1265: FND_LOG.String
1266: ( FND_LOG.level_statement
1267: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1268: );
1269: FND_LOG.String
1270: ( FND_LOG.level_statement
1271: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1272: );
1273: FND_LOG.String

Line 1270: ( FND_LOG.level_statement

1266: ( FND_LOG.level_statement
1267: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1268: );
1269: FND_LOG.String
1270: ( FND_LOG.level_statement
1271: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1272: );
1273: FND_LOG.String
1274: ( FND_LOG.level_statement

Line 1273: FND_LOG.String

1269: FND_LOG.String
1270: ( FND_LOG.level_statement
1271: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1272: );
1273: FND_LOG.String
1274: ( FND_LOG.level_statement
1275: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1276: );
1277: FND_LOG.String

Line 1274: ( FND_LOG.level_statement

1270: ( FND_LOG.level_statement
1271: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1272: );
1273: FND_LOG.String
1274: ( FND_LOG.level_statement
1275: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1276: );
1277: FND_LOG.String
1278: ( FND_LOG.level_statement

Line 1277: FND_LOG.String

1273: FND_LOG.String
1274: ( FND_LOG.level_statement
1275: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1276: );
1277: FND_LOG.String
1278: ( FND_LOG.level_statement
1279: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1280: );
1281: END IF;

Line 1278: ( FND_LOG.level_statement

1274: ( FND_LOG.level_statement
1275: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1276: );
1277: FND_LOG.String
1278: ( FND_LOG.level_statement
1279: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1280: );
1281: END IF;
1282: --DBMS_OUTPUT.PUT_LINE('- TM Labor Coverage.');

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

1332: END LOOP;
1333:
1334: ELSE -- No contract.
1335:
1336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1337: THEN
1338: FND_LOG.String
1339: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1340: );

Line 1338: FND_LOG.String

1334: ELSE -- No contract.
1335:
1336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1337: THEN
1338: FND_LOG.String
1339: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1340: );
1341: END IF;
1342: --DBMS_OUTPUT.PUT_LINE('-- No contract. Calling TM Labor Coverage...');

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

1335:
1336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1337: THEN
1338: FND_LOG.String
1339: ( FND_LOG.level_statement, L_LOG_MODULE, '-- No contract. Calling TM Labor Coverage...'
1340: );
1341: END IF;
1342: --DBMS_OUTPUT.PUT_LINE('-- No contract. Calling TM Labor Coverage...');
1343:

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

1359: FND_MSG_PUB.ADD;
1360: RAISE EXCP_USER_DEFINED;
1361: END IF;
1362:
1363: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1364: THEN
1365: FND_LOG.String
1366: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1367: , x_tm_coverage_tbl.count

Line 1365: FND_LOG.String

1361: END IF;
1362:
1363: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1364: THEN
1365: FND_LOG.String
1366: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1367: , x_tm_coverage_tbl.count
1368: );
1369: END IF;

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

1362:
1363: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1364: THEN
1365: FND_LOG.String
1366: ( FND_LOG.level_statement, L_LOG_MODULE || 'x_tm_coverage_tbl.count = '
1367: , x_tm_coverage_tbl.count
1368: );
1369: END IF;
1370: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl.count = ' || x_tm_coverage_tbl.count);

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

1394: Null, 2, l_duration, l_base_uom, l_primary_uom, NULL, NULL);
1395: l_charges_rec.list_price := NULL;
1396: l_charges_rec.con_pct_over_list_price := NULL;
1397:
1398: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1399: THEN
1400: FND_LOG.String
1401: ( FND_LOG.level_statement
1402: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id

Line 1400: FND_LOG.String

1396: l_charges_rec.con_pct_over_list_price := NULL;
1397:
1398: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1399: THEN
1400: FND_LOG.String
1401: ( FND_LOG.level_statement
1402: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1403: );
1404: FND_LOG.String

Line 1401: ( FND_LOG.level_statement

1397:
1398: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1399: THEN
1400: FND_LOG.String
1401: ( FND_LOG.level_statement
1402: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1403: );
1404: FND_LOG.String
1405: ( FND_LOG.level_statement

Line 1404: FND_LOG.String

1400: FND_LOG.String
1401: ( FND_LOG.level_statement
1402: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1403: );
1404: FND_LOG.String
1405: ( FND_LOG.level_statement
1406: , 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')
1407: );
1408: FND_LOG.String

Line 1405: ( FND_LOG.level_statement

1401: ( FND_LOG.level_statement
1402: , L_LOG_MODULE, 'x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl('||j||').inventory_item_id
1403: );
1404: FND_LOG.String
1405: ( FND_LOG.level_statement
1406: , 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')
1407: );
1408: FND_LOG.String
1409: ( FND_LOG.level_statement

Line 1408: FND_LOG.String

1404: FND_LOG.String
1405: ( FND_LOG.level_statement
1406: , 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')
1407: );
1408: FND_LOG.String
1409: ( FND_LOG.level_statement
1410: , 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')
1411: );
1412: FND_LOG.String

Line 1409: ( FND_LOG.level_statement

1405: ( FND_LOG.level_statement
1406: , 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')
1407: );
1408: FND_LOG.String
1409: ( FND_LOG.level_statement
1410: , 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')
1411: );
1412: FND_LOG.String
1413: ( FND_LOG.level_statement

Line 1412: FND_LOG.String

1408: FND_LOG.String
1409: ( FND_LOG.level_statement
1410: , 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')
1411: );
1412: FND_LOG.String
1413: ( FND_LOG.level_statement
1414: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1415: );
1416: FND_LOG.String

Line 1413: ( FND_LOG.level_statement

1409: ( FND_LOG.level_statement
1410: , 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')
1411: );
1412: FND_LOG.String
1413: ( FND_LOG.level_statement
1414: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1415: );
1416: FND_LOG.String
1417: ( FND_LOG.level_statement

Line 1416: FND_LOG.String

1412: FND_LOG.String
1413: ( FND_LOG.level_statement
1414: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1415: );
1416: FND_LOG.String
1417: ( FND_LOG.level_statement
1418: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1419: );
1420: FND_LOG.String

Line 1417: ( FND_LOG.level_statement

1413: ( FND_LOG.level_statement
1414: , L_LOG_MODULE, 'l_charges_rec.activity_end_time = ' ||TO_CHAR(l_charges_rec.activity_end_time, 'DD-MON-YYYY HH24:MI:SS')
1415: );
1416: FND_LOG.String
1417: ( FND_LOG.level_statement
1418: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1419: );
1420: FND_LOG.String
1421: ( FND_LOG.level_statement

Line 1420: FND_LOG.String

1416: FND_LOG.String
1417: ( FND_LOG.level_statement
1418: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1419: );
1420: FND_LOG.String
1421: ( FND_LOG.level_statement
1422: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1423: );
1424: FND_LOG.String

Line 1421: ( FND_LOG.level_statement

1417: ( FND_LOG.level_statement
1418: , L_LOG_MODULE, 'l_charges_rec.unit_of_measure_code = ' || l_charges_rec.unit_of_measure_code
1419: );
1420: FND_LOG.String
1421: ( FND_LOG.level_statement
1422: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1423: );
1424: FND_LOG.String
1425: ( FND_LOG.level_statement

Line 1424: FND_LOG.String

1420: FND_LOG.String
1421: ( FND_LOG.level_statement
1422: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1423: );
1424: FND_LOG.String
1425: ( FND_LOG.level_statement
1426: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1427: );
1428: FND_LOG.String

Line 1425: ( FND_LOG.level_statement

1421: ( FND_LOG.level_statement
1422: , L_LOG_MODULE, 'l_charges_rec.quantity_required = ' || l_charges_rec.quantity_required
1423: );
1424: FND_LOG.String
1425: ( FND_LOG.level_statement
1426: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1427: );
1428: FND_LOG.String
1429: ( FND_LOG.level_statement

Line 1428: FND_LOG.String

1424: FND_LOG.String
1425: ( FND_LOG.level_statement
1426: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1427: );
1428: FND_LOG.String
1429: ( FND_LOG.level_statement
1430: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1431: );
1432: END IF;

Line 1429: ( FND_LOG.level_statement

1425: ( FND_LOG.level_statement
1426: , L_LOG_MODULE, 'l_charges_rec.list_price = ' || l_charges_rec.list_price
1427: );
1428: FND_LOG.String
1429: ( FND_LOG.level_statement
1430: , L_LOG_MODULE, 'l_charges_rec.con_pct_over_list_price = ' || l_charges_rec.con_pct_over_list_price
1431: );
1432: END IF;
1433: --DBMS_OUTPUT.PUT_LINE('x_tm_coverage_tbl('||j||').inventory_item_id = ' || x_tm_coverage_tbl(j).inventory_item_id);

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

1492: CLOSE billing_category;
1493: -- End bug 7229344
1494:
1495:
1496: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1497: THEN
1498: FND_LOG.String
1499: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1500: );

Line 1498: FND_LOG.String

1494:
1495:
1496: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1497: THEN
1498: FND_LOG.String
1499: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1500: );
1501:
1502: FND_LOG.String

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

1495:
1496: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1497: THEN
1498: FND_LOG.String
1499: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1500: );
1501:
1502: FND_LOG.String
1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category

Line 1502: FND_LOG.String

1498: FND_LOG.String
1499: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1500: );
1501:
1502: FND_LOG.String
1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category
1504: );
1505:
1506: FND_LOG.String

Line 1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category

1499: ( FND_LOG.level_statement, L_LOG_MODULE , '--- p_sbe_record.inventory_item_id is not null.'
1500: );
1501:
1502: FND_LOG.String
1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category
1504: );
1505:
1506: FND_LOG.String
1507: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_bill_category is '||l_bill_category

Line 1506: FND_LOG.String

1502: FND_LOG.String
1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category
1504: );
1505:
1506: FND_LOG.String
1507: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_bill_category is '||l_bill_category
1508: );
1509:
1510: END IF;

Line 1507: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_bill_category is '||l_bill_category

1503: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_billing_category is '||l_billing_category
1504: );
1505:
1506: FND_LOG.String
1507: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_bill_category is '||l_bill_category
1508: );
1509:
1510: END IF;
1511: -- DBMS_OUTPUT.PUT_LINE('--- p_sbe_record.inventory_item_id is not null.');

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

1630: END IF;
1631:
1632: END IF; -- inventory_item_id check
1633:
1634: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1635: THEN
1636: FND_LOG.String
1637: ( 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')
1638: );

Line 1636: FND_LOG.String

1632: END IF; -- inventory_item_id check
1633:
1634: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1635: THEN
1636: FND_LOG.String
1637: ( 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')
1638: );
1639: END IF;
1640: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));

Line 1637: ( 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')

1633:
1634: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1635: THEN
1636: FND_LOG.String
1637: ( 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')
1638: );
1639: END IF;
1640: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));
1641: --DBMS_OUTPUT.PUT_LINE('Return status = ' || x_return_status);

Line 1750: ----------------------- FND Logging -----------------------------------

1746: THEN
1747: FND_MSG_PUB.initialize;
1748: END IF;
1749:
1750: ----------------------- FND Logging -----------------------------------
1751: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1752: THEN
1753: FND_LOG.String
1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

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

1747: FND_MSG_PUB.initialize;
1748: END IF;
1749:
1750: ----------------------- FND Logging -----------------------------------
1751: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1752: THEN
1753: FND_LOG.String
1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1755: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 1753: FND_LOG.String

1749:
1750: ----------------------- FND Logging -----------------------------------
1751: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1752: THEN
1753: FND_LOG.String
1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1755: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1756: );
1757: FND_LOG.String

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

1750: ----------------------- FND Logging -----------------------------------
1751: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1752: THEN
1753: FND_LOG.String
1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1755: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1756: );
1757: FND_LOG.String
1758: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1757: FND_LOG.String

1753: FND_LOG.String
1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1755: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1756: );
1757: FND_LOG.String
1758: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1759: , 'P_Api_Version_Number:' || P_Api_Version_Number
1760: );
1761: FND_LOG.String

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

1754: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
1755: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
1756: );
1757: FND_LOG.String
1758: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1759: , 'P_Api_Version_Number:' || P_Api_Version_Number
1760: );
1761: FND_LOG.String
1762: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1761: FND_LOG.String

1757: FND_LOG.String
1758: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1759: , 'P_Api_Version_Number:' || P_Api_Version_Number
1760: );
1761: FND_LOG.String
1762: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1763: , 'p_init_msg_list:' || p_init_msg_list
1764: );
1765: FND_LOG.String

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

1758: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1759: , 'P_Api_Version_Number:' || P_Api_Version_Number
1760: );
1761: FND_LOG.String
1762: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1763: , 'p_init_msg_list:' || p_init_msg_list
1764: );
1765: FND_LOG.String
1766: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1765: FND_LOG.String

1761: FND_LOG.String
1762: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1763: , 'p_init_msg_list:' || p_init_msg_list
1764: );
1765: FND_LOG.String
1766: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1767: , 'p_commit:' || p_commit
1768: );
1769: FND_LOG.String

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

1762: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1763: , 'p_init_msg_list:' || p_init_msg_list
1764: );
1765: FND_LOG.String
1766: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1767: , 'p_commit:' || p_commit
1768: );
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1769: FND_LOG.String

1765: FND_LOG.String
1766: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1767: , 'p_commit:' || p_commit
1768: );
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1771: , 'p_incident_id:' || p_incident_id
1772: );
1773: FND_LOG.String

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

1766: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1767: , 'p_commit:' || p_commit
1768: );
1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1771: , 'p_incident_id:' || p_incident_id
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1773: FND_LOG.String

1769: FND_LOG.String
1770: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1771: , 'p_incident_id:' || p_incident_id
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_debrief_header_id:' || p_debrief_header_id
1776: );
1777: FND_LOG.String

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

1770: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1771: , 'p_incident_id:' || p_incident_id
1772: );
1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_debrief_header_id:' || p_debrief_header_id
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 1777: FND_LOG.String

1773: FND_LOG.String
1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_debrief_header_id:' || p_debrief_header_id
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_debrief_line_id:' || p_debrief_line_id
1780: );
1781: END IF;

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

1774: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1775: , 'p_debrief_header_id:' || p_debrief_header_id
1776: );
1777: FND_LOG.String
1778: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1779: , 'p_debrief_line_id:' || p_debrief_line_id
1780: );
1781: END IF;
1782:

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

1779: , 'p_debrief_line_id:' || p_debrief_line_id
1780: );
1781: END IF;
1782:
1783: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1784: THEN
1785: FND_LOG.String
1786: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1787: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')

Line 1785: FND_LOG.String

1781: END IF;
1782:
1783: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1784: THEN
1785: FND_LOG.String
1786: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1787: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1788: );
1789: END IF;

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

1782:
1783: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1784: THEN
1785: FND_LOG.String
1786: ( FND_LOG.level_statement, L_LOG_MODULE , '----- Private API:'
1787: || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1788: );
1789: END IF;
1790: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1830: LOOP
1831: FETCH in_progress_charges_csr into l_estimate_detail_id;
1832: EXIT WHEN in_progress_charges_csr%NOTFOUND;
1833:
1834: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1835: THEN
1836: FND_LOG.String
1837: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1838: , l_estimate_detail_id

Line 1836: FND_LOG.String

1832: EXIT WHEN in_progress_charges_csr%NOTFOUND;
1833:
1834: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1835: THEN
1836: FND_LOG.String
1837: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1838: , l_estimate_detail_id
1839: );
1840: END IF;

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

1833:
1834: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1835: THEN
1836: FND_LOG.String
1837: ( FND_LOG.level_statement, L_LOG_MODULE || 'Delete l_estimate_detail_id = '
1838: , l_estimate_detail_id
1839: );
1840: END IF;
1841: --DBMS_OUTPUT.PUT_LINE('Delete l_estimate_detail_id = ' || l_estimate_detail_id);

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

1866: IF FND_API.to_Boolean(p_commit) THEN
1867: COMMIT;
1868: END IF;
1869:
1870: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1871: THEN
1872: FND_LOG.String
1873: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1874: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')

Line 1872: FND_LOG.String

1868: END IF;
1869:
1870: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1871: THEN
1872: FND_LOG.String
1873: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1874: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1875: );
1876: END IF;

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

1869:
1870: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1871: THEN
1872: FND_LOG.String
1873: ( FND_LOG.level_statement, L_LOG_MODULE || 'Private API:'
1874: , g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS')
1875: );
1876: END IF;
1877: --DBMS_OUTPUT.PUT_LINE('Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));