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.CST_SUBELEMENTS_PVT dependencies on FND_FILE

Line 94: fnd_file.put_line(fnd_file.log,'Calling getNonMatchingSubElements...');

90: RAISE fnd_api.g_exc_error;
91: end if;
92:
93: -- Call API depending on summary option
94: fnd_file.put_line(fnd_file.log,'Calling getNonMatchingSubElements...');
95:
96: fnd_file.put_line(fnd_file.log,'Test Message');
97:
98: getNonMatchingSubElements

Line 96: fnd_file.put_line(fnd_file.log,'Test Message');

92:
93: -- Call API depending on summary option
94: fnd_file.put_line(fnd_file.log,'Calling getNonMatchingSubElements...');
95:
96: fnd_file.put_line(fnd_file.log,'Test Message');
97:
98: getNonMatchingSubElements
99: ( p_api_version => 1.0,
100: x_return_status => l_return_status,

Line 116: fnd_file.put_line(fnd_file.log,x_msg_data);

112:
113:
114: /* ***** Added by AD for error handling ***** */
115: IF (x_return_status <>'S') THEN
116: fnd_file.put_line(fnd_file.log,x_msg_data);
117: l_api_message := 'Compatible_API_Call returned Error';
118: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
119: FND_MESSAGE.set_token('TEXT', l_api_message);
120: fnd_msg_pub.add;

Line 129: fnd_file.put_line(fnd_file.log,'create with no nonmatching SE');

125: -- Verify summary option
126: if (p_summary_option = 1) then
127: if ((l_subelement_count = 0) AND (l_department_count = 0)
128: AND (l_activity_count = 0)) then
129: fnd_file.put_line(fnd_file.log,'create with no nonmatching SE');
130: return;
131: else
132: fnd_file.put_line(fnd_file.log,'Calling createSubElements ...');
133: createSubElements

Line 132: fnd_file.put_line(fnd_file.log,'Calling createSubElements ...');

128: AND (l_activity_count = 0)) then
129: fnd_file.put_line(fnd_file.log,'create with no nonmatching SE');
130: return;
131: else
132: fnd_file.put_line(fnd_file.log,'Calling createSubElements ...');
133: createSubElements
134: ( p_api_version => 1.0,
135: p_subelement_tbl => l_subelement_tbl,
136: p_department_tbl => l_department_tbl,

Line 151: fnd_file.put_line(fnd_file.log,x_msg_data);

147:
148:
149: /* ***** Added by AD for error handling ***** */
150: IF (x_return_status <>'S') THEN
151: fnd_file.put_line(fnd_file.log,x_msg_data);
152: l_api_message := 'createSubElements returned Error';
153: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
154: FND_MESSAGE.set_token('TEXT', l_api_message);
155: fnd_msg_pub.add;

Line 162: fnd_file.put_line(fnd_file.log,'calling summarizeSubElements ...');

158:
159: end if;
160: elsif ((p_summary_option = 2)
161: OR (p_summary_option = 3 AND l_subelement_count >= 0)) then
162: fnd_file.put_line(fnd_file.log,'calling summarizeSubElements ...');
163: summarizeSubElements
164: ( p_api_version => 1.0,
165: x_return_status => l_return_status,
166: x_msg_count => l_msg_count,

Line 189: fnd_file.put_line(fnd_file.log,x_msg_data);

185: p_conversion_type => p_conv_type );
186:
187: /* ***** Added by AD for error handling ***** */
188: IF (x_return_status <>'S') THEN
189: fnd_file.put_line(fnd_file.log,x_msg_data);
190: l_api_message := 'summarizeSubElements returned Error';
191: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
192: FND_MESSAGE.set_token('TEXT', l_api_message);
193: fnd_msg_pub.add;

Line 349: FND_FILE.PUT_LINE(FND_FILE.LOG,'From Org, To Org or Cost Group Info is missing');

345: IF(p_from_organization_id IS NULL OR
346: p_to_organization_id IS NULL OR
347: p_group_id IS NULL) THEN
348:
349: FND_FILE.PUT_LINE(FND_FILE.LOG,'From Org, To Org or Cost Group Info is missing');
350: l_api_message := 'From Org, To Org or Cost Group Info is missing';
351: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
352: FND_MESSAGE.set_token('TEXT', l_api_message);
353: FND_MSG_PUB.ADD;

Line 373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many resource with the same code');

369: and organization_id = p_to_organization_id;
370:
371: l_statement := 20;
372: if (l_exists > 1) then
373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many resource with the same code');
374: l_api_message := 'Too many resource with the same code';
375: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
376: FND_MESSAGE.set_token('TEXT', l_api_message);
377: FND_MSG_PUB.ADD;

Line 416: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Dept with the same code');

412: and organization_id = p_to_organization_id;
413:
414: l_statement := 70;
415: if (l_exists > 1) then
416: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Dept with the same code');
417: l_api_message := 'Too many Dept with the same code';
418: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
419: FND_MESSAGE.set_token('TEXT', l_api_message);
420: FND_MSG_PUB.ADD;

Line 457: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Activities with the same code');

453: and nvl(organization_id,p_to_organization_id) = p_to_organization_id;
454:
455: l_statement := 120;
456: if (l_exists > 1) then
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'Too many Activities with the same code');
458: l_api_message := 'Too many Activities with the same code';
459: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
460: FND_MESSAGE.set_token('TEXT', l_api_message);
461: FND_MSG_PUB.ADD;

Line 673: FND_FILE.PUT_LINE(FND_FILE.LOG,'activity count : '

669:
670: ----------------------------------------------------------------------
671: -- cst_activities
672: ----------------------------------------------------------------------
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'activity count : '
674: || TO_CHAR(p_activity_count));
675:
676: FOR l_counter IN 1..p_activity_count
677: LOOP

Line 784: FND_FILE.PUT_LINE(FND_FILE.LOG, l_activity || ' Activity created.');

780: AND ca2.activity = l_activity) ;
781:
782: IF (SQL%ROWCOUNT) > 0 THEN
783:
784: FND_FILE.PUT_LINE(FND_FILE.LOG, l_activity || ' Activity created.');
785:
786: END IF;
787:
788: END LOOP;

Line 793: fnd_file.put_line(fnd_file.log,'dept count : ' || to_char(p_department_count));

789:
790: l_statement := 60;
791:
792: -- departments
793: fnd_file.put_line(fnd_file.log,'dept count : ' || to_char(p_department_count));
794:
795: if (p_department_count > 0) then
796:
797: l_statement := 70;

Line 839: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>getDeptAccounts()');

835: IF p_exact_copy_flag = FND_API.G_FALSE THEN
836:
837: IF (l_to_wsm_flag = 1) THEN
838:
839: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>getDeptAccounts()');
840:
841: getDeptAccounts(
842: p_api_version => 1,
843: p_department_id => l_source_department_id,

Line 852: FND_FILE.PUT_LINE(FND_FILE.LOG, '<

848: x_return_status => x_return_status,
849: x_msg_count => x_msg_count,
850: x_msg_data => x_msg_data );
851:
852: FND_FILE.PUT_LINE(FND_FILE.LOG, '< 853:
854: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
855: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
856: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);

Line 891: fnd_file.put_line(fnd_file.log,'Estimated Scrap Accounting Flag: '||x_est_scrap_acct_flag);

887:
888: x_est_scrap_acct_flag := WSMPUTIL.WSM_ESA_ENABLED(
889: NULL,x_err_num, x_err_msg,p_from_organization_id);
890:
891: fnd_file.put_line(fnd_file.log,'Estimated Scrap Accounting Flag: '||x_est_scrap_acct_flag);
892:
893: IF (x_est_scrap_acct_flag = 0) THEN
894: RAISE fnd_api.g_exc_error;
895: END IF;

Line 995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_department_class_code ||

991: AND bdc2.department_class_code = l_department_class_code);
992:
993: IF (SQL%ROWCOUNT) > 0 THEN
994:
995: FND_FILE.PUT_LINE(FND_FILE.LOG, l_department_class_code ||
996: ' Department class code created.');
997:
998: END IF;
999:

Line 1095: FND_FILE.PUT_LINE(FND_FILE.LOG, l_department_code ||

1091: AND bd2.department_code = l_department_code);
1092:
1093: IF (SQL%ROWCOUNT) > 0 THEN
1094:
1095: FND_FILE.PUT_LINE(FND_FILE.LOG, l_department_code ||
1096: ' Department code created.');
1097:
1098: END IF;
1099:

Line 1129: fnd_file.put_line(fnd_file.log,'subelement count : ' ||

1125:
1126:
1127: END IF;
1128:
1129: fnd_file.put_line(fnd_file.log,'subelement count : ' ||
1130: to_char(p_subelement_count));
1131:
1132: FOR l_counter IN 1..p_subelement_count LOOP
1133:

Line 1137: fnd_file.put_line(fnd_file.log,'subelement(' || to_char(l_counter) || '): ' || to_char(l_source_resource_id));

1133:
1134: l_statement := 180;
1135:
1136: l_source_resource_id := p_subelement_tbl( l_counter).ID;
1137: fnd_file.put_line(fnd_file.log,'subelement(' || to_char(l_counter) || '): ' || to_char(l_source_resource_id));
1138:
1139: l_statement := 190;
1140: SELECT cost_element_id,
1141: purchase_item_id,

Line 1181: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getOSPitem()');

1177:
1178: IF l_dummy IS NULL THEN
1179: l_purchase_item_id := NULL;
1180:
1181: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getOSPitem()');
1182:
1183: getOSPItem (
1184: p_api_version => 1,
1185: p_resource_id => l_source_resource_id,

Line 1193: FND_FILE.PUT_LINE(FND_FILE.LOG,'<

1189: x_return_status => x_return_status,
1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data );
1192:
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1194:
1195: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1196: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1197: fnd_msg_pub.add;

Line 1221: FND_FILE.PUT_LINE(FND_FILE.LOG,

1217: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_NULL');
1218: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1219: fnd_msg_pub.add;
1220:
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,
1222: 'WARNING: OSP Item is missing for Res_id: '
1223: ||TO_CHAR(l_source_resource_id));
1224: --RAISE fnd_api.g_exc_error;
1225: END IF;

Line 1254: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getDefaultActivity()');

1250: IF l_dummy IS NULL THEN
1251:
1252: l_default_activity_id := NULL;
1253:
1254: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getDefaultActivity()');
1255:
1256: getDefaultActivity (
1257: p_api_version => 1,
1258: p_resource_id => l_source_resource_id,

Line 1266: FND_FILE.PUT_LINE(FND_FILE.LOG,'<

1262: x_return_status => x_return_status,
1263: x_msg_count => x_msg_count,
1264: x_msg_data => x_msg_data );
1265:
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1267:
1268: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1269: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1270: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);

Line 1286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Default Activity is null');

1282: l_default_activity_id := l_dummy;
1283: END IF;
1284:
1285: IF l_default_activity_id IS NULL THEN
1286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Default Activity is null');
1287: RAISE fnd_api.g_exc_error;
1288: END IF;
1289:
1290: END IF; /* default activity in from org is not null */

Line 1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getExpenditureType()');

1297: l_statement := 240;
1298:
1299: IF (l_exp_type_required = 1 AND l_expenditure_type IS NULL) THEN
1300:
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getExpenditureType()');
1302:
1303: getExpenditureType (
1304: p_api_version => 1,
1305: p_resource_id => l_source_resource_id,

Line 1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'<

1309: x_return_status => x_return_status,
1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data );
1312:
1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1314:
1315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1316: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1317: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);

Line 1330: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expenditure type is null');

1326: RAISE fnd_api.g_exc_unexpected_error ;
1327: END IF;
1328:
1329: IF (l_expenditure_type IS NULL) THEN
1330: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expenditure type is null');
1331: RAISE fnd_api.g_exc_error;
1332: END IF;
1333: END IF;
1334:

Line 1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getSubelementAcct()');

1344: l_rate_variance_acct := NULL;
1345:
1346: l_statement := 250;
1347:
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'>>getSubelementAcct()');
1349:
1350: getSubelementAcct (
1351: p_api_version => 1,
1352: p_resource_id => l_source_resource_id,

Line 1361: FND_FILE.PUT_LINE(FND_FILE.LOG,'<

1357: x_return_status => x_return_status,
1358: x_msg_count => x_msg_count,
1359: x_msg_data => x_msg_data );
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1362:
1363: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1364: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1365: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);

Line 1497: fnd_file.put_line(fnd_file.log,'counter : ' || to_char(l_counter));

1493: FROM bom_resources br2
1494: WHERE br2.organization_id = p_to_organization_id
1495: AND br2.resource_code = l_resource_code);
1496:
1497: fnd_file.put_line(fnd_file.log,'counter : ' || to_char(l_counter));
1498:
1499: IF (SQL%ROWCOUNT) > 0 THEN
1500:
1501: FND_FILE.PUT_LINE(FND_FILE.LOG, l_resource_code ||

Line 1501: FND_FILE.PUT_LINE(FND_FILE.LOG, l_resource_code ||

1497: fnd_file.put_line(fnd_file.log,'counter : ' || to_char(l_counter));
1498:
1499: IF (SQL%ROWCOUNT) > 0 THEN
1500:
1501: FND_FILE.PUT_LINE(FND_FILE.LOG, l_resource_code ||
1502: ' Resource code created.');
1503:
1504: END IF;
1505:

Line 2422: fnd_file.put_line(fnd_file.log,'subelement_count : ' || to_char(p_subelement_count));

2418: end if;
2419:
2420: IF (p_summary_option = 3) THEN
2421:
2422: fnd_file.put_line(fnd_file.log,'subelement_count : ' || to_char(p_subelement_count));
2423:
2424: FOR l_counter IN 1..p_subelement_count LOOP
2425:
2426: -- Obtain the cost subelement name

Line 2430: fnd_file.put_line(fnd_file.log,'resource(' || to_char(l_counter) || '): ' || l_resource_code);

2426: -- Obtain the cost subelement name
2427: l_statement := 90;
2428:
2429: l_resource_code := p_subelement_tbl( l_counter).code;
2430: fnd_file.put_line(fnd_file.log,'resource(' || to_char(l_counter) || '): ' || l_resource_code);
2431:
2432: l_statement := 100;
2433:
2434: -- Convert to Item Basis Type for non-matching subelements

Line 2466: fnd_file.put_line(fnd_file.log,'dept count : ' || to_char(p_department_count));

2462:
2463: END LOOP;
2464:
2465: /* Nonmatching rows imply those with matching subelements but nonmatching departments and activities */
2466: fnd_file.put_line(fnd_file.log,'dept count : ' || to_char(p_department_count));
2467: FOR l_counter IN 1..p_department_count LOOP
2468:
2469: -- Obtain the department name
2470: l_statement := 102;

Line 2472: fnd_file.put_line(fnd_file.log,'dept(' || to_char(l_counter) || '): ' || l_dept_code);

2468:
2469: -- Obtain the department name
2470: l_statement := 102;
2471: l_dept_code := p_department_tbl( l_counter).code;
2472: fnd_file.put_line(fnd_file.log,'dept(' || to_char(l_counter) || '): ' || l_dept_code);
2473:
2474: l_statement := 104;
2475: -- Convert to Item Basis Type
2476: -- Update the resource_id and resource_code to -1 for future deletion

Line 2507: fnd_file.put_line(fnd_file.log,'activity count : ' || to_char(p_activity_count));

2503: AND nvl(CICDI.resource_code,'0') <> '-1';
2504:
2505: END LOOP;
2506:
2507: fnd_file.put_line(fnd_file.log,'activity count : ' || to_char(p_activity_count));
2508: FOR l_counter IN 1..p_activity_count LOOP
2509:
2510: -- Obtain the activity name
2511: l_statement := 106;

Line 2513: fnd_file.put_line(fnd_file.log,'activity(' || to_char(l_counter) || '): ' || l_activity_code);

2509:
2510: -- Obtain the activity name
2511: l_statement := 106;
2512: l_activity_code := p_activity_tbl( l_counter).code;
2513: fnd_file.put_line(fnd_file.log,'activity(' || to_char(l_counter) || '): ' || l_activity_code);
2514:
2515: l_statement := 108;
2516:
2517: -- Convert to Item Basis Type for non-matching subelements