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.JMF_SUBCONTRCT_DIAG_UTIL dependencies on JTF_DIAGNOSTIC_COREAPI

Line 37: JTF_DIAGNOSTIC_COREAPI.SectionPrint('1. CHECKING PROFILES');

33: FUNCTION Check_Profiles RETURN VARCHAR2 IS
34: l_statusStr VARCHAR2(10);
35: BEGIN
36: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
37: JTF_DIAGNOSTIC_COREAPI.SectionPrint('1. CHECKING PROFILES');
38: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('JMF_SHK_CHARGE_BASED_ENABLED', NULL, NULL, NULL, null) = NULL THEN
39: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
40: END IF;
41: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('XLA_MO_SECURITY_PROFILE_LEVEL', NULL, NULL, NULL, null) = NULL THEN

Line 38: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('JMF_SHK_CHARGE_BASED_ENABLED', NULL, NULL, NULL, null) = NULL THEN

34: l_statusStr VARCHAR2(10);
35: BEGIN
36: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
37: JTF_DIAGNOSTIC_COREAPI.SectionPrint('1. CHECKING PROFILES');
38: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('JMF_SHK_CHARGE_BASED_ENABLED', NULL, NULL, NULL, null) = NULL THEN
39: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
40: END IF;
41: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('XLA_MO_SECURITY_PROFILE_LEVEL', NULL, NULL, NULL, null) = NULL THEN
42: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 41: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('XLA_MO_SECURITY_PROFILE_LEVEL', NULL, NULL, NULL, null) = NULL THEN

37: JTF_DIAGNOSTIC_COREAPI.SectionPrint('1. CHECKING PROFILES');
38: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('JMF_SHK_CHARGE_BASED_ENABLED', NULL, NULL, NULL, null) = NULL THEN
39: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
40: END IF;
41: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('XLA_MO_SECURITY_PROFILE_LEVEL', NULL, NULL, NULL, null) = NULL THEN
42: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
43: END IF ;
44: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('DEFAULT_ORG_ID', NULL, NULL, NULL, null) = NULL THEN
45: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 44: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('DEFAULT_ORG_ID', NULL, NULL, NULL, null) = NULL THEN

40: END IF;
41: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('XLA_MO_SECURITY_PROFILE_LEVEL', NULL, NULL, NULL, null) = NULL THEN
42: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
43: END IF ;
44: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('DEFAULT_ORG_ID', NULL, NULL, NULL, null) = NULL THEN
45: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
46: END IF;
47: JTF_DIAGNOSTIC_COREAPI.BRPrint;
48: RETURN l_statusStr;

Line 47: JTF_DIAGNOSTIC_COREAPI.BRPrint;

43: END IF ;
44: IF JTF_DIAGNOSTIC_COREAPI.CheckProfile('DEFAULT_ORG_ID', NULL, NULL, NULL, null) = NULL THEN
45: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
46: END IF;
47: JTF_DIAGNOSTIC_COREAPI.BRPrint;
48: RETURN l_statusStr;
49: END Check_Profiles;
50:
51: --========================================================================

Line 65: JTF_DIAGNOSTIC_COREAPI.SectionPrint('2. CHECKING WIP PARAMETERS');

61: l_sqltxt VARCHAR2(2000);
62: l_statusStr VARCHAR2(10);
63: BEGIN
64: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
65: JTF_DIAGNOSTIC_COREAPI.SectionPrint('2. CHECKING WIP PARAMETERS');
66: JTF_DIAGNOSTIC_COREAPI.line_out('WIP Parameters have not been defined for the following MP Organizations:');
67: JTF_DIAGNOSTIC_COREAPI.BRPrint;
68: l_sqltxt := ' SELECT
69: organization_id "MP Organization Id",

Line 66: JTF_DIAGNOSTIC_COREAPI.line_out('WIP Parameters have not been defined for the following MP Organizations:');

62: l_statusStr VARCHAR2(10);
63: BEGIN
64: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
65: JTF_DIAGNOSTIC_COREAPI.SectionPrint('2. CHECKING WIP PARAMETERS');
66: JTF_DIAGNOSTIC_COREAPI.line_out('WIP Parameters have not been defined for the following MP Organizations:');
67: JTF_DIAGNOSTIC_COREAPI.BRPrint;
68: l_sqltxt := ' SELECT
69: organization_id "MP Organization Id",
70: organization_code "MP Organization Code"

Line 67: JTF_DIAGNOSTIC_COREAPI.BRPrint;

63: BEGIN
64: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
65: JTF_DIAGNOSTIC_COREAPI.SectionPrint('2. CHECKING WIP PARAMETERS');
66: JTF_DIAGNOSTIC_COREAPI.line_out('WIP Parameters have not been defined for the following MP Organizations:');
67: JTF_DIAGNOSTIC_COREAPI.BRPrint;
68: l_sqltxt := ' SELECT
69: organization_id "MP Organization Id",
70: organization_code "MP Organization Code"
71: FROM MTL_PARAMETERS mp

Line 77: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

73: AND NOT EXISTS
74: (SELECT 1 FROM WIP_PARAMETERS wp
75: WHERE mp.organization_id = wp.organization_id)';
76:
77: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: IF l_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter WIP Parameters for these MP Organizations');
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 78: JTF_DIAGNOSTIC_COREAPI.BRPrint;

74: (SELECT 1 FROM WIP_PARAMETERS wp
75: WHERE mp.organization_id = wp.organization_id)';
76:
77: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: IF l_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter WIP Parameters for these MP Organizations');
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 80: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter WIP Parameters for these MP Organizations');

76:
77: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: IF l_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter WIP Parameters for these MP Organizations');
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
83: END IF;
84: RETURN l_statusStr;

Line 81: JTF_DIAGNOSTIC_COREAPI.BRPrint;

77: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: IF l_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter WIP Parameters for these MP Organizations');
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
83: END IF;
84: RETURN l_statusStr;
85:

Line 102: JTF_DIAGNOSTIC_COREAPI.SectionPrint('3. CHECKING ACCOUNTING PERIODS');

98: l_sqltxt VARCHAR2(2000);
99: l_statusStr VARCHAR2(10);
100: BEGIN
101: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
102: JTF_DIAGNOSTIC_COREAPI.SectionPrint('3. CHECKING ACCOUNTING PERIODS');
103: JTF_DIAGNOSTIC_COREAPI.line_out('Inventory accounting periods are not open in the following MP organizations:');
104: JTF_DIAGNOSTIC_COREAPI.BRPrint;
105: l_sqltxt := ' SELECT
106: organization_id "MP Organization Id",

Line 103: JTF_DIAGNOSTIC_COREAPI.line_out('Inventory accounting periods are not open in the following MP organizations:');

99: l_statusStr VARCHAR2(10);
100: BEGIN
101: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
102: JTF_DIAGNOSTIC_COREAPI.SectionPrint('3. CHECKING ACCOUNTING PERIODS');
103: JTF_DIAGNOSTIC_COREAPI.line_out('Inventory accounting periods are not open in the following MP organizations:');
104: JTF_DIAGNOSTIC_COREAPI.BRPrint;
105: l_sqltxt := ' SELECT
106: organization_id "MP Organization Id",
107: organization_code "MP Organization Code"

Line 104: JTF_DIAGNOSTIC_COREAPI.BRPrint;

100: BEGIN
101: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
102: JTF_DIAGNOSTIC_COREAPI.SectionPrint('3. CHECKING ACCOUNTING PERIODS');
103: JTF_DIAGNOSTIC_COREAPI.line_out('Inventory accounting periods are not open in the following MP organizations:');
104: JTF_DIAGNOSTIC_COREAPI.BRPrint;
105: l_sqltxt := ' SELECT
106: organization_id "MP Organization Id",
107: organization_code "MP Organization Code"
108: FROM mtl_parameters mp

Line 118: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

114: AND (Trunc(period_start_date) < Trunc(SYSDATE)
115: AND Trunc(schedule_close_date) > Trunc(SYSDATE))
116: AND open_flag = ''Y'' )';
117:
118: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
119: JTF_DIAGNOSTIC_COREAPI.BRPrint;
120: IF l_count >0 THEN
121: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open accounting periods in these MP organizations');
122: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 119: JTF_DIAGNOSTIC_COREAPI.BRPrint;

115: AND Trunc(schedule_close_date) > Trunc(SYSDATE))
116: AND open_flag = ''Y'' )';
117:
118: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
119: JTF_DIAGNOSTIC_COREAPI.BRPrint;
120: IF l_count >0 THEN
121: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open accounting periods in these MP organizations');
122: JTF_DIAGNOSTIC_COREAPI.BRPrint;
123: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 121: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open accounting periods in these MP organizations');

117:
118: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
119: JTF_DIAGNOSTIC_COREAPI.BRPrint;
120: IF l_count >0 THEN
121: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open accounting periods in these MP organizations');
122: JTF_DIAGNOSTIC_COREAPI.BRPrint;
123: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
124: END IF;
125: RETURN l_statusStr;

Line 122: JTF_DIAGNOSTIC_COREAPI.BRPrint;

118: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
119: JTF_DIAGNOSTIC_COREAPI.BRPrint;
120: IF l_count >0 THEN
121: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open accounting periods in these MP organizations');
122: JTF_DIAGNOSTIC_COREAPI.BRPrint;
123: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
124: END IF;
125: RETURN l_statusStr;
126:

Line 147: JTF_DIAGNOSTIC_COREAPI.SectionPrint('4. CHECKING ROUTINGS');

143: l_sqltxt VARCHAR2(2000);
144: l_statusStr VARCHAR2(10);
145: BEGIN
146: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
147: JTF_DIAGNOSTIC_COREAPI.SectionPrint('4. CHECKING ROUTINGS');
148: JTF_DIAGNOSTIC_COREAPI.line_out('Routings are defined for the following Outsourced Assembly items in MP organizations:');
149: JTF_DIAGNOSTIC_COREAPI.BRPrint;
150: l_sqltxt := ' SELECT
151: msi.segment1 "Outsourced Assembly",

Line 148: JTF_DIAGNOSTIC_COREAPI.line_out('Routings are defined for the following Outsourced Assembly items in MP organizations:');

144: l_statusStr VARCHAR2(10);
145: BEGIN
146: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
147: JTF_DIAGNOSTIC_COREAPI.SectionPrint('4. CHECKING ROUTINGS');
148: JTF_DIAGNOSTIC_COREAPI.line_out('Routings are defined for the following Outsourced Assembly items in MP organizations:');
149: JTF_DIAGNOSTIC_COREAPI.BRPrint;
150: l_sqltxt := ' SELECT
151: msi.segment1 "Outsourced Assembly",
152: mp.organization_code "Organization Code"

Line 149: JTF_DIAGNOSTIC_COREAPI.BRPrint;

145: BEGIN
146: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
147: JTF_DIAGNOSTIC_COREAPI.SectionPrint('4. CHECKING ROUTINGS');
148: JTF_DIAGNOSTIC_COREAPI.line_out('Routings are defined for the following Outsourced Assembly items in MP organizations:');
149: JTF_DIAGNOSTIC_COREAPI.BRPrint;
150: l_sqltxt := ' SELECT
151: msi.segment1 "Outsourced Assembly",
152: mp.organization_code "Organization Code"
153: FROM

Line 166: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

162: WHERE bor.organization_id = msi.organization_id
163: AND bor.assembly_item_id = msi.inventory_item_id)';
164:
165:
166: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
167: JTF_DIAGNOSTIC_COREAPI.BRPrint;
168: IF l_count >0 THEN
169: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please remove any defined routings for these Outsourced assemblies in MP Organizations');
170: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 167: JTF_DIAGNOSTIC_COREAPI.BRPrint;

163: AND bor.assembly_item_id = msi.inventory_item_id)';
164:
165:
166: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
167: JTF_DIAGNOSTIC_COREAPI.BRPrint;
168: IF l_count >0 THEN
169: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please remove any defined routings for these Outsourced assemblies in MP Organizations');
170: JTF_DIAGNOSTIC_COREAPI.BRPrint;
171: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 169: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please remove any defined routings for these Outsourced assemblies in MP Organizations');

165:
166: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
167: JTF_DIAGNOSTIC_COREAPI.BRPrint;
168: IF l_count >0 THEN
169: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please remove any defined routings for these Outsourced assemblies in MP Organizations');
170: JTF_DIAGNOSTIC_COREAPI.BRPrint;
171: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
172: END IF;
173: RETURN l_statusStr;

Line 170: JTF_DIAGNOSTIC_COREAPI.BRPrint;

166: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
167: JTF_DIAGNOSTIC_COREAPI.BRPrint;
168: IF l_count >0 THEN
169: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please remove any defined routings for these Outsourced assemblies in MP Organizations');
170: JTF_DIAGNOSTIC_COREAPI.BRPrint;
171: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
172: END IF;
173: RETURN l_statusStr;
174:

Line 190: JTF_DIAGNOSTIC_COREAPI.SectionPrint('5. CHECKING SHIPPING NETWORKS');

186: l_sqltxt VARCHAR2(2000);
187: l_statusStr VARCHAR2(10);
188: BEGIN
189: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
190: JTF_DIAGNOSTIC_COREAPI.SectionPrint('5. CHECKING SHIPPING NETWORKS');
191: JTF_DIAGNOSTIC_COREAPI.line_out('Shipping network is not defined between the following OEM and MP organizations:');
192: JTF_DIAGNOSTIC_COREAPI.BRPrint;
193: l_sqltxt := ' SELECT DISTINCT
194: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",

Line 191: JTF_DIAGNOSTIC_COREAPI.line_out('Shipping network is not defined between the following OEM and MP organizations:');

187: l_statusStr VARCHAR2(10);
188: BEGIN
189: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
190: JTF_DIAGNOSTIC_COREAPI.SectionPrint('5. CHECKING SHIPPING NETWORKS');
191: JTF_DIAGNOSTIC_COREAPI.line_out('Shipping network is not defined between the following OEM and MP organizations:');
192: JTF_DIAGNOSTIC_COREAPI.BRPrint;
193: l_sqltxt := ' SELECT DISTINCT
194: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",
195: (SELECT organization_code FROM mtl_parameters WHERE organization_id = tp_organization_id) "MP Organization Code"

Line 192: JTF_DIAGNOSTIC_COREAPI.BRPrint;

188: BEGIN
189: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
190: JTF_DIAGNOSTIC_COREAPI.SectionPrint('5. CHECKING SHIPPING NETWORKS');
191: JTF_DIAGNOSTIC_COREAPI.line_out('Shipping network is not defined between the following OEM and MP organizations:');
192: JTF_DIAGNOSTIC_COREAPI.BRPrint;
193: l_sqltxt := ' SELECT DISTINCT
194: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",
195: (SELECT organization_code FROM mtl_parameters WHERE organization_id = tp_organization_id) "MP Organization Code"
196: FROM jmf_subcontract_orders jso

Line 204: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

200: AND mip.to_organization_id = jso.tp_organization_id
201: AND SUBCONTRACTING_TYPE IS NOT NULL)';
202:
203:
204: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
205: JTF_DIAGNOSTIC_COREAPI.BRPrint;
206: IF l_count >0 THEN
207: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define shipping networks between the following OEM and MP organizations');
208: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 205: JTF_DIAGNOSTIC_COREAPI.BRPrint;

201: AND SUBCONTRACTING_TYPE IS NOT NULL)';
202:
203:
204: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
205: JTF_DIAGNOSTIC_COREAPI.BRPrint;
206: IF l_count >0 THEN
207: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define shipping networks between the following OEM and MP organizations');
208: JTF_DIAGNOSTIC_COREAPI.BRPrint;
209: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 207: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define shipping networks between the following OEM and MP organizations');

203:
204: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
205: JTF_DIAGNOSTIC_COREAPI.BRPrint;
206: IF l_count >0 THEN
207: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define shipping networks between the following OEM and MP organizations');
208: JTF_DIAGNOSTIC_COREAPI.BRPrint;
209: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
210: END IF;
211: RETURN l_statusStr;

Line 208: JTF_DIAGNOSTIC_COREAPI.BRPrint;

204: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
205: JTF_DIAGNOSTIC_COREAPI.BRPrint;
206: IF l_count >0 THEN
207: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define shipping networks between the following OEM and MP organizations');
208: JTF_DIAGNOSTIC_COREAPI.BRPrint;
209: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
210: END IF;
211: RETURN l_statusStr;
212:

Line 228: JTF_DIAGNOSTIC_COREAPI.SectionPrint('6. CHECKING SHIPPING METHODS');

224: l_sqltxt VARCHAR2(2000);
225: l_statusStr VARCHAR2(10);
226: BEGIN
227: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
228: JTF_DIAGNOSTIC_COREAPI.SectionPrint('6. CHECKING SHIPPING METHODS');
229: JTF_DIAGNOSTIC_COREAPI.line_out('Default shipping method is not defined between the following OEM and MP organizations:');
230: JTF_DIAGNOSTIC_COREAPI.BRPrint;
231: l_sqltxt := ' SELECT DISTINCT
232: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",

Line 229: JTF_DIAGNOSTIC_COREAPI.line_out('Default shipping method is not defined between the following OEM and MP organizations:');

225: l_statusStr VARCHAR2(10);
226: BEGIN
227: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
228: JTF_DIAGNOSTIC_COREAPI.SectionPrint('6. CHECKING SHIPPING METHODS');
229: JTF_DIAGNOSTIC_COREAPI.line_out('Default shipping method is not defined between the following OEM and MP organizations:');
230: JTF_DIAGNOSTIC_COREAPI.BRPrint;
231: l_sqltxt := ' SELECT DISTINCT
232: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",
233: (SELECT organization_code FROM mtl_parameters WHERE organization_id = tp_organization_id) "TP Organization Code"

Line 230: JTF_DIAGNOSTIC_COREAPI.BRPrint;

226: BEGIN
227: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
228: JTF_DIAGNOSTIC_COREAPI.SectionPrint('6. CHECKING SHIPPING METHODS');
229: JTF_DIAGNOSTIC_COREAPI.line_out('Default shipping method is not defined between the following OEM and MP organizations:');
230: JTF_DIAGNOSTIC_COREAPI.BRPrint;
231: l_sqltxt := ' SELECT DISTINCT
232: (SELECT organization_code FROM mtl_parameters WHERE organization_id = oem_organization_id) "OEM Organization Code",
233: (SELECT organization_code FROM mtl_parameters WHERE organization_id = tp_organization_id) "TP Organization Code"
234: FROM jmf_subcontract_orders jso

Line 251: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

247: WHERE mism.from_organization_id = jso.tp_organization_id
248: AND mism.to_organization_id = jso.oem_organization_id
249: AND mism.default_flag = 1)';
250:
251: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
252: JTF_DIAGNOSTIC_COREAPI.BRPrint;
253: IF l_count >0 THEN
254: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define default shipping methods between the following OEM and MP organizations');
255: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 252: JTF_DIAGNOSTIC_COREAPI.BRPrint;

248: AND mism.to_organization_id = jso.oem_organization_id
249: AND mism.default_flag = 1)';
250:
251: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
252: JTF_DIAGNOSTIC_COREAPI.BRPrint;
253: IF l_count >0 THEN
254: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define default shipping methods between the following OEM and MP organizations');
255: JTF_DIAGNOSTIC_COREAPI.BRPrint;
256: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 254: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define default shipping methods between the following OEM and MP organizations');

250:
251: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
252: JTF_DIAGNOSTIC_COREAPI.BRPrint;
253: IF l_count >0 THEN
254: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define default shipping methods between the following OEM and MP organizations');
255: JTF_DIAGNOSTIC_COREAPI.BRPrint;
256: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
257: END IF;
258: RETURN l_statusStr;

Line 255: JTF_DIAGNOSTIC_COREAPI.BRPrint;

251: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
252: JTF_DIAGNOSTIC_COREAPI.BRPrint;
253: IF l_count >0 THEN
254: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define default shipping methods between the following OEM and MP organizations');
255: JTF_DIAGNOSTIC_COREAPI.BRPrint;
256: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
257: END IF;
258: RETURN l_statusStr;
259:

Line 276: JTF_DIAGNOSTIC_COREAPI.SectionPrint('7. CHECKING CUSTOMER SUPPLIER ASSOCIATION');

272: l_sqltxt VARCHAR2(2000);
273: l_statusStr VARCHAR2(10);
274: BEGIN
275: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
276: JTF_DIAGNOSTIC_COREAPI.SectionPrint('7. CHECKING CUSTOMER SUPPLIER ASSOCIATION');
277:
278: -- For OEM organizations
279: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following OEM organizations:');
280: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 279: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following OEM organizations:');

275: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
276: JTF_DIAGNOSTIC_COREAPI.SectionPrint('7. CHECKING CUSTOMER SUPPLIER ASSOCIATION');
277:
278: -- For OEM organizations
279: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following OEM organizations:');
280: JTF_DIAGNOSTIC_COREAPI.BRPrint;
281: l_sqltxt := ' SELECT
282: ORGANIZATION_CODE "OEM Organization" FROM mtl_parameters mp
283: WHERE Nvl(trading_partner_org_flag, ''N'') = ''N''

Line 280: JTF_DIAGNOSTIC_COREAPI.BRPrint;

276: JTF_DIAGNOSTIC_COREAPI.SectionPrint('7. CHECKING CUSTOMER SUPPLIER ASSOCIATION');
277:
278: -- For OEM organizations
279: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following OEM organizations:');
280: JTF_DIAGNOSTIC_COREAPI.BRPrint;
281: l_sqltxt := ' SELECT
282: ORGANIZATION_CODE "OEM Organization" FROM mtl_parameters mp
283: WHERE Nvl(trading_partner_org_flag, ''N'') = ''N''
284: AND EXISTS(

Line 296: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

292: ( SELECT 1 FROM mtl_system_items_b msi
293: WHERE msi.organization_id = mp.organization_id
294: AND msi.outsourced_assembly = 1)';
295:
296: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
297: JTF_DIAGNOSTIC_COREAPI.BRPrint;
298: IF l_count >0 THEN
299: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these OEM organizations');
300: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 297: JTF_DIAGNOSTIC_COREAPI.BRPrint;

293: WHERE msi.organization_id = mp.organization_id
294: AND msi.outsourced_assembly = 1)';
295:
296: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
297: JTF_DIAGNOSTIC_COREAPI.BRPrint;
298: IF l_count >0 THEN
299: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these OEM organizations');
300: JTF_DIAGNOSTIC_COREAPI.BRPrint;
301: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 299: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these OEM organizations');

295:
296: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
297: JTF_DIAGNOSTIC_COREAPI.BRPrint;
298: IF l_count >0 THEN
299: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these OEM organizations');
300: JTF_DIAGNOSTIC_COREAPI.BRPrint;
301: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
302: END IF;
303:

Line 300: JTF_DIAGNOSTIC_COREAPI.BRPrint;

296: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
297: JTF_DIAGNOSTIC_COREAPI.BRPrint;
298: IF l_count >0 THEN
299: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these OEM organizations');
300: JTF_DIAGNOSTIC_COREAPI.BRPrint;
301: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
302: END IF;
303:
304: l_count :=0;

Line 306: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following MP organizations:');

302: END IF;
303:
304: l_count :=0;
305: -- For MP organizations
306: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following MP organizations:');
307: JTF_DIAGNOSTIC_COREAPI.BRPrint;
308: l_sqltxt := ' SELECT
309: ORGANIZATION_CODE "MP Organization" FROM mtl_parameters mp
310: WHERE Nvl(trading_partner_org_flag, ''N'') = ''Y''

Line 307: JTF_DIAGNOSTIC_COREAPI.BRPrint;

303:
304: l_count :=0;
305: -- For MP organizations
306: JTF_DIAGNOSTIC_COREAPI.line_out('Customer/Supplier Associations have not been defined in the following MP organizations:');
307: JTF_DIAGNOSTIC_COREAPI.BRPrint;
308: l_sqltxt := ' SELECT
309: ORGANIZATION_CODE "MP Organization" FROM mtl_parameters mp
310: WHERE Nvl(trading_partner_org_flag, ''N'') = ''Y''
311: AND EXISTS(

Line 321: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

317: OR org_information2 IS NULL
318: OR org_information4 IS NULL
319: OR org_information4 IS NULL) ) ';
320:
321: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
322: JTF_DIAGNOSTIC_COREAPI.BRPrint;
323: IF l_count >0 THEN
324: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these MP organizations');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 322: JTF_DIAGNOSTIC_COREAPI.BRPrint;

318: OR org_information4 IS NULL
319: OR org_information4 IS NULL) ) ';
320:
321: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
322: JTF_DIAGNOSTIC_COREAPI.BRPrint;
323: IF l_count >0 THEN
324: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these MP organizations');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 324: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these MP organizations');

320:
321: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
322: JTF_DIAGNOSTIC_COREAPI.BRPrint;
323: IF l_count >0 THEN
324: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these MP organizations');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
327: END IF;
328: RETURN l_statusStr;

Line 325: JTF_DIAGNOSTIC_COREAPI.BRPrint;

321: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
322: JTF_DIAGNOSTIC_COREAPI.BRPrint;
323: IF l_count >0 THEN
324: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define Customer/Supplier Associations in these MP organizations');
325: JTF_DIAGNOSTIC_COREAPI.BRPrint;
326: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
327: END IF;
328: RETURN l_statusStr;
329:

Line 347: JTF_DIAGNOSTIC_COREAPI.SectionPrint('8. CHECKING PRICE LISTS');

343: l_sqltxt VARCHAR2(2000);
344: l_statusStr VARCHAR2(10);
345: BEGIN
346: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
347: JTF_DIAGNOSTIC_COREAPI.SectionPrint('8. CHECKING PRICE LISTS');
348: JTF_DIAGNOSTIC_COREAPI.line_out('The following subcontracting components are not associated with any price list:');
349: JTF_DIAGNOSTIC_COREAPI.BRPrint;
350: l_sqltxt := ' SELECT DISTINCT
351: SEGMENT1 "Item"

Line 348: JTF_DIAGNOSTIC_COREAPI.line_out('The following subcontracting components are not associated with any price list:');

344: l_statusStr VARCHAR2(10);
345: BEGIN
346: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
347: JTF_DIAGNOSTIC_COREAPI.SectionPrint('8. CHECKING PRICE LISTS');
348: JTF_DIAGNOSTIC_COREAPI.line_out('The following subcontracting components are not associated with any price list:');
349: JTF_DIAGNOSTIC_COREAPI.BRPrint;
350: l_sqltxt := ' SELECT DISTINCT
351: SEGMENT1 "Item"
352: FROM mtl_system_items_b msi

Line 349: JTF_DIAGNOSTIC_COREAPI.BRPrint;

345: BEGIN
346: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_SUCCESS;
347: JTF_DIAGNOSTIC_COREAPI.SectionPrint('8. CHECKING PRICE LISTS');
348: JTF_DIAGNOSTIC_COREAPI.line_out('The following subcontracting components are not associated with any price list:');
349: JTF_DIAGNOSTIC_COREAPI.BRPrint;
350: l_sqltxt := ' SELECT DISTINCT
351: SEGMENT1 "Item"
352: FROM mtl_system_items_b msi
353: WHERE subcontracting_component IN (1,2)

Line 362: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');

358: AND NOT EXISTS
359: ( SELECT 1 FROM qp_list_lines
360: WHERE qp_price_list_pvt.get_inventory_item_id(list_line_id) = msi.inventory_item_id)';
361:
362: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364: IF l_count >0 THEN
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define a valid price for these subcontracting components');
366: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 363: JTF_DIAGNOSTIC_COREAPI.BRPrint;

359: ( SELECT 1 FROM qp_list_lines
360: WHERE qp_price_list_pvt.get_inventory_item_id(list_line_id) = msi.inventory_item_id)';
361:
362: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364: IF l_count >0 THEN
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define a valid price for these subcontracting components');
366: JTF_DIAGNOSTIC_COREAPI.BRPrint;
367: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;

Line 365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define a valid price for these subcontracting components');

361:
362: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364: IF l_count >0 THEN
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define a valid price for these subcontracting components');
366: JTF_DIAGNOSTIC_COREAPI.BRPrint;
367: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
368: END IF;
369: RETURN l_statusStr;

Line 366: JTF_DIAGNOSTIC_COREAPI.BRPrint;

362: l_count := JTF_DIAGNOSTIC_COREAPI.display_SQL(l_sqltxt,'');
363: JTF_DIAGNOSTIC_COREAPI.BRPrint;
364: IF l_count >0 THEN
365: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please define a valid price for these subcontracting components');
366: JTF_DIAGNOSTIC_COREAPI.BRPrint;
367: l_statusStr := JMF_SUBCONTRCT_DIAG_UTIL.G_STATUS_FAILURE;
368: END IF;
369: RETURN l_statusStr;
370: