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.OZF_WEBADI_INTERFACE_PVT dependencies on OZF_UTILITY_PVT

Line 172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

168:
169:
170: BEGIN
171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
173: END IF;
174:
175: OPEN csr_code_conversion(p_external_code
176: , p_party_id

Line 215: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'fetched db rec');

211: ,l_code_conversion_rec.security_group_id
212: ,l_code_conversion_rec.org_id;
213:
214: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
215: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'fetched db rec');
216: END IF;
217:
218: l_code_conversion_tbl := ozf_code_conversion_pvt.code_conversion_tbl_type();
219:

Line 296: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);

292: l_code_conversion_tbl(1).external_code := p_external_code;
293: l_code_conversion_tbl(1).internal_code := p_internal_code;
294:
295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
296: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
297: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
298: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
299: END IF;
300:

Line 297: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);

293: l_code_conversion_tbl(1).internal_code := p_internal_code;
294:
295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
296: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
297: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
298: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
299: END IF;
300:
301: OZF_CODE_CONVERSION_PVT.create_code_conversion

Line 298: OZF_UTILITY_PVT.debug_message('calling create code conversion ');

294:
295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
296: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
297: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
298: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
299: END IF;
300:
301: OZF_CODE_CONVERSION_PVT.create_code_conversion
302: (

Line 326: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id_tbl(i) );

322: END IF;
323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
324: FOR i IN 1 .. l_code_conversion_id_tbl.count
325: LOOP
326: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id_tbl(i) );
327: END LOOP;
328: END IF;
329: ELSE
330: fnd_message.set_name ('OZF', 'OZF_REQ_PARAM_MISSING');

Line 349: -- OZF_UTILITY_PVT.debug_message('after update code conversion'||x_msg_Count);

345: p_code_conversion_tbl => l_code_conversion_tbl,
346: x_object_version_number => l_object_version_no_tbl
347: );
348:
349: -- OZF_UTILITY_PVT.debug_message('after update code conversion'||x_msg_Count);
350:
351: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
352: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_true);
353: OZF_UTILITY_PVT.debug_message('Message '||l_message);

Line 353: OZF_UTILITY_PVT.debug_message('Message '||l_message);

349: -- OZF_UTILITY_PVT.debug_message('after update code conversion'||x_msg_Count);
350:
351: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
352: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_true);
353: OZF_UTILITY_PVT.debug_message('Message '||l_message);
354:
355: IF length( l_message) > 30 THEN
356: l_message := substr(l_message,1,30);
357: END IF;

Line 368: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_no_tbl(i) );

364:
365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
366: FOR i IN 1 .. l_object_version_no_tbl.count
367: LOOP
368: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_no_tbl(i) );
369: END LOOP;
370: END IF;
371: END IF;
372:

Line 386: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));

382: END IF; */
383: raise_application_error( -20000, l_message);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: IF length( SQLERRM) > 30 THEN
386: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
387: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
388: ELSE
389: fnd_message.set_name ('OZF', SQLERRM);
390: END IF;

Line 394: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));

390: END IF;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: WHEN OTHERS THEN
393: IF length( SQLERRM) > 30 THEN
394: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
395: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
396: ELSE
397: fnd_message.set_name ('OZF', SQLERRM);
398: END IF;

Line 713: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

709: WHERE name = cv_org_name;
710:
711: BEGIN
712:
713: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
714:
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: -- R12 MOAC Enhancement (+)

Line 740: OZF_UTILITY_PVT.debug_message('Private API: 1');

736: END IF;
737:
738: MO_GLOBAL.set_policy_context('S', l_org_id);
739: -- R12 MOAC Enhancement (-)
740: OZF_UTILITY_PVT.debug_message('Private API: 1');
741:
742: -- Batch Level Required Value Validation
743:
744: IF p_report_start_date IS NULL THEN

Line 1289: OZF_UTILITY_PVT.debug_message('batch status '|| l_batch_status);

1285:
1286: OPEN c_chk_line_exists (P_BATCH_NUMBER);
1287: FETCH c_chk_line_exists INTO l_line_count, l_batch_status;
1288: CLOSE c_chk_line_exists;
1289: OZF_UTILITY_PVT.debug_message('batch status '|| l_batch_status);
1290: -- Transaction Purpose Code Validations
1291: IF l_batch_status IS NOT NULL THEN
1292: IF l_batch_status = 'CLOSED' THEN
1293: fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');

Line 1304: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'

1300: /*
1301: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');
1302: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);
1303: FND_MESSAGE.set_token( 'STATUS'
1304: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1305: ,l_batch_status
1306: )
1307: );
1308: */

Line 1310: l_batch_status_n := OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'

1306: )
1307: );
1308: */
1309: --l_error_message := FND_MESSAGE.get();
1310: l_batch_status_n := OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1311: ,l_batch_status
1312: );
1313: l_error_message := 'Cannot update '||l_batch_status_n||' batch';
1314: RAISE_APPLICATION_ERROR( -20000, l_error_message);

Line 1359: ozf_utility_pvt.debug_message('Resale Batch ID '||G_RESALE_BATCH_ID);

1355: -- ==============================================================================
1356:
1357: G_RESALE_BATCH_ID := l_resale_batch_rec.resale_batch_id;
1358:
1359: ozf_utility_pvt.debug_message('Resale Batch ID '||G_RESALE_BATCH_ID);
1360: ozf_utility_pvt.debug_message('Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id);
1361:
1362: l_text := l_text || 'Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id||' \n ';
1363:

Line 1360: ozf_utility_pvt.debug_message('Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id);

1356:
1357: G_RESALE_BATCH_ID := l_resale_batch_rec.resale_batch_id;
1358:
1359: ozf_utility_pvt.debug_message('Resale Batch ID '||G_RESALE_BATCH_ID);
1360: ozf_utility_pvt.debug_message('Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id);
1361:
1362: l_text := l_text || 'Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id||' \n ';
1363:
1364: -- R12 MOAC Enhancement (+)

Line 1460: ozf_utility_pvt.debug_message('Creating Line Record');

1456:
1457: END IF; -- l_batch_count = 0
1458:
1459: l_text := l_text||'Creating Line Record'||' \n ';
1460: ozf_utility_pvt.debug_message('Creating Line Record');
1461: -- Bug 5417666 (+)
1462: --SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1463: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1464: l_int_line_tbl(1).org_id := l_org_id;

Line 1470: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);

1466:
1467: SELECT ozf_resale_lines_int_all_s.nextval
1468: INTO l_int_line_tbl(1).resale_line_int_id
1469: FROM DUAL;
1470: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1471: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN
1472: SELECT resale_batch_id
1473: INTO l_int_line_tbl(1).resale_batch_id
1474: FROM ozf_resale_batches

Line 1480: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id );

1476: ELSE
1477: l_int_line_tbl(1).resale_batch_id := G_RESALE_BATCH_ID;
1478:
1479: END IF;
1480: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id );
1481:
1482: l_text := l_text||'Resale Batch ID '||l_int_line_tbl(1).resale_batch_id||' \n ';
1483:
1484: insert_resale_int_line (

Line 1505: ozf_utility_pvt.debug_message('P_BATCH_NUMBER '||P_BATCH_NUMBER);

1501: END IF;
1502:
1503: ELSIF l_status_code IN ('OPEN','NEW','PROCESSED','DISPUTED') AND p_resale_line_int_id IS NOT NULL THEN
1504:
1505: ozf_utility_pvt.debug_message('P_BATCH_NUMBER '||P_BATCH_NUMBER);
1506: ozf_utility_pvt.debug_message('P_RESALE_LINE_INT_ID '||P_RESALE_LINE_INT_ID);
1507:
1508: OPEN c_get_update_record (P_BATCH_NUMBER, P_RESALE_LINE_INT_ID);
1509: LOOP

Line 1506: ozf_utility_pvt.debug_message('P_RESALE_LINE_INT_ID '||P_RESALE_LINE_INT_ID);

1502:
1503: ELSIF l_status_code IN ('OPEN','NEW','PROCESSED','DISPUTED') AND p_resale_line_int_id IS NOT NULL THEN
1504:
1505: ozf_utility_pvt.debug_message('P_BATCH_NUMBER '||P_BATCH_NUMBER);
1506: ozf_utility_pvt.debug_message('P_RESALE_LINE_INT_ID '||P_RESALE_LINE_INT_ID);
1507:
1508: OPEN c_get_update_record (P_BATCH_NUMBER, P_RESALE_LINE_INT_ID);
1509: LOOP
1510:

Line 1530: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);

1526:
1527: l_int_line_tbl(1).resale_line_int_id := p_resale_line_int_id;
1528: l_int_line_tbl(1).resale_batch_id := l_resale_batch_rec.resale_batch_id;
1529: l_int_line_tbl(1).object_version_number := l_object_version_no_tbl(1);
1530: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1531: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id);
1532:
1533: l_text := l_text||'resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id;
1534:

Line 1531: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id);

1527: l_int_line_tbl(1).resale_line_int_id := p_resale_line_int_id;
1528: l_int_line_tbl(1).resale_batch_id := l_resale_batch_rec.resale_batch_id;
1529: l_int_line_tbl(1).object_version_number := l_object_version_no_tbl(1);
1530: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1531: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id);
1532:
1533: l_text := l_text||'resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id;
1534:
1535: -- l_int_line_tbl(1).status_code := l_line_status;

Line 1568: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);

1564: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567:
1568: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1569: END IF;
1570:
1571: l_text := l_text||'Updating line record ';
1572: Update_Resale_Int_Line

Line 1592: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);

1588: raise_application_error( -20000, l_error_message);
1589: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1593: l_text := l_text||'line record updated';
1594:
1595: OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);
1596:

Line 1595: OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);

1591: END IF;
1592: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1593: l_text := l_text||'line record updated';
1594:
1595: OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);
1596:
1597: G_RESALE_BATCH_NUMBER := P_BATCH_NUMBER;
1598:
1599: END IF;

Line 1601: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));

1597: G_RESALE_BATCH_NUMBER := P_BATCH_NUMBER;
1598:
1599: END IF;
1600:
1601: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1602: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1603: UTL_FILE.PUTF(l_file,l_text);
1604: UTL_FILE.FCLOSE(l_file);
1605:

Line 1602: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));

1598:
1599: END IF;
1600:
1601: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1602: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1603: UTL_FILE.PUTF(l_file,l_text);
1604: UTL_FILE.FCLOSE(l_file);
1605:
1606: EXCEPTION

Line 1627: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));

1623: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: UTL_FILE.FCLOSE(l_file);
1626: IF length( SQLERRM) > 30 THEN
1627: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1628: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1629: ELSE
1630: fnd_message.set_name ('OZF', SQLERRM);
1631: END IF;

Line 1636: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));

1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: WHEN OTHERS THEN
1634: UTL_FILE.FCLOSE(l_file);
1635: IF length( SQLERRM) > 30 THEN
1636: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1637: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1638: ELSE
1639: fnd_message.set_name ('OZF', SQLERRM);
1640: END IF;

Line 1735: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

1731: FROM ozf_resale_batches
1732: WHERE batch_number = pc_batch_number;
1733:
1734: BEGIN
1735: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
1736: x_return_status := FND_API.G_RET_STS_SUCCESS;
1737:
1738: l_resale_batch_rec.resale_batch_id := p_int_batch_rec.resale_batch_id;
1739: l_resale_batch_rec.batch_number := p_int_batch_rec.batch_number;

Line 1833: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

1829: (p_count => x_msg_count,
1830: p_data => x_msg_data
1831: );
1832:
1833: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2217: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

2213: AND resale_batch_id = pc_batch_id;
2214:
2215:
2216: BEGIN
2217: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2218: x_return_status := FND_API.G_RET_STS_SUCCESS;
2219: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2220:
2221: l_int_line_tbl.extend;

Line 2219: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);

2215:
2216: BEGIN
2217: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2218: x_return_status := FND_API.G_RET_STS_SUCCESS;
2219: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2220:
2221: l_int_line_tbl.extend;
2222: l_int_line_tbl(1).resale_batch_id := p_int_line_tbl(1).resale_batch_id;
2223:

Line 2451: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);

2447: ,l_int_line_tbl(1).line_attribute14
2448: ,l_int_line_tbl(1).line_attribute15
2449: ,l_int_line_tbl(1).org_id ;
2450: CLOSE get_int_line;
2451: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2452:
2453: Ozf_pre_process_pvt.Update_interface_line
2454: (
2455: p_api_version_number => 1.0,

Line 2464: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);

2460: x_return_status => x_return_status,
2461: x_msg_count => x_msg_count,
2462: x_msg_data => x_msg_data
2463: );
2464: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2465:
2466: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2467: RAISE FND_API.G_EXC_ERROR;
2468: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2478: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

2474: (p_count => x_msg_count,
2475: p_data => x_msg_data
2476: );
2477:
2478: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
2479: EXCEPTION
2480:
2481: WHEN FND_API.G_EXC_ERROR THEN
2482: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2798: ozf_utility_pvt.debug_message('Problem with updating line record '||SQLERRM);

2794: EXCEPTION
2795:
2796: WHEN OTHERS THEN
2797:
2798: ozf_utility_pvt.debug_message('Problem with updating line record '||SQLERRM);
2799: RAISE FND_API.G_EXC_ERROR;
2800:
2801: END;
2802: