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 222: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

218: AND CONCATENATED_SEGMENTS = p_item_name;
219:
220: BEGIN
221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
222: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
223: END IF;
224:
225: l_org_id := P_ORG_ID;
226: --Code Conversion for Customer Trade Profile for Account

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

366:
367: END IF;
368:
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
370: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'fetched db rec');
371: END IF;
372:
373: l_code_conversion_tbl := ozf_code_conversion_pvt.code_conversion_tbl_type();
374:

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

471: l_code_conversion_tbl(1).internal_code := p_internal_code;
472: END IF;
473:
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
475: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
476: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
477: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
478: END IF;
479:

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

472: END IF;
473:
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
475: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
476: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
477: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
478: END IF;
479:
480: OZF_CODE_CONVERSION_PVT.create_code_conversion

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

473:
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
475: OZF_UTILITY_PVT.debug_message('external code '|| p_external_code);
476: OZF_UTILITY_PVT.debug_message('start date active '|| p_start_date_active);
477: OZF_UTILITY_PVT.debug_message('calling create code conversion ');
478: END IF;
479:
480: OZF_CODE_CONVERSION_PVT.create_code_conversion
481: (

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

502: END IF;
503: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
504: FOR i IN 1 .. l_code_conversion_id_tbl.count
505: LOOP
506: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id_tbl(i) );
507: END LOOP;
508: END IF;
509: ELSE
510: fnd_message.set_name ('OZF', 'OZF_REQ_PARAM_MISSING');

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

527: p_code_conversion_tbl => l_code_conversion_tbl,
528: x_object_version_number => l_object_version_no_tbl
529: );
530:
531: -- OZF_UTILITY_PVT.debug_message('after update code conversion'||x_msg_Count);
532:
533: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
534: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_true);
535: OZF_UTILITY_PVT.debug_message('Message '||l_message);

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

531: -- OZF_UTILITY_PVT.debug_message('after update code conversion'||x_msg_Count);
532:
533: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
534: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_true);
535: OZF_UTILITY_PVT.debug_message('Message '||l_message);
536:
537: IF length( l_message) > 30 THEN
538: l_message := substr(l_message,1,30);
539: END IF;

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

547:
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
549: FOR i IN 1 .. l_object_version_no_tbl.count
550: LOOP
551: OZF_UTILITY_PVT.debug_message('Object Version Number ' || l_object_version_no_tbl(i) );
552: END LOOP;
553: END IF;
554: END IF;
555: --ninarasi Bug 12717648 FP of bug 12718707

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

572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: --Fix for Bug#10624065(+)
574: /*
575: IF length( SQLERRM) > 30 THEN
576: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
577: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
578: ELSE
579: */
580: fnd_message.set_name ('OZF', NVL(l_code,l_message));

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

584: WHEN OTHERS THEN
585: -- Fix for Bug#10624065(+)
586: /*
587: IF length( SQLERRM) > 30 THEN
588: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
589: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
590: ELSE
591: */
592: fnd_message.set_name ('OZF', NVL(l_code,l_message));

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

956: WHERE name = cv_org_name;
957:
958: BEGIN
959:
960: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
961:
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: -- R12 MOAC Enhancement (+)

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

985: END IF;
986:
987: MO_GLOBAL.set_policy_context('S', l_org_id);
988: -- R12 MOAC Enhancement (-)
989: OZF_UTILITY_PVT.debug_message('Private API: 1');
990:
991: -- Batch Level Required Value Validation
992:
993: IF p_report_start_date IS NULL THEN

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

1673:
1674: OPEN c_chk_line_exists (P_BATCH_NUMBER);
1675: FETCH c_chk_line_exists INTO l_line_count, l_batch_status;
1676: CLOSE c_chk_line_exists;
1677: OZF_UTILITY_PVT.debug_message('batch status '|| l_batch_status);
1678: -- Transaction Purpose Code Validations
1679: IF l_batch_status IS NOT NULL THEN
1680: IF l_batch_status = 'CLOSED' THEN
1681: fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');

Line 1693: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'

1689: /*
1690: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');
1691: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);
1692: FND_MESSAGE.set_token( 'STATUS'
1693: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1694: ,l_batch_status
1695: )
1696: );
1697: */

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

1695: )
1696: );
1697: */
1698: --l_error_message := FND_MESSAGE.get();
1699: l_batch_status_n := OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1700: ,l_batch_status
1701: );
1702: l_error_message := 'Cannot update '||l_batch_status_n||' batch';
1703: RAISE_APPLICATION_ERROR( -20000, l_error_message);

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

1744: -- ==============================================================================
1745:
1746: G_RESALE_BATCH_ID := l_resale_batch_rec.resale_batch_id;
1747:
1748: ozf_utility_pvt.debug_message('Resale Batch ID '||G_RESALE_BATCH_ID);
1749: ozf_utility_pvt.debug_message('Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id);
1750:
1751: l_text := l_text || 'Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id||' \n ';
1752:

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

1745:
1746: G_RESALE_BATCH_ID := l_resale_batch_rec.resale_batch_id;
1747:
1748: ozf_utility_pvt.debug_message('Resale Batch ID '||G_RESALE_BATCH_ID);
1749: ozf_utility_pvt.debug_message('Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id);
1750:
1751: l_text := l_text || 'Resale Batch ID in create '|| l_resale_batch_rec.resale_batch_id||' \n ';
1752:
1753: -- R12 MOAC Enhancement (+)

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

1847:
1848: END IF; -- l_batch_count = 0
1849:
1850: l_text := l_text||'Creating Line Record'||' \n ';
1851: ozf_utility_pvt.debug_message('Creating Line Record');
1852: -- Bug 5417666 (+)
1853: --SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1854: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1855: l_int_line_tbl(1).org_id := l_org_id;

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

1857:
1858: SELECT ozf_resale_lines_int_all_s.nextval
1859: INTO l_int_line_tbl(1).resale_line_int_id
1860: FROM DUAL;
1861: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1862: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN
1863: SELECT resale_batch_id
1864: INTO l_int_line_tbl(1).resale_batch_id
1865: FROM ozf_resale_batches

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

1867: ELSE
1868: l_int_line_tbl(1).resale_batch_id := G_RESALE_BATCH_ID;
1869:
1870: END IF;
1871: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id );
1872:
1873: l_text := l_text||'Resale Batch ID '||l_int_line_tbl(1).resale_batch_id||' \n ';
1874:
1875: insert_resale_int_line (

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

1893: END IF;
1894:
1895: ELSIF l_status_code IN ('OPEN','NEW','PROCESSED','DISPUTED') AND p_resale_line_int_id IS NOT NULL THEN
1896:
1897: ozf_utility_pvt.debug_message('P_BATCH_NUMBER '||P_BATCH_NUMBER);
1898: ozf_utility_pvt.debug_message('P_RESALE_LINE_INT_ID '||P_RESALE_LINE_INT_ID);
1899:
1900: OPEN c_get_update_record (P_BATCH_NUMBER, P_RESALE_LINE_INT_ID);
1901: LOOP

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

1894:
1895: ELSIF l_status_code IN ('OPEN','NEW','PROCESSED','DISPUTED') AND p_resale_line_int_id IS NOT NULL THEN
1896:
1897: ozf_utility_pvt.debug_message('P_BATCH_NUMBER '||P_BATCH_NUMBER);
1898: ozf_utility_pvt.debug_message('P_RESALE_LINE_INT_ID '||P_RESALE_LINE_INT_ID);
1899:
1900: OPEN c_get_update_record (P_BATCH_NUMBER, P_RESALE_LINE_INT_ID);
1901: LOOP
1902:

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

1918:
1919: l_int_line_tbl(1).resale_line_int_id := p_resale_line_int_id;
1920: l_int_line_tbl(1).resale_batch_id := l_resale_batch_rec.resale_batch_id;
1921: l_int_line_tbl(1).object_version_number := l_object_version_no_tbl(1);
1922: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1923: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id);
1924:
1925: l_text := l_text||'resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id;
1926:

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

1919: l_int_line_tbl(1).resale_line_int_id := p_resale_line_int_id;
1920: l_int_line_tbl(1).resale_batch_id := l_resale_batch_rec.resale_batch_id;
1921: l_int_line_tbl(1).object_version_number := l_object_version_no_tbl(1);
1922: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1923: ozf_utility_pvt.debug_message('resale_batch_id '||l_int_line_tbl(1).resale_batch_id);
1924:
1925: l_text := l_text||'resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id;
1926:
1927: -- l_int_line_tbl(1).status_code := l_line_status;

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

1957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1959: END IF;
1960:
1961: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1962: END IF;
1963:
1964: l_text := l_text||'Updating line record ';
1965: Update_Resale_Int_Line

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

1982: raise_application_error( -20000, l_error_message);
1983: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF;
1986: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1987: l_text := l_text||'line record updated';
1988:
1989: OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);
1990:

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

1985: END IF;
1986: ozf_utility_pvt.debug_message('x_return_status '||x_return_status);
1987: l_text := l_text||'line record updated';
1988:
1989: OZF_UTILITY_PVT.debug_message('Interface Lines Table is updated successfully ' ||x_return_status);
1990:
1991: G_RESALE_BATCH_NUMBER := P_BATCH_NUMBER;
1992:
1993: END IF;

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

1991: G_RESALE_BATCH_NUMBER := P_BATCH_NUMBER;
1992:
1993: END IF;
1994:
1995: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1996: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1997: UTL_FILE.PUTF(l_file,l_text);
1998: UTL_FILE.FCLOSE(l_file);
1999:

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

1992:
1993: END IF;
1994:
1995: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1996: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1997: UTL_FILE.PUTF(l_file,l_text);
1998: UTL_FILE.FCLOSE(l_file);
1999:
2000: EXCEPTION

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

2019: UTL_FILE.FCLOSE(l_file);
2020: -- Fix for Bug#10624065(+)
2021: /*
2022: IF length( SQLERRM) > 30 THEN
2023: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
2024: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
2025: ELSE
2026: */
2027: fnd_message.set_name ('OZF', NVL(l_code,l_error_message));

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

2032: UTL_FILE.FCLOSE(l_file);
2033: -- Fix for Bug#10624065(+)
2034: /*
2035: IF length( SQLERRM) > 30 THEN
2036: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
2037: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
2038: ELSE
2039: */
2040: fnd_message.set_name ('OZF', NVL(l_code,l_error_message));

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

2134: FROM ozf_resale_batches
2135: WHERE batch_number = pc_batch_number;
2136:
2137: BEGIN
2138: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: l_resale_batch_rec.resale_batch_id := p_int_batch_rec.resale_batch_id;
2142: l_resale_batch_rec.batch_number := p_int_batch_rec.batch_number;

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

2231: (p_count => x_msg_count,
2232: p_data => x_msg_data
2233: );
2234:
2235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
2236: EXCEPTION
2237:
2238: WHEN FND_API.G_EXC_ERROR THEN
2239: x_return_status := FND_API.G_RET_STS_ERROR;

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

2623: AND resale_batch_id = pc_batch_id;
2624:
2625:
2626: BEGIN
2627: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2628: x_return_status := FND_API.G_RET_STS_SUCCESS;
2629: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2630:
2631: l_int_line_tbl.extend;

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

2625:
2626: BEGIN
2627: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2628: x_return_status := FND_API.G_RET_STS_SUCCESS;
2629: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2630:
2631: l_int_line_tbl.extend;
2632: l_int_line_tbl(1).resale_batch_id := p_int_line_tbl(1).resale_batch_id;
2633:

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

2864: ,l_int_line_tbl(1).supplier_item_cost
2865: ,l_int_line_tbl(1).supplier_item_uom;
2866: -- For Bug#9447673 SSD IDSM ER(-)
2867: CLOSE get_int_line;
2868: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2869:
2870: Ozf_pre_process_pvt.Update_interface_line
2871: (
2872: p_api_version_number => 1.0,

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

2877: x_return_status => x_return_status,
2878: x_msg_count => x_msg_count,
2879: x_msg_data => x_msg_data
2880: );
2881: OZF_UTILITY_PVT.debug_message('x_return_status ' || x_return_status);
2882:
2883: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2884: RAISE FND_API.G_EXC_ERROR;
2885: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2891: (p_count => x_msg_count,
2892: p_data => x_msg_data
2893: );
2894:
2895: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
2896: EXCEPTION
2897:
2898: WHEN FND_API.G_EXC_ERROR THEN
2899: x_return_status := FND_API.G_RET_STS_ERROR;

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

3219: EXCEPTION
3220:
3221: WHEN OTHERS THEN
3222:
3223: ozf_utility_pvt.debug_message('Problem with updating line record '||SQLERRM);
3224: RAISE FND_API.G_EXC_ERROR;
3225:
3226: END;
3227: