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.AHL_WIP_JOB_PVT dependencies on AHL_DEBUG_PUB

Line 9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

5: TYPE num_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6:
7: -- Define Global Variable --
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_WIP_JOB_PVT';
9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10:
11: -- Define Global Cursors --
12: CURSOR job_header_exists(c_group_id NUMBER, c_parent_header_id NUMBER) IS
13: SELECT 'X'

Line 253: AHL_DEBUG_PUB.debug('Finish: insert_job_header, x_return_status='||x_return_status);

249: END;
250: x_group_id := l_wip_job_rec.group_id;
251: x_header_id := l_wip_job_rec.header_id;
252: IF G_DEBUG='Y' THEN
253: AHL_DEBUG_PUB.debug('Finish: insert_job_header, x_return_status='||x_return_status);
254: --dbms_output.put_line('Finish: insert_job_header, x_return_status='||x_return_status);
255: END IF;
256: END insert_job_header;
257:

Line 409: AHL_DEBUG_PUB.debug('Finish: insert_job_operation, x_return_status='||x_return_status);

405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: RAISE;
407: END;
408: IF G_DEBUG='Y' THEN
409: AHL_DEBUG_PUB.debug('Finish: insert_job_operation, x_return_status='||x_return_status);
410: --dbms_output.put_line('Finish: insert_job_operation, x_return_status='||x_return_status);
411: END IF;
412: END insert_job_operation;
413:

Line 578: AHL_DEBUG_PUB.debug('Finish: insert_job_resource, x_return_status='||x_return_status);

574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: RAISE;
576: END;
577: IF G_DEBUG='Y' THEN
578: AHL_DEBUG_PUB.debug('Finish: insert_job_resource, x_return_status='||x_return_status);
579: --dbms_output.put_line('Finish: insert_job_resource, x_return_status='||x_return_status);
580: END IF;
581: END insert_job_resource;
582:

Line 717: AHL_DEBUG_PUB.debug('Finish: insert_job_material, x_return_status='||x_return_status);

713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: RAISE;
715: END;
716: IF G_DEBUG='Y' THEN
717: AHL_DEBUG_PUB.debug('Finish: insert_job_material, x_return_status='||x_return_status);
718: --dbms_output.put_line('Finish: insert_job_material, x_return_status='||x_return_status);
719: END IF;
720: END insert_job_material;
721:

Line 798: AHL_DEBUG_PUB.debug('Inside: submit_wip_load, just before calling submit_request');

794: RETURN;
795: END IF;
796:
797: IF G_DEBUG='Y' THEN
798: AHL_DEBUG_PUB.debug('Inside: submit_wip_load, just before calling submit_request');
799: --dbms_output.put_line('Inside: submit_wip_load, just before calling submit_request');
800: END IF;
801: -- submit request of WIP Mass Load
802: l_req_id := fnd_request.submit_request('WIP','WICMLP', NULL, NULL, FALSE,

Line 806: AHL_DEBUG_PUB.debug('When calling submit_request, the group_id is '||to_char(p_group_id));

802: l_req_id := fnd_request.submit_request('WIP','WICMLP', NULL, NULL, FALSE,
803: TO_CHAR(p_group_id), 0, 1);
804:
805: IF G_DEBUG='Y' THEN
806: AHL_DEBUG_PUB.debug('When calling submit_request, the group_id is '||to_char(p_group_id));
807: --dbms_output.put_line('When calling submit_request, the group_id is '||to_char(p_group_id));
808: END IF;
809: IF (l_req_id = 0 ) THEN
810: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_SUBMIT_FAILURE');

Line 814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');

810: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_SUBMIT_FAILURE');
811: FND_MSG_PUB.ADD;
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);

Line 816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));

812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;

Line 818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);

814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');
815: --dbms_output.put_line('Submit request itself failed and the initialized parameters for the application are: ');
816: AHL_DEBUG_PUB.debug('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
817: --dbms_output.put_line('user_id='||to_char(fnd_global.user_id)||' resp_id='||to_char(fnd_global.resp_id)||' resp_appl_id='||to_char(fnd_global.resp_appl_id));
818: AHL_DEBUG_PUB.debug('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
819: --dbms_output.put_line('user_name='||fnd_global.user_name||' resp_name='||fnd_global.resp_name||' application_name='||fnd_global.application_name);
820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;

Line 824: AHL_DEBUG_PUB.debug('After commit and before waiting for request');

820: END IF;
821: ELSE
822: COMMIT; --This commit is a must;
823: IF G_DEBUG='Y' THEN
824: AHL_DEBUG_PUB.debug('After commit and before waiting for request');
825: --dbms_output.put_line('After commit and before waiting for request');
826: END IF;
827: -- wait for the execution result of WIP Mass Load
828: l_boolvar := fnd_concurrent.wait_for_request(

Line 842: AHL_DEBUG_PUB.debug('Wait for request itself failed');

838: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_WAIT_FAILURE');
839: FND_MSG_PUB.ADD;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: IF G_DEBUG='Y' THEN
842: AHL_DEBUG_PUB.debug('Wait for request itself failed');
843: --dbms_output.put_line('Wait for request itself failed');
844: END IF;
845: ELSIF (l_dev_phase = 'COMPLETE' AND l_dev_status = 'NORMAL') THEN
846: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 852: AHL_DEBUG_PUB.debug('Finish: submit_wip_load, x_return_status='||x_return_status);

848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
850: END IF;
851: IF G_DEBUG='Y' THEN
852: AHL_DEBUG_PUB.debug('Finish: submit_wip_load, x_return_status='||x_return_status);
853: --dbms_output.put_line('Finish: submit_wip_load, x_return_status='||x_return_status);
854: END IF;
855: END submit_wip_load;
856:

Line 910: AHL_DEBUG_PUB.enable_debug;

906: --SAVEPOINT LOAD_WIP_JOB_PVT;
907: --Savepoint here is not necessary, because we have a commit statement in its called
908: --procedure submit_wip_load and it will make this savepoint invalid.
909: IF G_DEBUG='Y' THEN
910: AHL_DEBUG_PUB.enable_debug;
911: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
912: END IF;
913: IF FND_API.to_boolean(p_init_msg_list) THEN
914: FND_MSG_PUB.initialize;

Line 911: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

907: --Savepoint here is not necessary, because we have a commit statement in its called
908: --procedure submit_wip_load and it will make this savepoint invalid.
909: IF G_DEBUG='Y' THEN
910: AHL_DEBUG_PUB.enable_debug;
911: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
912: END IF;
913: IF FND_API.to_boolean(p_init_msg_list) THEN
914: FND_MSG_PUB.initialize;
915: END IF;

Line 926: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_header');

922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924:
925: IF G_DEBUG='Y' THEN
926: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_header');
927: --dbms_output.put_line('Inside: load_wip_job, just before calling insert_job_header');
928: END IF;
929: --insert job header first
930: insert_job_header( p_ahl_wo_rec => p_ahl_wo_rec,

Line 941: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_operation');

937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;
939:
940: IF G_DEBUG='Y' THEN
941: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_operation');
942: --dbms_output.put_line('Inside: load_wip_job, just before calling insert_job_operation');
943: END IF;
944: --insert job operations if they are available
945: IF p_ahl_wo_op_tbl.count > 0 THEN

Line 958: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_resource');

954: END LOOP;
955: END IF;
956:
957: IF G_DEBUG='Y' THEN
958: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_resource');
959: --dbms_output.put_line('Inside: load_wip_job, just before calling insert_job_resource');
960: END IF;
961: --insert resource requirements if they are available
962: IF p_ahl_wo_res_tbl.count > 0 THEN

Line 975: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_material');

971: END LOOP;
972: END IF;
973:
974: IF G_DEBUG='Y' THEN
975: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling insert_job_material');
976: --dbms_output.put_line('Inside: load_wip_job, just before calling insert_job_material');
977: END IF;
978: --insert material requirements if they are available
979: IF p_ahl_wo_mtl_tbl.count > 0 THEN

Line 992: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling submit_wip_load');

988: END LOOP;
989: END IF;
990:
991: IF G_DEBUG='Y' THEN
992: AHL_DEBUG_PUB.debug('Inside: load_wip_job, just before calling submit_wip_load');
993: --dbms_output.put_line('Inside: load_wip_job, just before calling submit_wip_load');
994: END IF;
995: --submit WIP Mass Load
996: submit_wip_load( p_group_id => l_group_id,

Line 1097: AHL_DEBUG_PUB.debug('The concatenated error message is '||x_msg_data);

1093: x_msg_data := l_error_msg;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095:
1096: IF G_DEBUG='Y' THEN
1097: AHL_DEBUG_PUB.debug('The concatenated error message is '||x_msg_data);
1098: --dbms_output.put_line(substr('The concatenated error message is '||x_msg_data, 1, 255));
1099: END IF;
1100: END IF;
1101:

Line 1105: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1101:
1102: COMMIT; --Autonomous Transaction Required
1103:
1104: IF G_DEBUG='Y' THEN
1105: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1106: AHL_DEBUG_PUB.disable_debug;
1107: END IF;
1108: EXCEPTION
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1106: AHL_DEBUG_PUB.disable_debug;

1102: COMMIT; --Autonomous Transaction Required
1103:
1104: IF G_DEBUG='Y' THEN
1105: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1106: AHL_DEBUG_PUB.disable_debug;
1107: END IF;
1108: EXCEPTION
1109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1110: ROLLBACK;

Line 1116: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data);
1115: IF G_DEBUG='Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1117: 'UNEXPECTED ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;

Line 1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1114: p_data => x_msg_data);
1115: IF G_DEBUG='Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1117: 'UNEXPECTED ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK;

Line 1119: AHL_DEBUG_PUB.disable_debug;

1115: IF G_DEBUG='Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1117: 'UNEXPECTED ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK;
1123: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1128: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1124: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data);
1127: IF G_DEBUG='Y' THEN
1128: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1129: 'ERROR IN PRIVATE:' );
1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1131: AHL_DEBUG_PUB.disable_debug;
1132: END IF;

Line 1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1126: p_data => x_msg_data);
1127: IF G_DEBUG='Y' THEN
1128: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1129: 'ERROR IN PRIVATE:' );
1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1131: AHL_DEBUG_PUB.disable_debug;
1132: END IF;
1133: WHEN OTHERS THEN
1134: ROLLBACK;

Line 1131: AHL_DEBUG_PUB.disable_debug;

1127: IF G_DEBUG='Y' THEN
1128: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1129: 'ERROR IN PRIVATE:' );
1130: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1131: AHL_DEBUG_PUB.disable_debug;
1132: END IF;
1133: WHEN OTHERS THEN
1134: ROLLBACK;
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1144: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1140: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data);
1143: IF G_DEBUG='Y' THEN
1144: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1145: 'OTHER ERROR IN PRIVATE:' );
1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;

Line 1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');

1142: p_data => x_msg_data);
1143: IF G_DEBUG='Y' THEN
1144: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1145: 'OTHER ERROR IN PRIVATE:' );
1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149:
1150: END load_wip_job;

Line 1147: AHL_DEBUG_PUB.disable_debug;

1143: IF G_DEBUG='Y' THEN
1144: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1145: 'OTHER ERROR IN PRIVATE:' );
1146: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_JOB');
1147: AHL_DEBUG_PUB.disable_debug;
1148: END IF;
1149:
1150: END load_wip_job;
1151:

Line 1254: AHL_DEBUG_PUB.enable_debug;

1250:
1251: BEGIN
1252: SAVEPOINT INSERT_RESOURCE_TXN_PVT;
1253: IF G_DEBUG='Y' THEN
1254: AHL_DEBUG_PUB.enable_debug;
1255: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1256: END IF;
1257: IF FND_API.to_boolean(p_init_msg_list) THEN
1258: FND_MSG_PUB.initialize;

Line 1255: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1251: BEGIN
1252: SAVEPOINT INSERT_RESOURCE_TXN_PVT;
1253: IF G_DEBUG='Y' THEN
1254: AHL_DEBUG_PUB.enable_debug;
1255: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1256: END IF;
1257: IF FND_API.to_boolean(p_init_msg_list) THEN
1258: FND_MSG_PUB.initialize;
1259: END IF;

Line 1508: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1504: IF FND_API.TO_BOOLEAN(p_commit) THEN
1505: COMMIT;
1506: END IF;
1507: IF G_DEBUG='Y' THEN
1508: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1509: AHL_DEBUG_PUB.disable_debug;
1510: END IF;
1511:
1512: EXCEPTION

Line 1509: AHL_DEBUG_PUB.disable_debug;

1505: COMMIT;
1506: END IF;
1507: IF G_DEBUG='Y' THEN
1508: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1509: AHL_DEBUG_PUB.disable_debug;
1510: END IF;
1511:
1512: EXCEPTION
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1520: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1516: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1517: p_count => x_msg_count,
1518: p_data => x_msg_data);
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1521: 'UNEXPECTED ERROR IN PRIVATE:' );
1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1523: AHL_DEBUG_PUB.disable_debug;
1524: END IF;

Line 1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1518: p_data => x_msg_data);
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1521: 'UNEXPECTED ERROR IN PRIVATE:' );
1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1523: AHL_DEBUG_PUB.disable_debug;
1524: END IF;
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;

Line 1523: AHL_DEBUG_PUB.disable_debug;

1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1521: 'UNEXPECTED ERROR IN PRIVATE:' );
1522: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1523: AHL_DEBUG_PUB.disable_debug;
1524: END IF;
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;
1527: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1532: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1528: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1529: p_count => x_msg_count,
1530: p_data => x_msg_data);
1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1533: 'ERROR IN PRIVATE:' );
1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1535: AHL_DEBUG_PUB.disable_debug;
1536: END IF;

Line 1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1530: p_data => x_msg_data);
1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1533: 'ERROR IN PRIVATE:' );
1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1535: AHL_DEBUG_PUB.disable_debug;
1536: END IF;
1537: WHEN OTHERS THEN
1538: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;

Line 1535: AHL_DEBUG_PUB.disable_debug;

1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1533: 'ERROR IN PRIVATE:' );
1534: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1535: AHL_DEBUG_PUB.disable_debug;
1536: END IF;
1537: WHEN OTHERS THEN
1538: ROLLBACK TO INSERT_RESOURCE_TXN_PVT;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1548: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1544: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1545: p_count => x_msg_count,
1546: p_data => x_msg_data);
1547: IF G_DEBUG='Y' THEN
1548: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1549: 'OTHER ERROR IN PRIVATE:' );
1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1551: AHL_DEBUG_PUB.disable_debug;
1552: END IF;

Line 1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');

1546: p_data => x_msg_data);
1547: IF G_DEBUG='Y' THEN
1548: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1549: 'OTHER ERROR IN PRIVATE:' );
1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1551: AHL_DEBUG_PUB.disable_debug;
1552: END IF;
1553:
1554: END insert_resource_txn;

Line 1551: AHL_DEBUG_PUB.disable_debug;

1547: IF G_DEBUG='Y' THEN
1548: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1549: 'OTHER ERROR IN PRIVATE:' );
1550: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.INSERT_RESOURCE_TXN');
1551: AHL_DEBUG_PUB.disable_debug;
1552: END IF;
1553:
1554: END insert_resource_txn;
1555:

Line 1646: AHL_DEBUG_PUB.enable_debug;

1642: --SAVEPOINT LOAD_WIP_JOB_PVT;
1643: --Savepoint here is not necessary, because we have a commit statement in its called
1644: --procedure submit_wip_load and it will make this savepoint invalid.
1645: IF G_DEBUG='Y' THEN
1646: AHL_DEBUG_PUB.enable_debug;
1647: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1648: END IF;
1649: IF FND_API.to_boolean(p_init_msg_list) THEN
1650: FND_MSG_PUB.initialize;

Line 1647: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1643: --Savepoint here is not necessary, because we have a commit statement in its called
1644: --procedure submit_wip_load and it will make this savepoint invalid.
1645: IF G_DEBUG='Y' THEN
1646: AHL_DEBUG_PUB.enable_debug;
1647: AHL_DEBUG_PUB.debug('Begin private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1648: END IF;
1649: IF FND_API.to_boolean(p_init_msg_list) THEN
1650: FND_MSG_PUB.initialize;
1651: END IF;

Line 1662: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_header');

1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660:
1661: IF G_DEBUG='Y' THEN
1662: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_header');
1663: --dbms_output.put_line('Inside: load_wip_batch_jobs, just before calling insert_job_header');
1664: END IF;
1665: --insert job header first
1666: insert_job_header( p_ahl_wo_rec => p_ahl_wo_rec,

Line 1677: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_operation');

1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: END IF;
1675:
1676: IF G_DEBUG='Y' THEN
1677: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_operation');
1678: --dbms_output.put_line('Inside: load_wip_batch_jobs, just before calling insert_job_operation');
1679: END IF;
1680: --insert job operations if they are available
1681: IF p_ahl_wo_op_tbl.count > 0 THEN

Line 1694: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_resource');

1690: END LOOP;
1691: END IF;
1692:
1693: IF G_DEBUG='Y' THEN
1694: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_resource');
1695: --dbms_output.put_line('Inside: load_wip_batch_jobs, just before calling insert_job_resource');
1696: END IF;
1697: --insert resource requirements if they are available
1698: IF p_ahl_wo_res_tbl.count > 0 THEN

Line 1711: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_material');

1707: END LOOP;
1708: END IF;
1709:
1710: IF G_DEBUG='Y' THEN
1711: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling insert_job_material');
1712: --dbms_output.put_line('Inside: load_wip_batch_jobs, just before calling insert_job_material');
1713: END IF;
1714: --insert material requirements if they are available
1715: IF p_ahl_wo_mtl_tbl.count > 0 THEN

Line 1728: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling submit_wip_load');

1724: END LOOP;
1725: END IF;
1726:
1727: IF G_DEBUG='Y' THEN
1728: AHL_DEBUG_PUB.debug('Inside: load_wip_batch_jobs, just before calling submit_wip_load');
1729: --dbms_output.put_line('Inside: load_wip_batch_jobs, just before calling submit_wip_load');
1730: END IF;
1731: --submit WIP Mass Load
1732:

Line 1857: AHL_DEBUG_PUB.debug('The concatenated error message is '||x_msg_data||' '||i);

1853: x_msg_data := l_error_msg;
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: IF G_DEBUG='Y' THEN
1857: AHL_DEBUG_PUB.debug('The concatenated error message is '||x_msg_data||' '||i);
1858: --dbms_output.put_line(substr('The concatenated error message is '||x_msg_data||' '||i, 1, 255));
1859: END IF;
1860: END IF;
1861: END LOOP;

Line 1867: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1863:
1864: COMMIT; --Autonomous Transaction Required
1865:
1866: IF G_DEBUG='Y' THEN
1867: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1868: AHL_DEBUG_PUB.disable_debug;
1869: END IF;
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1868: AHL_DEBUG_PUB.disable_debug;

1864: COMMIT; --Autonomous Transaction Required
1865:
1866: IF G_DEBUG='Y' THEN
1867: AHL_DEBUG_PUB.debug('End private API: AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1868: AHL_DEBUG_PUB.disable_debug;
1869: END IF;
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1872: ROLLBACK;

Line 1878: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1874: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1875: p_count => x_msg_count,
1876: p_data => x_msg_data);
1877: IF G_DEBUG='Y' THEN
1878: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1879: 'UNEXPECTED ERROR IN PRIVATE:' );
1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1881: AHL_DEBUG_PUB.disable_debug;
1882: END IF;

Line 1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1876: p_data => x_msg_data);
1877: IF G_DEBUG='Y' THEN
1878: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1879: 'UNEXPECTED ERROR IN PRIVATE:' );
1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1881: AHL_DEBUG_PUB.disable_debug;
1882: END IF;
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: ROLLBACK;

Line 1881: AHL_DEBUG_PUB.disable_debug;

1877: IF G_DEBUG='Y' THEN
1878: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1879: 'UNEXPECTED ERROR IN PRIVATE:' );
1880: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1881: AHL_DEBUG_PUB.disable_debug;
1882: END IF;
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: ROLLBACK;
1885: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1890: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1886: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889: IF G_DEBUG='Y' THEN
1890: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1891: 'ERROR IN PRIVATE:' );
1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1893: AHL_DEBUG_PUB.disable_debug;
1894: END IF;

Line 1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1888: p_data => x_msg_data);
1889: IF G_DEBUG='Y' THEN
1890: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1891: 'ERROR IN PRIVATE:' );
1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1893: AHL_DEBUG_PUB.disable_debug;
1894: END IF;
1895: WHEN OTHERS THEN
1896: ROLLBACK;

Line 1893: AHL_DEBUG_PUB.disable_debug;

1889: IF G_DEBUG='Y' THEN
1890: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1891: 'ERROR IN PRIVATE:' );
1892: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1893: AHL_DEBUG_PUB.disable_debug;
1894: END IF;
1895: WHEN OTHERS THEN
1896: ROLLBACK;
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1906: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1902: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1903: p_count => x_msg_count,
1904: p_data => x_msg_data);
1905: IF G_DEBUG='Y' THEN
1906: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1907: 'OTHER ERROR IN PRIVATE:' );
1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1909: AHL_DEBUG_PUB.disable_debug;
1910: END IF;

Line 1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');

1904: p_data => x_msg_data);
1905: IF G_DEBUG='Y' THEN
1906: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1907: 'OTHER ERROR IN PRIVATE:' );
1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1909: AHL_DEBUG_PUB.disable_debug;
1910: END IF;
1911:
1912: END load_wip_batch_jobs;

Line 1909: AHL_DEBUG_PUB.disable_debug;

1905: IF G_DEBUG='Y' THEN
1906: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1907: 'OTHER ERROR IN PRIVATE:' );
1908: AHL_DEBUG_PUB.debug('AHL_WIP_JOB_PVT.LOAD_WIP_BATCH_JOBS');
1909: AHL_DEBUG_PUB.disable_debug;
1910: END IF;
1911:
1912: END load_wip_batch_jobs;
1913: