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

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_LOGGER

Line 28: l_params wip_logger.param_tbl_t;

24: x_ReturnStatus OUT NOCOPY VARCHAR2
25: )
26: IS
27:
28: l_params wip_logger.param_tbl_t;
29: l_return_Status VARCHAR2(1);
30: l_msg VARCHAR(240);
31: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
32: l_number_temp NUMBER ;

Line 41: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.populate_close_temp',

37:
38: IF (l_logLevel <= wip_constants.trace_logging) THEN
39: l_params(1).paramName := 'p_organization_id';
40: l_params(1).paramValue := p_organization_id ;
41: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.populate_close_temp',
42: p_params => l_params,
43: x_returnStatus => l_return_Status);
44: END IF;
45:

Line 173: wip_logger.exitPoint(

169: --
170: -- Bug 5345660 exitPoint for normal exit.
171: --
172: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
173: wip_logger.exitPoint(
174: p_procName => 'wip_close_priv.populate_close_temp',
175: p_procReturnStatus => x_returnStatus,
176: p_msg => 'procedure normal exit',
177: x_returnStatus => l_return_status);

Line 188: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',

184: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
185: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
186:
187: IF (l_logLevel <= wip_constants.trace_logging) THEN
188: wip_logger.exitPoint(p_procName=>'wip_close_priv.populate_close_temp',
189: p_procReturnStatus => x_returnStatus,
190: p_msg => l_msg,
191: x_returnStatus => l_return_Status);
192: END IF;

Line 217: l_params wip_logger.param_tbl_t;

213: x_to_completion_date OUT NOCOPY DATE ,
214: x_act_close_date OUT NOCOPY DATE ,
215: x_returnstatus OUT NOCOPY VARCHAR2
216: )IS
217: l_params wip_logger.param_tbl_t;
218: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
219: l_return_status VARCHAR2(1) ;
220: l_msg_count NUMBER ;
221: l_msg_data VARCHAR2(200);

Line 237: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.time_zone_conversion',

233: l_params(5).paramName := 'p_from_completion_date';
234: l_params(5).paramValue := p_from_completion_date ;
235: l_params(6).paramName := 'p_to_completion_date';
236: l_params(6).paramValue := p_to_completion_date ;
237: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.time_zone_conversion',
238: p_params => l_params,
239: x_returnStatus => l_return_Status);
240: END IF;
241: x_ReturnStatus := fnd_api.g_ret_sts_success ;

Line 345: wip_logger.exitPoint(

341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:
344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
345: wip_logger.exitPoint(
346: p_procName => 'wip_close_priv.time_zone_conversions',
347: p_procReturnStatus => x_returnStatus,
348: p_msg => 'procedure normal exit',
349: x_returnStatus => l_return_status);

Line 357: wip_logger.exitPoint(

353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
355:
356: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
357: wip_logger.exitPoint(
358: p_procName=>'wip_close_priv.time_zone_conversions',
359: p_procReturnStatus => x_returnStatus,
360: p_msg => l_msg,
361: x_returnStatus => l_return_Status);

Line 380: l_params wip_logger.param_tbl_t;

376:
377: --
378: -- Bug 5148397
379: --
380: l_params wip_logger.param_tbl_t;
381: l_return_status VARCHAR2(1);
382: l_msg VARCHAR(2000);
383: l_failed_counter NUMBER;
384: l_failed_ids dbms_sql.number_table;

Line 393: wip_logger.entryPoint(

389: l_params(1).paramName := 'p_organization_id';
390: l_params(1).paramValue := p_organization_id;
391: l_params(2).paramName := 'p_group_id';
392: l_params(2).paramValue := p_group_id;
393: wip_logger.entryPoint(
394: p_procName => 'wip_jobclose_priv.prior_date_release',
395: p_params => l_params,
396: x_returnStatus => l_return_status);
397: END IF;

Line 444: wip_logger.exitPoint(

440: --
441: -- Bug 5345660 exitPoint for normal exit.
442: --
443: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
444: wip_logger.exitPoint(
445: p_procName => 'wip_close_priv.prior_date_release',
446: p_procReturnStatus => x_returnStatus,
447: p_msg => 'procedure normal exit',
448: x_returnStatus => l_return_status);

Line 457: wip_logger.exitPoint(

453: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
454: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
455:
456: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
457: wip_logger.exitPoint(
458: p_procName=>'wip_close_priv.prior_date_release',
459: p_procReturnStatus => x_returnStatus,
460: p_msg => l_msg,
461: x_returnStatus => l_return_Status);

Line 477: l_params wip_logger.param_tbl_t;

473: p_organization_id IN NUMBER ,
474: p_group_id IN NUMBER
475: )
476: IS
477: l_params wip_logger.param_tbl_t;
478: l_return_Status VARCHAR2(1);
479: l_msg VARCHAR(240);
480: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
481:

Line 538: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_txns',

534: l_params(1).paramName := 'p_organization_id';
535: l_params(1).paramValue := p_organization_id ;
536: l_params(1).paramName := 'p_group_id';
537: l_params(1).paramValue := p_group_id ;
538: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_txns',
539: p_params => l_params,
540: x_returnStatus => l_return_Status);
541: END IF;
542: x_returnStatus := fnd_api.g_ret_sts_success;

Line 586: wip_logger.exitPoint(

582: --
583: -- Bug 5345660 exitPoint for normal exit.
584: --
585: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
586: wip_logger.exitPoint(
587: p_procName => 'wip_close_priv.pending_txns',
588: p_procReturnStatus => x_returnStatus,
589: p_msg => 'procedure normal exit',
590: x_returnStatus => l_return_status);

Line 602: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',

598: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
599: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
600:
601: IF (l_logLevel <= wip_constants.trace_logging) THEN
602: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_txns',
603: p_procReturnStatus => x_returnStatus,
604: p_msg => l_msg,
605: x_returnStatus => l_return_Status);
606: END IF;

Line 674: l_params wip_logger.param_tbl_t;

670: and wdct.organization_id = p_organization_id;
671:
672: l_ret_status VARCHAR2(30);
673: l_msg_data VARCHAR2(2000);
674: l_params wip_logger.param_tbl_t;
675: l_return_Status VARCHAR2(1);
676: l_msg VARCHAR(240);
677: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
678: l_failed_counter NUMBER ;

Line 685: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_clocks',

681: l_params(1).paramName := 'p_organization_id';
682: l_params(1).paramValue := p_organization_id ;
683: l_params(1).paramName := 'p_group_id';
684: l_params(1).paramValue := p_group_id ;
685: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.pending_clocks',
686: p_params => l_params,
687: x_returnStatus => l_return_Status);
688: END IF;
689: x_returnstatus := FND_API.G_RET_STS_SUCCESS;

Line 728: wip_logger.exitPoint(

724: --
725: -- Bug 5345660 exitPoint for normal exit.
726: --
727: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
728: wip_logger.exitPoint(
729: p_procName => 'wip_close_priv.pending_clocks',
730: p_procReturnStatus => x_returnStatus,
731: p_msg => 'procedure normal exit',
732: x_returnStatus => l_return_status);

Line 744: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',

740: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
741: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
742:
743: IF (l_logLevel <= wip_constants.trace_logging) THEN
744: wip_logger.exitPoint(p_procName=>'wip_close_priv.pending_clocks',
745: p_procReturnStatus => x_returnStatus,
746: p_msg => l_msg,
747: x_returnStatus => l_return_Status);
748: END IF;

Line 868: l_params wip_logger.param_tbl_t;

864:
865: )
866: IS
867:
868: l_params wip_logger.param_tbl_t;
869: l_return_Status VARCHAR2(1);
870: l_msg VARCHAR(240);
871: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
872:

Line 907: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.past_close_date',

903: l_params(1).paramName := 'p_organization_id';
904: l_params(1).paramValue := p_organization_id ;
905: l_params(1).paramName := 'p_group_id';
906: l_params(1).paramValue := p_group_id ;
907: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.past_close_date',
908: p_params => l_params,
909: x_returnStatus => l_return_Status);
910: END IF;
911:

Line 953: wip_logger.exitPoint(

949: --
950: -- Bug 5345660 exitPoint for normal exit.
951: --
952: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
953: wip_logger.exitPoint(
954: p_procName => 'wip_close_priv.past_close_date',
955: p_procReturnStatus => x_returnStatus,
956: p_msg => 'procedure normal exit',
957: x_returnStatus => l_return_status);

Line 968: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',

964: END IF;
965: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
966: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
967: IF (l_logLevel <= wip_constants.trace_logging) THEN
968: wip_logger.exitPoint(p_procName=>'wip_close_priv.past_close_date',
969: p_procReturnStatus => x_returnStatus,
970: p_msg => l_msg,
971: x_returnStatus => l_return_Status);
972: END IF;

Line 986: l_params wip_logger.param_tbl_t;

982: p_group_id IN NUMBER
983: )
984: IS
985:
986: l_params wip_logger.param_tbl_t;
987: l_return_Status VARCHAR2(1);
988: l_msg VARCHAR(240);
989: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
990:

Line 1042: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_open_po',

1038: l_params(1).paramName := 'p_organization_id';
1039: l_params(1).paramValue := p_organization_id ;
1040: l_params(1).paramName := 'p_group_id';
1041: l_params(1).paramValue := p_group_id ;
1042: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.check_open_po',
1043: p_params => l_params,
1044: x_returnStatus => l_return_Status);
1045: END IF;
1046: x_returnStatus := fnd_api.g_ret_sts_success;

Line 1076: wip_logger.exitPoint(

1072: --
1073: -- Bug 5345660 exitPoint for normal exit.
1074: --
1075: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1076: wip_logger.exitPoint(
1077: p_procName => 'wip_close_priv.check_open_po',
1078: p_procReturnStatus => x_returnStatus,
1079: p_msg => 'procedure normal exit',
1080: x_returnStatus => l_return_status);

Line 1092: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',

1088: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1089: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1090:
1091: IF (l_logLevel <= wip_constants.trace_logging) THEN
1092: wip_logger.exitPoint(p_procName=>'wip_close_priv.check_open_po',
1093: p_procReturnStatus => x_returnStatus,
1094: p_msg => l_msg,
1095: x_returnStatus => l_return_Status);
1096: END IF;

Line 1115: l_params wip_logger.param_tbl_t;

1111: l_error_code number;
1112: l_err_msg varchar2(1000);
1113: l_wsm_org number ;
1114: l_return_status Varchar2(1);
1115: l_params wip_logger.param_tbl_t;
1116: l_msg VARCHAR(240);
1117: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1118:
1119: BEGIN

Line 1127: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.lot_validate',

1123: l_params(1).paramName := 'p_organization_id';
1124: l_params(1).paramValue := p_organization_id ;
1125: l_params(1).paramName := 'p_group_id';
1126: l_params(1).paramValue := p_group_id ;
1127: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.lot_validate',
1128: p_params => l_params,
1129: x_returnStatus => l_return_Status);
1130: END IF;
1131:

Line 1147: wip_logger.exitPoint(

1143: --
1144: -- Bug 5345660 exitPoint for normal exit.
1145: --
1146: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1147: wip_logger.exitPoint(
1148: p_procName => 'wip_close_priv.lot_validate',
1149: p_procReturnStatus => x_returnStatus,
1150: p_msg => 'procedure normal exit',
1151: x_returnStatus => l_return_status);

Line 1159: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',

1155: WHEN others THEN
1156: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1157: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1158: IF (l_logLevel <= wip_constants.trace_logging) THEN
1159: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.lot_validate',
1160: p_procReturnStatus => x_returnStatus,
1161: p_msg => l_msg,
1162: x_returnStatus => l_return_Status);
1163: END IF;

Line 1179: l_params wip_logger.param_tbl_t;

1175: p_group_id IN NUMBER
1176:
1177: )
1178: IS
1179: l_params wip_logger.param_tbl_t;
1180: l_return_Status VARCHAR2(1);
1181: l_msg VARCHAR(240);
1182: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1183: l_rsv inv_reservation_global.mtl_reservation_rec_type;

Line 1205: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.delete_reservation',

1201: l_params(1).paramName := 'p_organization_id';
1202: l_params(1).paramValue := p_organization_id ;
1203: l_params(1).paramName := 'p_group_id';
1204: l_params(1).paramValue := p_group_id ;
1205: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.delete_reservation',
1206: p_params => l_params,
1207: x_returnStatus => l_return_Status);
1208: END IF;
1209: OPEN C_del_reservation ;

Line 1236: wip_logger.exitPoint(

1232: --
1233: -- Bug 5345660 exitPoint for normal exit.
1234: --
1235: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1236: wip_logger.exitPoint(
1237: p_procName => 'wip_close_priv.delete_reservation',
1238: p_procReturnStatus => x_returnStatus,
1239: p_msg => 'procedure normal exit',
1240: x_returnStatus => l_return_status);

Line 1252: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',

1248: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1249: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1250:
1251: IF (l_logLevel <= wip_constants.trace_logging) THEN
1252: wip_logger.exitPoint(p_procName=>'wip_jobclose_priv.delete_reservation',
1253: p_procReturnStatus => x_returnStatus,
1254: p_msg => l_msg,
1255: x_returnStatus => l_return_Status);
1256: END IF;

Line 1638: l_params wip_logger.param_tbl_t;

1634: l_msg_count NUMBER;
1635: l_msg_data VARCHAR2(200);
1636: l_msg VARCHAR2(2000);
1637: l_req_id NUMBER;
1638: l_params wip_logger.param_tbl_t;
1639: l_errMsg VARCHAR2(240);
1640: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1641:
1642: BEGIN

Line 1672: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.wip_close',

1668: l_params(7).paramName := 'p_from_release_date';
1669: l_params(7).paramValue := p_from_release_date;
1670: l_params(8).paramName := 'p_to_release_date';
1671: l_params(8).paramValue := p_to_release_date;
1672: wip_logger.entryPoint(p_procName => 'wip_jobclose_priv.wip_close',
1673: p_params => l_params,
1674: x_returnStatus => l_return_Status);
1675: END IF;
1676:

Line 1703: wip_logger.log(p_msg => 'time zone conversion failed',

1699: x_returnstatus => l_return_status
1700: );
1701: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1702: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1703: wip_logger.log(p_msg => 'time zone conversion failed',
1704: x_returnStatus => l_return_Status);
1705: END IF;
1706: RAISE FND_API.G_EXC_ERROR ;
1707: END IF;

Line 1780: wip_logger.log(p_msg => 'populate_close_temp',

1776: x_ReturnStatus => l_return_status
1777: );
1778: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1779: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1780: wip_logger.log(p_msg => 'populate_close_temp',
1781: x_returnStatus => l_return_Status);
1782: END IF;
1783: RAISE FND_API.G_EXC_ERROR ;
1784: END IF;

Line 1796: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,

1792: );
1793:
1794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1795: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1796: wip_logger.log(p_msg => 'error during eam update workflow to pending close' || l_errMsg,
1797: x_returnStatus => l_return_Status);
1798: END IF;
1799: RAISE FND_API.G_EXC_ERROR ;
1800: END IF;

Line 1828: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,

1824: );
1825:
1826: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1827: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1828: wip_logger.log(p_msg => 'eam update workoder error during pending close ' || l_errMsg,
1829: x_returnStatus => l_return_Status);
1830: END IF;
1831: RAISE FND_API.G_EXC_ERROR ;
1832: END IF;

Line 1868: -- Bug 5345660 Added profile check before invoking wip_logger

1864: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1865: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1866: x_warning := 1 ;
1867: --
1868: -- Bug 5345660 Added profile check before invoking wip_logger
1869: --
1870: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1871: wip_logger.log(p_msg => l_msg,
1872: x_returnStatus => l_return_Status);

Line 1871: wip_logger.log(p_msg => l_msg,

1867: --
1868: -- Bug 5345660 Added profile check before invoking wip_logger
1869: --
1870: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1871: wip_logger.log(p_msg => l_msg,
1872: x_returnStatus => l_return_Status);
1873: END IF;
1874: END IF;
1875:

Line 1910: -- Bug 5345660 Added profile check before invoking wip_logger

1906: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1907: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1908: x_warning := 1 ;
1909: --
1910: -- Bug 5345660 Added profile check before invoking wip_logger
1911: --
1912: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1913: wip_logger.log(p_msg => l_msg,
1914: x_returnStatus => l_return_Status);

Line 1913: wip_logger.log(p_msg => l_msg,

1909: --
1910: -- Bug 5345660 Added profile check before invoking wip_logger
1911: --
1912: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1913: wip_logger.log(p_msg => l_msg,
1914: x_returnStatus => l_return_Status);
1915: END IF;
1916: END IF;
1917: /**********************************************************

Line 1936: -- Bug 5345660 Added profile check before invoking wip_logger

1932: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1933: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1934: x_warning := 1 ;
1935: --
1936: -- Bug 5345660 Added profile check before invoking wip_logger
1937: --
1938: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1939: wip_logger.log(p_msg => l_msg,
1940: x_returnStatus => l_return_Status);

Line 1939: wip_logger.log(p_msg => l_msg,

1935: --
1936: -- Bug 5345660 Added profile check before invoking wip_logger
1937: --
1938: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1939: wip_logger.log(p_msg => l_msg,
1940: x_returnStatus => l_return_Status);
1941: END IF;
1942: END IF;
1943:

Line 1963: -- Bug 5345660 Added profile check before invoking wip_logger

1959: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1960: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1961: x_warning := 1 ;
1962: --
1963: -- Bug 5345660 Added profile check before invoking wip_logger
1964: --
1965: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1966: wip_logger.log(p_msg => l_msg,
1967: x_returnStatus => l_return_Status);

Line 1966: wip_logger.log(p_msg => l_msg,

1962: --
1963: -- Bug 5345660 Added profile check before invoking wip_logger
1964: --
1965: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1966: wip_logger.log(p_msg => l_msg,
1967: x_returnStatus => l_return_Status);
1968: END IF;
1969: END IF;
1970:

Line 1989: -- Bug 5345660 Added profile check before invoking wip_logger

1985: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1986: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1987: x_warning := 1 ;
1988: --
1989: -- Bug 5345660 Added profile check before invoking wip_logger
1990: --
1991: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1992: wip_logger.log(p_msg => l_msg,
1993: x_returnStatus => l_return_Status);

Line 1992: wip_logger.log(p_msg => l_msg,

1988: --
1989: -- Bug 5345660 Added profile check before invoking wip_logger
1990: --
1991: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
1992: wip_logger.log(p_msg => l_msg,
1993: x_returnStatus => l_return_Status);
1994: END IF;
1995: END IF;
1996:

Line 2016: -- Bug 5345660 Added profile check before invoking wip_logger

2012: x_warning := 1 ;
2013: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
2014: l_msg := fnd_message.get;
2015: --
2016: -- Bug 5345660 Added profile check before invoking wip_logger
2017: --
2018: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2019: wip_logger.log(p_msg => l_msg,
2020: x_returnStatus => l_return_Status);

Line 2019: wip_logger.log(p_msg => l_msg,

2015: --
2016: -- Bug 5345660 Added profile check before invoking wip_logger
2017: --
2018: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2019: wip_logger.log(p_msg => l_msg,
2020: x_returnStatus => l_return_Status);
2021: END IF;
2022: END IF;
2023: END IF ;

Line 2037: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',

2033: p_organization_id => p_organization_id,
2034: p_group_id => l_group_id );
2035: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2036: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2037: wip_logger.log(p_msg => 'LOT_VALIDATE procedure failed',
2038: x_returnStatus => l_return_Status);
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR ;
2041: END IF;

Line 2057: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',

2053: p_group_id => l_group_id );
2054:
2055: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2057: wip_logger.log(p_msg => 'DELETE_RESERVATIONS procedure failed',
2058: x_returnStatus => l_return_Status);
2059: END IF;
2060: END IF;
2061:

Line 2175: wip_logger.log(p_msg => 'costing function error',

2171: );
2172: -- Bug 5370550
2173: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2174: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2175: wip_logger.log(p_msg => 'costing function error',
2176: x_returnStatus => l_return_Status);
2177: END IF;
2178: RAISE FND_API.G_EXC_ERROR ;
2179: END IF;

Line 2194: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,

2190: );
2191:
2192: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2193: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2194: wip_logger.log(p_msg => 'error during eam update workflow to closed' || l_errMsg,
2195: x_returnStatus => l_return_Status);
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR ;
2198: END IF;

Line 2210: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,

2206: );
2207:
2208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2209: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2210: wip_logger.log(p_msg => 'eam update workoder error while job close' || l_errMsg,
2211: x_returnStatus => l_return_Status);
2212: END IF;
2213: RAISE FND_API.G_EXC_ERROR ;
2214: END IF;

Line 2309: wip_logger.exitPoint(

2305: --
2306: -- Bug 5345660 exitPoint for normal exit.
2307: --
2308: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2309: wip_logger.exitPoint(
2310: p_procName => 'wip_close_priv.wip_close',
2311: p_procReturnStatus => x_returnStatus,
2312: p_msg => 'procedure normal exit',
2313: x_returnStatus => l_return_status);

Line 2335: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,

2331: );
2332:
2333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2334: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2335: wip_logger.log(p_msg => 'error during eam update workflow to fail closed' || l_errMsg,
2336: x_returnStatus => l_return_Status);
2337: END IF;
2338: RAISE FND_API.G_EXC_ERROR ;
2339: END IF;

Line 2351: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,

2347: );
2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2351: wip_logger.log(p_msg => 'eam update workoder error during fail close' || l_errMsg,
2352: x_returnStatus => l_return_Status);
2353: END IF;
2354: RAISE FND_API.G_EXC_ERROR ;
2355: END IF;

Line 2382: wip_logger.exitPoint(

2378: -- Bug 5345660 exitPoint for exception exit.
2379: --
2380: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2381: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
2382: wip_logger.exitPoint(
2383: p_procName => 'wip_close_priv.wip_close',
2384: p_procReturnStatus => x_returnStatus,
2385: p_msg => l_msg,
2386: x_returnStatus => l_return_status);