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

Line 773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

769: BEGIN
770:
771: -- Initialize local variables.
772: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
774:
775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
777: '-------------Entered check_task_n_wipjob----------------');

Line 775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN

771: -- Initialize local variables.
772: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
774:
775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
777: '-------------Entered check_task_n_wipjob----------------');
778: END IF;
779:

Line 776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',

772: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
773: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
774:
775: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
776: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.begin',
777: '-------------Entered check_task_n_wipjob----------------');
778: END IF;
779:
780:

Line 797: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN

793: success if not.
794: ****/
795: IF( p_repair_status = C_CLOSED_STATUS) THEN
796:
797: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN
798: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
799: '-------------status is being changed to close,ro['||p_repair_line_id||']-----');
800: END IF;
801:

Line 798: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

794: ****/
795: IF( p_repair_status = C_CLOSED_STATUS) THEN
796:
797: IF (Fnd_Log.LEVEL_EVENT >= l_debug_level) THEN
798: Fnd_Log.STRING (Fnd_Log.LEVEL_EVENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
799: '-------------status is being changed to close,ro['||p_repair_line_id||']-----');
800: END IF;
801:
802: IF (l_repair_mode = C_WIP_MODE) THEN

Line 804: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

800: END IF;
801:
802: IF (l_repair_mode = C_WIP_MODE) THEN
803:
804: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
805: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
806: '-------------checking for open jobs---------------');
807: END IF;
808:

Line 805: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

801:
802: IF (l_repair_mode = C_WIP_MODE) THEN
803:
804: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
805: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
806: '-------------checking for open jobs---------------');
807: END IF;
808:
809: OPEN wipjob_cur;

Line 813: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

809: OPEN wipjob_cur;
810: FETCH wipjob_cur INTO l_tmp_char;
811: IF(wipjob_cur%NOTFOUND) THEN
812: CLOSE wipjob_cur;
813: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
814: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
815: '-------------there are open jobs---------------');
816: END IF;
817: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');

Line 814: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

810: FETCH wipjob_cur INTO l_tmp_char;
811: IF(wipjob_cur%NOTFOUND) THEN
812: CLOSE wipjob_cur;
813: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
814: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
815: '-------------there are open jobs---------------');
816: END IF;
817: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
818: Fnd_Msg_Pub.ADD;

Line 824: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

820: END IF;
821: CLOSE wipjob_cur;
822: ELSIF (l_repair_mode = C_TASK_MODE) THEN
823:
824: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
825: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
826: '-------------checking for open tasks---------------');
827: END IF;
828:

Line 825: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

821: CLOSE wipjob_cur;
822: ELSIF (l_repair_mode = C_TASK_MODE) THEN
823:
824: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
825: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
826: '-------------checking for open tasks---------------');
827: END IF;
828:
829: OPEN task_cur;

Line 833: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN

829: OPEN task_cur;
830: FETCH task_cur INTO l_tmp_char;
831: IF(task_cur%NOTFOUND) THEN
832: CLOSE task_cur;
833: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
834: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
835: '-------------there are open tasks---------------');
836: END IF;
837: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');

Line 834: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

830: FETCH task_cur INTO l_tmp_char;
831: IF(task_cur%NOTFOUND) THEN
832: CLOSE task_cur;
833: IF (Fnd_Log.LEVEL_STATEMENT >= l_debug_level) THEN
834: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
835: '-------------there are open tasks---------------');
836: END IF;
837: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
838: Fnd_Msg_Pub.ADD;

Line 845: IF (Fnd_Log.level_procedure >= l_debug_level) THEN

841: CLOSE task_cur;
842: END IF;
843: END IF;
844:
845: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
846: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',
847: '-------------Leaving check_task_n_wipjob----------------');
848: END IF;
849:

Line 846: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',

842: END IF;
843: END IF;
844:
845: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
846: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.check_task_n_wipjob.end',
847: '-------------Leaving check_task_n_wipjob----------------');
848: END IF;
849:
850: EXCEPTION

Line 854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

850: EXCEPTION
851: WHEN Fnd_Api.G_EXC_ERROR THEN
852: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
853: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
857: 'EXC_ERROR ['||x_msg_data||']');
858: END IF;

Line 855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,

851: WHEN Fnd_Api.G_EXC_ERROR THEN
852: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
853: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
854: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
855: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
856: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
857: 'EXC_ERROR ['||x_msg_data||']');
858: END IF;
859:

Line 863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

859:
860: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
862: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
865: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
866: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
867: END IF;

Line 864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

860: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
862: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
863: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
864: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
865: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
866: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
867: END IF;
868:

Line 877: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

873: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
874: END IF;
875: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
876:
877: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
878: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
879: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
880: 'SQL Message ['||SQLERRM||']');
881: END IF;

Line 878: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,

874: END IF;
875: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
876:
877: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
878: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
879: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
880: 'SQL Message ['||SQLERRM||']');
881: END IF;
882:

Line 929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

925:
926:
927: -- Initialize local variables.
928: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
930:
931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
933: '-------------Entered Convert_Status_val_to_Id----------------');

Line 931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN

927: -- Initialize local variables.
928: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
930:
931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
933: '-------------Entered Convert_Status_val_to_Id----------------');
934: END IF;
935:

Line 932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',

928: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
929: l_debug_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
930:
931: IF (Fnd_Log.LEVEL_PROCEDURE >= l_debug_level) THEN
932: Fnd_Log.STRING (Fnd_Log.LEVEL_PROCEDURE, 'csd.plsql.csd_repairs_util.Convert_Status_val_to_Id.begin',
933: '-------------Entered Convert_Status_val_to_Id----------------');
934: END IF;
935:
936:

Line 1005: IF (Fnd_Log.level_procedure >= l_debug_level) THEN

1001: END IF;
1002:
1003:
1004:
1005: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
1006: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',
1007: '-------------Leaving Convert_Status_Val_to_Id----------------');
1008: END IF;
1009:

Line 1006: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',

1002:
1003:
1004:
1005: IF (Fnd_Log.level_procedure >= l_debug_level) THEN
1006: Fnd_Log.STRING (Fnd_Log.level_procedure, 'csd.plsql.csd_repairs_util.Convert_Status_Val_to_Id.end',
1007: '-------------Leaving Convert_Status_Val_to_Id----------------');
1008: END IF;
1009:
1010: END Convert_status_Val_to_Id;

Line 1324: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1320: BEGIN
1321:
1322: savepoint CHANGE_ITEM_IB_OWNER;
1323:
1324: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1325: fnd_log.STRING (fnd_log.level_procedure,
1326: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',
1327: 'Enter - Change Item IB Owner');
1328: end if;

Line 1325: fnd_log.STRING (fnd_log.level_procedure,

1321:
1322: savepoint CHANGE_ITEM_IB_OWNER;
1323:
1324: if (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1325: fnd_log.STRING (fnd_log.level_procedure,
1326: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.BEGIN',
1327: 'Enter - Change Item IB Owner');
1328: end if;
1329:

Line 1483: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1479: End If;
1480:
1481: COMMIT WORK;
1482:
1483: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1484: fnd_log.STRING (fnd_log.level_procedure,
1485: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',
1486: 'Exit - Change Item IB Owner');
1487: End if;

Line 1484: fnd_log.STRING (fnd_log.level_procedure,

1480:
1481: COMMIT WORK;
1482:
1483: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1484: fnd_log.STRING (fnd_log.level_procedure,
1485: 'CSD.PLSQL.CSD_REPAIRS_UTIL.CHANGE_ITEM_IB_OWNER.END',
1486: 'Exit - Change Item IB Owner');
1487: End if;
1488:

Line 1743: -- will be logged in the fnd_log_messages if logging is enabled

1739: -- p_reason_code: The reason code for the status change defaulted to null
1740: -- p_comments: The comments for the flow status, defaulted to null
1741: -- p_validation_level: validation level for the routine. Pass fnd_api.g_valid_level_full to get the messages from the API
1742: -- pass fnd_api.g_valid_level_none will ignore all error messages and return success always. The error messages
1743: -- will be logged in the fnd_log_messages if logging is enabled
1744: --*****************************************************
1745:
1746: procedure auto_update_ro_status(
1747: p_api_version in number,

Line 1764: lc_log_level number := fnd_log.g_current_runtime_level;

1760: l_to_flow_status_id number;
1761: x_object_version_number number;
1762: l_repair_type_id number;
1763: l_object_version_number number;
1764: lc_log_level number := fnd_log.g_current_runtime_level;
1765: lc_procedure_level number := fnd_log.level_procedure;
1766: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
1767: lc_api_version_number number := 1.0;
1768: lc_api_name varchar2(60) := 'auto_update_ro_status';

Line 1765: lc_procedure_level number := fnd_log.level_procedure;

1761: x_object_version_number number;
1762: l_repair_type_id number;
1763: l_object_version_number number;
1764: lc_log_level number := fnd_log.g_current_runtime_level;
1765: lc_procedure_level number := fnd_log.level_procedure;
1766: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.auto_update_ro_status';
1767: lc_api_version_number number := 1.0;
1768: lc_api_name varchar2(60) := 'auto_update_ro_status';
1769: l_un_rcvd_lines_exists varchar2(3);

Line 1790: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');

1786: fnd_msg_pub.initialize;
1787: END IF;
1788:
1789: if lc_log_level >= lc_procedure_level then
1790: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');
1791: end if;
1792:
1793: -- set the return status
1794: x_return_status := fnd_api.g_ret_sts_success;

Line 1804: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair

1800: --
1801: if nvl(fnd_profile.value('CSD_ENABLE_AUTO_UPD_RO_STAT'),'N') = 'N'
1802: then
1803: if lc_log_level >= lc_procedure_level then
1804: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Enable Auto Update of Repair
1805: Order Status upon Receiving is not set to yes.');
1806: end if;
1807: if p_validation_level = fnd_api.g_valid_level_full then
1808: -- to do: If the caller API needs this API to raise the errors, set a message into message stack and raise an error to exception block.

Line 1837: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After

1833:
1834: l_to_flow_status_id := fnd_profile.value('CSD_DEF_RO_STAT_FR_RCV');
1835: if l_to_flow_status_id is null then
1836: if lc_log_level >= lc_procedure_level then
1837: fnd_log.string(lc_log_level,lc_mod_name,'Profile CSD: Default Repair Order Status After
1838: Receving is not set');
1839: end if;
1840: if p_validation_level = fnd_api.g_valid_level_full then
1841: -- to do: set a message and raise an error for the caller API.

Line 1868: fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');

1864:
1865: if l_to_flow_status_id = l_from_flow_status_id then
1866: -- to and from are same. Do not update.
1867: if lc_log_level >= lc_procedure_level then
1868: fnd_log.string(lc_log_level,lc_mod_name,'the new status is same as the old status. Do not update the status');
1869: end if;
1870: if p_validation_level = fnd_api.g_valid_level_full then
1871: -- to do: set a message and raise an error.
1872: null;

Line 1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');

1875: end if;
1876: end if;
1877: -- call the update flow status API to update the RO status.
1878: if lc_log_level >= lc_procedure_level then
1879: fnd_log.string(lc_log_level,lc_mod_name,'calling csd_repairs_pvt.update_flow_status API');
1880: end if;
1881:
1882: csd_repairs_pvt.update_flow_status(p_api_version => 1,
1883: p_commit => fnd_api.g_false,

Line 1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status

1896: p_object_version_number => l_object_version_number,
1897: x_object_version_number => x_object_version_number );
1898: if x_return_status <> fnd_api.g_ret_sts_success then
1899: if lc_log_level >= lc_procedure_level then
1900: fnd_log.string(lc_log_level,lc_mod_name,'Error in csd_repairs_pvt.update_flow_status
1901: ['||x_msg_data||']');
1902: end if;
1903:
1904: if p_validation_level = fnd_api.g_valid_level_full then

Line 1996: lc_log_level number := fnd_log.g_current_runtime_level;

1992: l_repair_org NUMBER; -- repair org id
1993: l_repair_type_id NUMBER; -- repair type id
1994: l_repair_mode VARCHAR2(30) := ''; -- repair mode display name
1995: l_auto_process_rma VARCHAR2(30) := '';
1996: lc_log_level number := fnd_log.g_current_runtime_level;
1997: lc_procedure_level number := fnd_log.level_procedure;
1998: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';
1999: lc_api_version_number number := 1.0;
2000: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';

Line 1997: lc_procedure_level number := fnd_log.level_procedure;

1993: l_repair_type_id NUMBER; -- repair type id
1994: l_repair_mode VARCHAR2(30) := ''; -- repair mode display name
1995: l_auto_process_rma VARCHAR2(30) := '';
1996: lc_log_level number := fnd_log.g_current_runtime_level;
1997: lc_procedure_level number := fnd_log.level_procedure;
1998: lc_mod_name varchar2(100) := 'csd.plsql.csd_repairs_util.default_ro_attrs_from_rule';
1999: lc_api_version_number number := 1.0;
2000: lc_api_name varchar2(60) := 'default_ro_attrs_from_rule';
2001:

Line 2019: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');

2015: fnd_msg_pub.initialize;
2016: end if;
2017:
2018: if lc_log_level >= lc_procedure_level then
2019: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');
2020: end if;
2021:
2022: -- set the return status
2023: x_return_status := fnd_api.g_ret_sts_success;

Line 2309: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2305:
2306: begin
2307: savepoint create_requisition;
2308: -- standard check.
2309: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2310: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Begin Create_requisition');
2311: END IF;
2312:
2313: if not fnd_api.compatible_api_call(

Line 2310: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Begin Create_requisition');

2306: begin
2307: savepoint create_requisition;
2308: -- standard check.
2309: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2310: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Begin Create_requisition');
2311: END IF;
2312:
2313: if not fnd_api.compatible_api_call(
2314: lc_api_version,

Line 2334: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2330: into l_person_id
2331: from fnd_user
2332: where user_id = fnd_global.user_id;
2333:
2334: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2335: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2336: lc_mod_name,
2337: 'Fetched the person_id '||l_person_id||' for user_id '||fnd_global.user_id);
2338: END IF;

Line 2335: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2331: from fnd_user
2332: where user_id = fnd_global.user_id;
2333:
2334: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2335: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2336: lc_mod_name,
2337: 'Fetched the person_id '||l_person_id||' for user_id '||fnd_global.user_id);
2338: END IF;
2339:

Line 2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2358: l_material_account := JTF_NUMBER_TABLE();
2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2363: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the user hook procedure csd_logistics_cuhk.source_parts');
2364: END IF;
2365:
2366: csd_logistics_cuhk.source_parts

Line 2363: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the user hook procedure csd_logistics_cuhk.source_parts');

2359: l_material_variance_account:= JTF_NUMBER_TABLE();
2360: l_location_id := JTF_NUMBER_TABLE();
2361:
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2363: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the user hook procedure csd_logistics_cuhk.source_parts');
2364: END IF;
2365:
2366: csd_logistics_cuhk.source_parts
2367: (p_repair_line_id => p_repair_line_id,

Line 2390: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2386: );
2387:
2388: IF x_return_status <> fnd_api.g_ret_sts_success
2389: THEN
2390: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2391: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The custom procedure raised an error status, exiting the API.');
2392: END IF;
2393: RAISE fnd_api.g_exc_error;
2394: END IF;

Line 2391: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The custom procedure raised an error status, exiting the API.');

2387:
2388: IF x_return_status <> fnd_api.g_ret_sts_success
2389: THEN
2390: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2391: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The custom procedure raised an error status, exiting the API.');
2392: END IF;
2393: RAISE fnd_api.g_exc_error;
2394: END IF;
2395:

Line 2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2397: -- variables.
2398: IF NOT NVL(x_use_custom_sourcing,FALSE)
2399: THEN
2400:
2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2402: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Copying the input parameters into the local variables');
2403: END IF;
2404:
2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();

Line 2402: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Copying the input parameters into the local variables');

2398: IF NOT NVL(x_use_custom_sourcing,FALSE)
2399: THEN
2400:
2401: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2402: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Copying the input parameters into the local variables');
2403: END IF;
2404:
2405: l_wip_entity_id_tbl := JTF_NUMBER_TABLE();
2406: l_item_id_tbl := JTF_NUMBER_TABLE();

Line 2440: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2436: END LOOP;
2437:
2438: END IF;
2439: -- populate the material variance and project details.
2440: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2441: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2442: lc_mod_name,
2443: 'Fetching material variance and project details along with deliver to location');
2444: END IF;

Line 2441: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2437:
2438: END IF;
2439: -- populate the material variance and project details.
2440: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2441: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2442: lc_mod_name,
2443: 'Fetching material variance and project details along with deliver to location');
2444: END IF;
2445: for i in 1 ..l_wip_entity_id_tbl.count

Line 2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2465: and wdj.organization_id = p_organization_id;
2466: end if;
2467:
2468: -- get the deliver_to location
2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2470: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Getting the deliver to location.');
2471: END IF;
2472:
2473: if ( nvl(l_previous_wip_entity,-1) = l_wip_entity_id_tbl(i) and

Line 2470: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Getting the deliver to location.');

2466: end if;
2467:
2468: -- get the deliver_to location
2469: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2470: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Getting the deliver to location.');
2471: END IF;
2472:
2473: if ( nvl(l_previous_wip_entity,-1) = l_wip_entity_id_tbl(i) and
2474: nvl(l_previous_op_seq_num,-1) = l_op_seq_num_tbl(i) ) then

Line 2491: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2487: l_previous_op_seq_num := l_op_seq_num_tbl(i);
2488: end loop;
2489:
2490: -- get the currency code and the ou_id.
2491: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2492: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2493: lc_mod_name,'Fetching currency code and OU');
2494: END IF;
2495:

Line 2492: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2488: end loop;
2489:
2490: -- get the currency code and the ou_id.
2491: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2492: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2493: lc_mod_name,'Fetching currency code and OU');
2494: END IF;
2495:
2496: select gb.currency_code, to_number(ho.ORG_INFORMATION3)

Line 2504: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2500: and ho.organization_id = p_organization_id
2501: and ho.ORG_INFORMATION_CONTEXT = 'Accounting Information';
2502:
2503: -- bulk bind the variables for the insert.
2504: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2505: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2506: lc_mod_name,
2507: 'Just before calling the FORALL insert to po_requisitions_interface_all');
2508: END IF;

Line 2505: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2501: and ho.ORG_INFORMATION_CONTEXT = 'Accounting Information';
2502:
2503: -- bulk bind the variables for the insert.
2504: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2505: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2506: lc_mod_name,
2507: 'Just before calling the FORALL insert to po_requisitions_interface_all');
2508: END IF;
2509:

Line 2598: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2594: -- call out the CP to create the requisition and if required the sales orders.
2595: x_request_id := fnd_request.submit_request(
2596: application => 'CSD', program => 'CSDCRREQ', argument1 => l_ou_id, argument2 => l_ou_id, argument3 => p_repair_line_id);
2597:
2598: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2599: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The concurrent request id is :'||x_request_id);
2600: END IF;
2601:
2602: IF x_request_id <= 0

Line 2599: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The concurrent request id is :'||x_request_id);

2595: x_request_id := fnd_request.submit_request(
2596: application => 'CSD', program => 'CSDCRREQ', argument1 => l_ou_id, argument2 => l_ou_id, argument3 => p_repair_line_id);
2597:
2598: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2599: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The concurrent request id is :'||x_request_id);
2600: END IF;
2601:
2602: IF x_request_id <= 0
2603: THEN

Line 2613: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2609: FOR k IN 1 ..p_wip_entity_id_tbl.COUNT
2610: LOOP
2611: IF NVL(l_previous_wip_entity,-1) <> p_wip_entity_id_tbl(k)
2612: THEN
2613: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2614: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the csd_hdv_wip_job_pvt.update_mat_issue_quantities for wip_entity_id '||p_wip_entity_id_tbl(k));
2615: END IF;
2616:
2617: CSD_HV_WIP_JOB_PVT.update_mat_issue_quantities

Line 2614: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the csd_hdv_wip_job_pvt.update_mat_issue_quantities for wip_entity_id '||p_wip_entity_id_tbl(k));

2610: LOOP
2611: IF NVL(l_previous_wip_entity,-1) <> p_wip_entity_id_tbl(k)
2612: THEN
2613: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2614: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling the csd_hdv_wip_job_pvt.update_mat_issue_quantities for wip_entity_id '||p_wip_entity_id_tbl(k));
2615: END IF;
2616:
2617: CSD_HV_WIP_JOB_PVT.update_mat_issue_quantities
2618: (p_api_version_number => 1.0,

Line 2629: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2625: p_wip_entity_id => p_wip_entity_id_tbl(k)
2626: );
2627: IF x_return_status <> fnd_api.g_ret_sts_success
2628: THEN
2629: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Error in update_mat_issue_quantities API for wip_entity_id '||p_wip_entity_id_tbl(k));
2631: END IF;
2632: RAISE fnd_api.g_exc_error;
2633: END IF;

Line 2630: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Error in update_mat_issue_quantities API for wip_entity_id '||p_wip_entity_id_tbl(k));

2626: );
2627: IF x_return_status <> fnd_api.g_ret_sts_success
2628: THEN
2629: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Error in update_mat_issue_quantities API for wip_entity_id '||p_wip_entity_id_tbl(k));
2631: END IF;
2632: RAISE fnd_api.g_exc_error;
2633: END IF;
2634: l_previous_wip_entity := p_wip_entity_id_tbl(k);

Line 2649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2645: LOOP
2646: IF l_item_id_tbl(k) <> p_item_id_tbl(k)
2647: THEN
2648: -- update the existing line to have material requirement as 0 and create/update the new line for l_item_id_tbl(k)
2649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Item Id '||p_item_id_tbl(k)||' is being replaced by item id '||l_item_id_tbl(k));
2651: END IF;
2652:
2653: l_mtl_txn_dtls_upd(k).inventory_item_id := p_item_id_tbl(k);

Line 2650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Item Id '||p_item_id_tbl(k)||' is being replaced by item id '||l_item_id_tbl(k));

2646: IF l_item_id_tbl(k) <> p_item_id_tbl(k)
2647: THEN
2648: -- update the existing line to have material requirement as 0 and create/update the new line for l_item_id_tbl(k)
2649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Item Id '||p_item_id_tbl(k)||' is being replaced by item id '||l_item_id_tbl(k));
2651: END IF;
2652:
2653: l_mtl_txn_dtls_upd(k).inventory_item_id := p_item_id_tbl(k);
2654: l_mtl_txn_dtls_upd(k).required_quantity := 0;

Line 2696: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2692: END LOOP;
2693:
2694: IF l_mtl_txn_dtls_tab.COUNT > 0
2695: THEN
2696: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2697: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to update the required quantity to 0 since its substituted.');
2698: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_upd.COUNT);
2699: END IF;
2700: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls

Line 2697: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to update the required quantity to 0 since its substituted.');

2693:
2694: IF l_mtl_txn_dtls_tab.COUNT > 0
2695: THEN
2696: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2697: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to update the required quantity to 0 since its substituted.');
2698: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_upd.COUNT);
2699: END IF;
2700: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2701: (p_api_version_number => 1,

Line 2698: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_upd.COUNT);

2694: IF l_mtl_txn_dtls_tab.COUNT > 0
2695: THEN
2696: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2697: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to update the required quantity to 0 since its substituted.');
2698: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_upd.COUNT);
2699: END IF;
2700: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2701: (p_api_version_number => 1,
2702: p_init_msg_list => fnd_api.g_false,

Line 2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2713: THEN
2714: RAISE fnd_api.g_exc_error;
2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to create new material requirements.');
2719: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_tab.COUNT);
2720: END IF;
2721:

Line 2718: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to create new material requirements.');

2714: RAISE fnd_api.g_exc_error;
2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to create new material requirements.');
2719: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_tab.COUNT);
2720: END IF;
2721:
2722: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls

Line 2719: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_tab.COUNT);

2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Calling process_save_mtl_txn_dtls to create new material requirements.');
2719: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'The number of records is '||l_mtl_txn_dtls_tab.COUNT);
2720: END IF;
2721:
2722: csd_hv_wip_job_pvt.process_save_mtl_txn_dtls
2723: (p_api_version_number => 1,

Line 2739: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737: END IF;
2738:
2739: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2740: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Bulk updating all the substitute material requirement lines.');
2741: END IF;
2742: FOR k IN 1 ..l_mtl_txn_dtls_tab.COUNT
2743: LOOP

Line 2740: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Bulk updating all the substitute material requirement lines.');

2736: END IF;
2737: END IF;
2738:
2739: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2740: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,lc_mod_name,'Bulk updating all the substitute material requirement lines.');
2741: END IF;
2742: FOR k IN 1 ..l_mtl_txn_dtls_tab.COUNT
2743: LOOP
2744: UPDATE csd_wip_transaction_details cwt SET substitutes = l_mtl_txn_dtls_upd(k).inventory_item_id

Line 2761: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2757: commit work;
2758: end if;
2759: exception
2760: when fnd_api.g_exc_error then
2761: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2762: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2763: lc_mod_name,
2764: 'Execution error in the API');
2765: END IF;

Line 2762: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2758: end if;
2759: exception
2760: when fnd_api.g_exc_error then
2761: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2762: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2763: lc_mod_name,
2764: 'Execution error in the API');
2765: END IF;
2766: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );

Line 2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2766: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
2767: x_return_Status := fnd_api.g_ret_sts_error;
2768: rollback to create_requisition;
2769: when fnd_api.g_exc_unexpected_error then
2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2772: lc_mod_name,
2773: 'Unexpected error');
2774: END IF;

Line 2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2767: x_return_Status := fnd_api.g_ret_sts_error;
2768: rollback to create_requisition;
2769: when fnd_api.g_exc_unexpected_error then
2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2771: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2772: lc_mod_name,
2773: 'Unexpected error');
2774: END IF;
2775: x_return_status := fnd_api.g_ret_sts_error;

Line 3152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3148: p_old_Lot_Serial_val_tbl OE_ORDER_PUB.Lot_Serial_Val_Tbl_Type := OE_ORDER_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
3149: p_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
3150:
3151: BEGIN
3152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_repair_warranty');
3155: -- log the input parameters.
3156: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');

Line 3154: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_repair_warranty');

3150:
3151: BEGIN
3152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_repair_warranty');
3155: -- log the input parameters.
3156: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3157: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_order_line_id => '||p_order_line_id);
3158: END IF;

Line 3156: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');

3152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_repair_warranty');
3155: -- log the input parameters.
3156: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3157: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_order_line_id => '||p_order_line_id);
3158: END IF;
3159:
3160: -- standard check.

Line 3157: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_order_line_id => '||p_order_line_id);

3153: THEN
3154: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_repair_warranty');
3155: -- log the input parameters.
3156: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3157: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_order_line_id => '||p_order_line_id);
3158: END IF;
3159:
3160: -- standard check.
3161: IF NOT fnd_api.compatible_api_call(

Line 3177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3173: -- initialize return status.
3174: x_return_status := fnd_api.g_ret_sts_success;
3175:
3176: -- validate the order line id.
3177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3178: THEN
3179: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Validating the order line id.');
3180: END IF;
3181:

Line 3179: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Validating the order line id.');

3175:
3176: -- validate the order line id.
3177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3178: THEN
3179: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Validating the order line id.');
3180: END IF;
3181:
3182: SELECT cpt.repair_line_id,oeh.header_id,ced.inventory_item_id,cr.incident_id
3183: INTO l_repair_line_id,l_header_id,l_ship_inv_item_id,l_incident_id

Line 3231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3227: l_serial_number := NULL;
3228: END;
3229: IF l_serial_number IS NULL
3230: THEN
3231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3232: THEN
3233: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Serial number is null. Warranty cannot be created. Returning');
3234: END IF;
3235: RETURN;

Line 3233: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Serial number is null. Warranty cannot be created. Returning');

3229: IF l_serial_number IS NULL
3230: THEN
3231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3232: THEN
3233: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Serial number is null. Warranty cannot be created. Returning');
3234: END IF;
3235: RETURN;
3236: END IF;
3237: -- check if there exists a service item for this.

Line 3239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3235: RETURN;
3236: END IF;
3237: -- check if there exists a service item for this.
3238: -- make a call to user hook procedure so that customers can provide their own logic to derive the service item.
3239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3240: THEN
3241: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling the user hook procedure csd_logistics_cuhk.service_item');
3242: END IF;
3243: csd_logistics_cuhk.service_item

Line 3241: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling the user hook procedure csd_logistics_cuhk.service_item');

3237: -- check if there exists a service item for this.
3238: -- make a call to user hook procedure so that customers can provide their own logic to derive the service item.
3239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3240: THEN
3241: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling the user hook procedure csd_logistics_cuhk.service_item');
3242: END IF;
3243: csd_logistics_cuhk.service_item
3244: (p_order_line_id => p_order_line_id,
3245: p_repair_line_id => l_repair_line_id,

Line 3252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3248: x_msg_count => x_msg_count,
3249: x_service_item_id => l_service_item_id
3250: );
3251:
3252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3253: THEN
3254: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Returned from csd_logistics_cuhk.service_item. The service item returned is '||NVL(l_service_item_id,-999));
3255: END IF;
3256:

Line 3254: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Returned from csd_logistics_cuhk.service_item. The service item returned is '||NVL(l_service_item_id,-999));

3250: );
3251:
3252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3253: THEN
3254: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Returned from csd_logistics_cuhk.service_item. The service item returned is '||NVL(l_service_item_id,-999));
3255: END IF;
3256:
3257: IF x_return_status <> fnd_api.g_ret_sts_success
3258: THEN

Line 3259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3255: END IF;
3256:
3257: IF x_return_status <> fnd_api.g_ret_sts_success
3258: THEN
3259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3260: THEN
3261: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The user hook procedure returns a non success code. Raising the exception.');
3262: END IF;
3263: raise fnd_api.g_exc_error;

Line 3261: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The user hook procedure returns a non success code. Raising the exception.');

3257: IF x_return_status <> fnd_api.g_ret_sts_success
3258: THEN
3259: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3260: THEN
3261: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The user hook procedure returns a non success code. Raising the exception.');
3262: END IF;
3263: raise fnd_api.g_exc_error;
3264: END IF;
3265:

Line 3285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3281: x_msg_data => x_msg_data
3282: );
3283: IF x_return_status <> fnd_api.g_ret_sts_success
3284: THEN
3285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3286: THEN
3287: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occured in calling rules engine.');
3288: END IF;
3289: RAISE fnd_api.g_exc_error;

Line 3287: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occured in calling rules engine.');

3283: IF x_return_status <> fnd_api.g_ret_sts_success
3284: THEN
3285: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3286: THEN
3287: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occured in calling rules engine.');
3288: END IF;
3289: RAISE fnd_api.g_exc_error;
3290: END IF;
3291: END IF;

Line 3296: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3292:
3293: -- need to walk through all the materials transacted and check if there exists
3294: -- atleast one service. The moment we find a service, we exit.
3295:
3296: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3297: THEN
3298: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine is:'||l_service_item_id);
3299: END IF;
3300:

Line 3298: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine is:'||l_service_item_id);

3294: -- atleast one service. The moment we find a service, we exit.
3295:
3296: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3297: THEN
3298: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine is:'||l_service_item_id);
3299: END IF;
3300:
3301: IF l_service_item_id IS NULL
3302: THEN

Line 3306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3302: THEN
3303: FOR i IN c_all_mtl_transactions(l_repair_line_id)
3304: LOOP
3305:
3306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3307: THEN
3308: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling rule engine with disp code = '||i.reason_id||' item id = '||i.inventory_item_id||' Org id = '||i.organization_id);
3309: END IF;
3310: l_rule_input_rec.wip_mtl_disp_code_id := i.reason_id;

Line 3308: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling rule engine with disp code = '||i.reason_id||' item id = '||i.inventory_item_id||' Org id = '||i.organization_id);

3304: LOOP
3305:
3306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3307: THEN
3308: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling rule engine with disp code = '||i.reason_id||' item id = '||i.inventory_item_id||' Org id = '||i.organization_id);
3309: END IF;
3310: l_rule_input_rec.wip_mtl_disp_code_id := i.reason_id;
3311: l_rule_input_rec.wip_mtl_txn_item_id := i.inventory_item_id;
3312: l_rule_input_rec.wip_entity_item_id := i.primary_item_id;

Line 3339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3335: EXIT WHEN l_service_item_id IS NOT NULL;
3336: END LOOP;
3337: END IF;
3338:
3339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3340: THEN
3341: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine(for disp code) is:'||l_service_item_id);
3342: END IF;
3343:

Line 3341: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine(for disp code) is:'||l_service_item_id);

3337: END IF;
3338:
3339: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3340: THEN
3341: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item from call to rule engine(for disp code) is:'||l_service_item_id);
3342: END IF;
3343:
3344: IF l_service_item_id IS NULL
3345: THEN

Line 3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3342: END IF;
3343:
3344: IF l_service_item_id IS NULL
3345: THEN
3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3347: THEN
3348: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item is null. Returning..');
3349: END IF;
3350: RETURN;

Line 3348: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item is null. Returning..');

3344: IF l_service_item_id IS NULL
3345: THEN
3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3347: THEN
3348: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Service item is null. Returning..');
3349: END IF;
3350: RETURN;
3351: END IF;
3352:

Line 3365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3361: WHEN NO_DATA_FOUND THEN
3362: fnd_message.set_name('CSD','CSD_IB_INSTANCE_MISSING');
3363: fnd_message.set_token('SERIAL_NUM',l_serial_number);
3364: END;
3365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3366: THEN
3367: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The instance id is :'||l_instance_id);
3368: END IF;
3369:

Line 3367: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The instance id is :'||l_instance_id);

3363: fnd_message.set_token('SERIAL_NUM',l_serial_number);
3364: END;
3365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3366: THEN
3367: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The instance id is :'||l_instance_id);
3368: END IF;
3369:
3370: -- get the service item defaults.
3371: SELECT service_duration_period_code, service_duration, service_starting_delay

Line 3418: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3414: END IF;
3415:
3416: -- calculate the service end date.
3417: -- call OKS public API to get the end date.
3418: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3419: THEN
3420: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oks_omint_pub.get_duration to get the duration.');
3421: END IF;
3422: oks_omint_pub.get_duration

Line 3420: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oks_omint_pub.get_duration to get the duration.');

3416: -- calculate the service end date.
3417: -- call OKS public API to get the end date.
3418: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3419: THEN
3420: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oks_omint_pub.get_duration to get the duration.');
3421: END IF;
3422: oks_omint_pub.get_duration
3423: (p_api_version => 11.5,
3424: p_init_msg_list => fnd_api.g_false,

Line 3441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3437: );
3438:
3439: IF x_return_status <> fnd_api.g_ret_sts_success
3440: THEN
3441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3442: THEN
3443: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error in oks_omint_pub.get_duration. Error msg is: '||x_msg_data);
3444: END IF;
3445: RAISE fnd_api.g_exc_error;

Line 3443: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error in oks_omint_pub.get_duration. Error msg is: '||x_msg_data);

3439: IF x_return_status <> fnd_api.g_ret_sts_success
3440: THEN
3441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3442: THEN
3443: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error in oks_omint_pub.get_duration. Error msg is: '||x_msg_data);
3444: END IF;
3445: RAISE fnd_api.g_exc_error;
3446:
3447: END IF;

Line 3461: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3457: -- call the OE API.
3458: mo_global.init('ONT');
3459: mo_global.set_policy_context('S',l_org_id);
3460:
3461: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3462: THEN
3463: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oe_order_pub.process_order');
3464: END IF;
3465: oe_order_pub.process_order

Line 3463: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oe_order_pub.process_order');

3459: mo_global.set_policy_context('S',l_org_id);
3460:
3461: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3462: THEN
3463: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling oe_order_pub.process_order');
3464: END IF;
3465: oe_order_pub.process_order
3466: (p_api_version_number => 1.0
3467: , p_init_msg_list => fnd_api.g_false

Line 3509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3505: then
3506: for i in 1 ..x_msg_count
3507: loop
3508: fnd_msg_pub.get(1,'F',x_msg_data,x_msg_index_out);
3509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3510: THEN
3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'msg is :'||x_msg_data);
3512: END IF;
3513: end loop;

Line 3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'msg is :'||x_msg_data);

3507: loop
3508: fnd_msg_pub.get(1,'F',x_msg_data,x_msg_index_out);
3509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3510: THEN
3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'msg is :'||x_msg_data);
3512: END IF;
3513: end loop;
3514: else
3515: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 3522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3518: end if;
3519: RAISE fnd_api.g_exc_error;
3520: END IF;
3521:
3522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3523: THEN
3524: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Running workflow back ground process to process the deferred activities.');
3525: END IF;
3526:

Line 3524: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Running workflow back ground process to process the deferred activities.');

3520: END IF;
3521:
3522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3523: THEN
3524: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Running workflow back ground process to process the deferred activities.');
3525: END IF;
3526:
3527: wf_engine.background
3528: (itemtype => 'OEOL'

Line 3531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3527: wf_engine.background
3528: (itemtype => 'OEOL'
3529: );
3530:
3531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3532: THEN
3533: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'newly created line id is :'||x_line_tbl(1).line_id);
3534: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Starting the loop!');
3535: END IF;

Line 3533: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'newly created line id is :'||x_line_tbl(1).line_id);

3529: );
3530:
3531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3532: THEN
3533: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'newly created line id is :'||x_line_tbl(1).line_id);
3534: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Starting the loop!');
3535: END IF;
3536: -- successfully added the service item to order. Call OKS CP to create the warranty contract.
3537: -- before calling the API, we need to poll for the order line to appear in the oks_reprocessing table.

Line 3534: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Starting the loop!');

3530:
3531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3532: THEN
3533: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'newly created line id is :'||x_line_tbl(1).line_id);
3534: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Starting the loop!');
3535: END IF;
3536: -- successfully added the service item to order. Call OKS CP to create the warranty contract.
3537: -- before calling the API, we need to poll for the order line to appear in the oks_reprocessing table.
3538: -- This is needed since OM line fulfilment is a deferred workflow activity.

Line 3559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3555: x_request_id := fnd_request.submit_request('OKS','OKSREPROC',NULL,NULL,FALSE,'SEL',NULL);
3556:
3557: IF x_request_id <= 0
3558: THEN
3559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3560: THEN
3561: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while submitting the concurrent request. Program name is:OKSREPROC');
3562: END IF;
3563: RAISE fnd_api.g_exc_error;

Line 3561: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while submitting the concurrent request. Program name is:OKSREPROC');

3557: IF x_request_id <= 0
3558: THEN
3559: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3560: THEN
3561: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while submitting the concurrent request. Program name is:OKSREPROC');
3562: END IF;
3563: RAISE fnd_api.g_exc_error;
3564: END IF;
3565:

Line 3581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3577: );
3578:
3579: IF NOT l_req_completed
3580: THEN
3581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3582: THEN
3583: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while waiting for the request to complete. The error message is :'||x_message);
3584: END IF;
3585: RAISE fnd_api.g_exc_error;

Line 3583: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while waiting for the request to complete. The error message is :'||x_message);

3579: IF NOT l_req_completed
3580: THEN
3581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3582: THEN
3583: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Error occurred while waiting for the request to complete. The error message is :'||x_message);
3584: END IF;
3585: RAISE fnd_api.g_exc_error;
3586: END IF;
3587: -- add a new repair activity to mark the creation of repair warranty.

Line 3633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3629: l_activity_rec.paramc6 := l_service_duration||' '||l_duration_desc;
3630: l_activity_rec.object_version_number := null;
3631:
3632: -- 3. log the activity.
3633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3634: THEN
3635: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csd_update_programs_pvt.log_activity');
3636: END IF;
3637: csd_update_programs_pvt.log_activity

Line 3635: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csd_update_programs_pvt.log_activity');

3631:
3632: -- 3. log the activity.
3633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3634: THEN
3635: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csd_update_programs_pvt.log_activity');
3636: END IF;
3637: csd_update_programs_pvt.log_activity
3638: (p_api_version => 1.0,
3639: p_commit => p_commit,

Line 3649: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

3645: p_activity_rec => l_activity_rec
3646: );
3647: IF x_return_status <> fnd_api.g_ret_sts_success
3648: THEN
3649: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3650: THEN
3651: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'csd_update_programs_pvt.log_activity. Error msg is: '||x_msg_data);
3652: END IF;
3653: RAISE fnd_api.g_exc_error;

Line 3651: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'csd_update_programs_pvt.log_activity. Error msg is: '||x_msg_data);

3647: IF x_return_status <> fnd_api.g_ret_sts_success
3648: THEN
3649: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3650: THEN
3651: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'csd_update_programs_pvt.log_activity. Error msg is: '||x_msg_data);
3652: END IF;
3653: RAISE fnd_api.g_exc_error;
3654: END IF;
3655:

Line 3705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3701: l_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
3702:
3703: BEGIN
3704:
3705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3706: THEN
3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');
3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');

Line 3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');

3703: BEGIN
3704:
3705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3706: THEN
3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');
3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);

Line 3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');

3705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3706: THEN
3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');
3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);
3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);
3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);

Line 3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);

3706: THEN
3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');
3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);
3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);
3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);
3714: END IF;

Line 3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);

3707: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Begin create_inst_party_relation');
3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);
3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);
3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);
3714: END IF;
3715:

Line 3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);

3708: -- log the input parameters.
3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);
3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);
3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);
3714: END IF;
3715:
3716:

Line 3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);

3709: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The passed parameters are :');
3710: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_party_id => '||p_sr_party_id);
3711: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_sr_account_id => '||p_sr_account_id);
3712: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_instance_id => '||p_instance_id);
3713: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'p_relationship_type => '||p_relationship_type);
3714: END IF;
3715:
3716:
3717: -- standard check.

Line 3737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3733: -- initialize the relation created flag.
3734: x_relationship_created := fnd_api.g_true;
3735:
3736: -- check if there exists a valid relationship for the customer/account and relationship type.
3737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3738: THEN
3739: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Checking if there exists a valid relationship for passed in relationship type');
3740:
3741: END IF;

Line 3739: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Checking if there exists a valid relationship for passed in relationship type');

3735:
3736: -- check if there exists a valid relationship for the customer/account and relationship type.
3737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3738: THEN
3739: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Checking if there exists a valid relationship for passed in relationship type');
3740:
3741: END IF;
3742:
3743: BEGIN

Line 3761: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3757: l_exists := 'N';
3758: END;
3759:
3760: -- initialize the csi_data_structures.
3761: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3762: THEN
3763: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Populating the required CSI data structures.');
3764: END IF;
3765:

Line 3763: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Populating the required CSI data structures.');

3759:
3760: -- initialize the csi_data_structures.
3761: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3762: THEN
3763: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Populating the required CSI data structures.');
3764: END IF;
3765:
3766: l_party_tbl(1).instance_id := p_instance_id;
3767: l_party_tbl(1).party_id := p_sr_party_id;

Line 3797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3793: l_txn_rec.object_version_number := NULL;
3794: l_txn_rec.split_reason_code := '';
3795:
3796: -- call the CSI API.
3797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3798: THEN
3799: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csi_party_relationships_pub.create_inst_party_relationship');
3800: END IF;
3801:

Line 3799: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csi_party_relationships_pub.create_inst_party_relationship');

3795:
3796: -- call the CSI API.
3797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3798: THEN
3799: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Calling csi_party_relationships_pub.create_inst_party_relationship');
3800: END IF;
3801:
3802: SAVEPOINT create_inst_party_relation;
3803:

Line 3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3815: );
3816:
3817: IF x_return_status <> fnd_api.g_ret_sts_success
3818: THEN
3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3820: THEN
3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');
3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);
3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);

Line 3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');

3817: IF x_return_status <> fnd_api.g_ret_sts_success
3818: THEN
3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3820: THEN
3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');
3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);
3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);
3824: END IF;
3825:

Line 3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);

3818: THEN
3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3820: THEN
3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');
3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);
3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);
3824: END IF;
3825:
3826: RAISE fnd_api.g_exc_error;

Line 3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);

3819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3820: THEN
3821: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The csi_party_relationships_pub.create_inst_party_relationship API returned a non success return status.');
3822: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error count:'||x_msg_count);
3823: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The error msg:'||x_msg_data);
3824: END IF;
3825:
3826: RAISE fnd_api.g_exc_error;
3827: END IF;

Line 3829: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3825:
3826: RAISE fnd_api.g_exc_error;
3827: END IF;
3828:
3829: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3830: THEN
3831: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Successfully created the instance party relationship. Exiting '||lc_mod_name);
3832: END IF;
3833:

Line 3831: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Successfully created the instance party relationship. Exiting '||lc_mod_name);

3827: END IF;
3828:
3829: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3830: THEN
3831: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'Successfully created the instance party relationship. Exiting '||lc_mod_name);
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN fnd_api.g_exc_error THEN

Line 3842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3838:
3839: WHEN fnd_api.g_exc_unexpected_error THEN
3840: x_relationship_created := fnd_api.g_false;
3841:
3842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3843: THEN
3844: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The api version check failed!');
3845: END IF;
3846:

Line 3844: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The api version check failed!');

3840: x_relationship_created := fnd_api.g_false;
3841:
3842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3843: THEN
3844: fnd_log.string(fnd_log.level_statement, lc_mod_name, 'The api version check failed!');
3845: END IF;
3846:
3847: END create_inst_party_relation;
3848: