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 FND_API

Line 483: p_init_msg_list => FND_API.G_FALSE,

479:
480: OZF_CODE_CONVERSION_PVT.create_code_conversion
481: (
482: p_api_version_number => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE,
484: p_commit => FND_API.G_FALSE,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => x_return_Status,
487: x_msg_count => x_msg_Count,

Line 484: p_commit => FND_API.G_FALSE,

480: OZF_CODE_CONVERSION_PVT.create_code_conversion
481: (
482: p_api_version_number => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE,
484: p_commit => FND_API.G_FALSE,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => x_return_Status,
487: x_msg_count => x_msg_Count,
488: x_msg_data => x_msg_Data,

Line 485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

481: (
482: p_api_version_number => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE,
484: p_commit => FND_API.G_FALSE,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
486: x_return_status => x_return_Status,
487: x_msg_count => x_msg_Count,
488: x_msg_data => x_msg_Data,
489: p_code_conversion_tbl => l_code_conversion_tbl,

Line 492: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN

488: x_msg_data => x_msg_Data,
489: p_code_conversion_tbl => l_code_conversion_tbl,
490: x_code_conversion_id_tbl => l_code_conversion_id_tbl);
491:
492: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
493: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
494: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
495: raise_application_error( -20000, l_message);
496: END IF;

Line 494: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

490: x_code_conversion_id_tbl => l_code_conversion_id_tbl);
491:
492: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN
493: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
494: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
495: raise_application_error( -20000, l_message);
496: END IF;
497: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
498: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_ERROR');

Line 497: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN

493: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
494: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
495: raise_application_error( -20000, l_message);
496: END IF;
497: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
498: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_ERROR');
499: l_message := fnd_message.get();
500: l_code := 'OZF_WADI_CREATE_ERROR';
501: raise_application_error( -20000, l_message);

Line 521: p_init_msg_list => FND_API.G_FALSE,

517:
518: OZF_CODE_CONVERSION_PVT.update_code_conversion
519: (
520: p_api_version_number => 1.0 ,
521: p_init_msg_list => FND_API.G_FALSE,
522: p_commit => FND_API.G_FALSE,
523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
524: x_return_status => x_return_Status,
525: x_msg_count => x_msg_Count,

Line 522: p_commit => FND_API.G_FALSE,

518: OZF_CODE_CONVERSION_PVT.update_code_conversion
519: (
520: p_api_version_number => 1.0 ,
521: p_init_msg_list => FND_API.G_FALSE,
522: p_commit => FND_API.G_FALSE,
523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
524: x_return_status => x_return_Status,
525: x_msg_count => x_msg_Count,
526: x_msg_data => x_msg_Data,

Line 523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

519: (
520: p_api_version_number => 1.0 ,
521: p_init_msg_list => FND_API.G_FALSE,
522: p_commit => FND_API.G_FALSE,
523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
524: x_return_status => x_return_Status,
525: x_msg_count => x_msg_Count,
526: x_msg_data => x_msg_Data,
527: p_code_conversion_tbl => l_code_conversion_tbl,

Line 533: IF x_return_Status = FND_API.G_RET_STS_ERROR THEN

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);
536:
537: IF length( l_message) > 30 THEN

Line 534: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_true);

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);
536:
537: IF length( l_message) > 30 THEN
538: l_message := substr(l_message,1,30);

Line 541: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN

537: IF length( l_message) > 30 THEN
538: l_message := substr(l_message,1,30);
539: END IF;
540: raise_application_error( -20000, l_message);
541: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
542: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_ERROR');
543: l_message := fnd_message.get();
544: l_code := 'OZF_WADI_UPDATE_ERROR';
545: raise_application_error( -20000, l_message);

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563: --commit;
564:
565: EXCEPTION
566: WHEN ozf_webadi_error THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: /* IF length( l_message) > 30 THEN
569: l_message := substr(l_message,1,30);
570: END IF; */
571: raise_application_error( -20000, l_message);

Line 572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

568: /* IF length( l_message) > 30 THEN
569: l_message := substr(l_message,1,30);
570: END IF; */
571: raise_application_error( -20000, l_message);
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));

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: */
580: fnd_message.set_name ('OZF', NVL(l_code,l_message));
581: --END IF;
582: --Fix for Bug#10624065(-)
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: WHEN OTHERS THEN
585: -- Fix for Bug#10624065(+)
586: /*
587: IF length( SQLERRM) > 30 THEN

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591: */
592: fnd_message.set_name ('OZF', NVL(l_code,l_message));
593: --END IF;
594: --Fix for Bug#10624065(-)
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: END CODE_CONVERSION_WEBADI;
597:
598: --//Added to get the Location count
599: --//Bugfix 10234121

Line 962: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 (+)
965: IF P_ORG_ID IS NULL THEN
966: fnd_message.set_name ('OZF', 'OZF_ENTER_OPEARTING_UNIT');

Line 983: --x_return_status := FND_API.G_RET_STS_ERROR;

979: fnd_message.set_name ('OZF', 'OZF_ENTER_OPERATING_UNIT');
980: l_error_message := fnd_message.get();
981: l_code := 'OZF_ENTER_OPERATING_UNIT';
982: raise_application_error( -20000, l_error_message);
983: --x_return_status := FND_API.G_RET_STS_ERROR;
984: --RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987: MO_GLOBAL.set_policy_context('S', l_org_id);

Line 984: --RAISE FND_API.G_EXC_ERROR;

980: l_error_message := fnd_message.get();
981: l_code := 'OZF_ENTER_OPERATING_UNIT';
982: raise_application_error( -20000, l_error_message);
983: --x_return_status := FND_API.G_RET_STS_ERROR;
984: --RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987: MO_GLOBAL.set_policy_context('S', l_org_id);
988: -- R12 MOAC Enhancement (-)

Line 1877: p_init_msg_list => FND_API.G_FALSE,

1873: l_text := l_text||'Resale Batch ID '||l_int_line_tbl(1).resale_batch_id||' \n ';
1874:
1875: insert_resale_int_line (
1876: p_api_version_number => 1.0,
1877: p_init_msg_list => FND_API.G_FALSE,
1878: p_Commit => FND_API.G_FALSE,
1879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1880: p_int_line_tbl => l_int_line_tbl,
1881: x_return_status => x_return_status,

Line 1878: p_Commit => FND_API.G_FALSE,

1874:
1875: insert_resale_int_line (
1876: p_api_version_number => 1.0,
1877: p_init_msg_list => FND_API.G_FALSE,
1878: p_Commit => FND_API.G_FALSE,
1879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1880: p_int_line_tbl => l_int_line_tbl,
1881: x_return_status => x_return_status,
1882: x_msg_count => l_msg_count,

Line 1879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1875: insert_resale_int_line (
1876: p_api_version_number => 1.0,
1877: p_init_msg_list => FND_API.G_FALSE,
1878: p_Commit => FND_API.G_FALSE,
1879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1880: p_int_line_tbl => l_int_line_tbl,
1881: x_return_status => x_return_status,
1882: x_msg_count => l_msg_count,
1883: x_msg_data => l_msg_data );

Line 1885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1881: x_return_status => x_return_status,
1882: x_msg_count => l_msg_count,
1883: x_msg_data => l_msg_data );
1884:
1885: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1886: l_text := l_text||'Error in Create Line '||SQLERRM||' \n ';
1887: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_LINE_ERROR');
1888: l_error_message := fnd_message.get();
1889: l_code := 'OZF_WADI_CREATE_LINE_ERROR';

Line 1891: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1887: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_LINE_ERROR');
1888: l_error_message := fnd_message.get();
1889: l_code := 'OZF_WADI_CREATE_LINE_ERROR';
1890: raise_application_error( -20000, l_error_message);
1891: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;
1894:
1895: ELSIF l_status_code IN ('OPEN','NEW','PROCESSED','DISPUTED') AND p_resale_line_int_id IS NOT NULL THEN

Line 1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1888: l_error_message := fnd_message.get();
1889: l_code := 'OZF_WADI_CREATE_LINE_ERROR';
1890: raise_application_error( -20000, l_error_message);
1891: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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:

Line 1942: p_init_msg_list => FND_API.G_FALSE,

1938:
1939: Update_Resale_Batch
1940: (
1941: p_api_version_number => 1.0,
1942: p_init_msg_list => FND_API.G_FALSE,
1943: P_Commit => FND_API.G_FALSE,
1944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1945: p_int_batch_rec => l_resale_batch_rec,
1946: x_return_status => x_return_status,

Line 1943: P_Commit => FND_API.G_FALSE,

1939: Update_Resale_Batch
1940: (
1941: p_api_version_number => 1.0,
1942: p_init_msg_list => FND_API.G_FALSE,
1943: P_Commit => FND_API.G_FALSE,
1944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1945: p_int_batch_rec => l_resale_batch_rec,
1946: x_return_status => x_return_status,
1947: x_msg_count => l_msg_count,

Line 1944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1940: (
1941: p_api_version_number => 1.0,
1942: p_init_msg_list => FND_API.G_FALSE,
1943: P_Commit => FND_API.G_FALSE,
1944: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1945: p_int_batch_rec => l_resale_batch_rec,
1946: x_return_status => x_return_status,
1947: x_msg_count => l_msg_count,
1948: x_msg_data => l_msg_data

Line 1951: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1947: x_msg_count => l_msg_count,
1948: x_msg_data => l_msg_data
1949: );
1950:
1951: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1952: l_text := l_text||'Error in Update Batch '||SQLERRM||' \n ';
1953: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');
1954: l_error_message := fnd_message.get();
1955: l_code := 'OZF_WADI_UPDATE_BATCH_ERROR';

Line 1957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1953: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');
1954: l_error_message := fnd_message.get();
1955: l_code := 'OZF_WADI_UPDATE_BATCH_ERROR';
1956: raise_application_error( -20000, l_error_message);
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);

Line 1958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1954: l_error_message := fnd_message.get();
1955: l_code := 'OZF_WADI_UPDATE_BATCH_ERROR';
1956: raise_application_error( -20000, l_error_message);
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;

Line 1968: p_init_msg_list => FND_API.G_FALSE,

1964: l_text := l_text||'Updating line record ';
1965: Update_Resale_Int_Line
1966: (
1967: p_api_version_number => 1.0,
1968: p_init_msg_list => FND_API.G_FALSE,
1969: P_Commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: p_int_line_tbl => l_int_line_tbl,
1972: x_return_status => x_return_status,

Line 1969: P_Commit => FND_API.G_FALSE,

1965: Update_Resale_Int_Line
1966: (
1967: p_api_version_number => 1.0,
1968: p_init_msg_list => FND_API.G_FALSE,
1969: P_Commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: p_int_line_tbl => l_int_line_tbl,
1972: x_return_status => x_return_status,
1973: x_msg_count => l_msg_count,

Line 1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1966: (
1967: p_api_version_number => 1.0,
1968: p_init_msg_list => FND_API.G_FALSE,
1969: P_Commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: p_int_line_tbl => l_int_line_tbl,
1972: x_return_status => x_return_status,
1973: x_msg_count => l_msg_count,
1974: x_msg_data => l_msg_data

Line 1977: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1973: x_msg_count => l_msg_count,
1974: x_msg_data => l_msg_data
1975: );
1976:
1977: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1978: l_text := l_text||'Error in Update Line '||SQLERRM||' \n ';
1979: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');
1980: l_error_message := fnd_message.get();
1981: l_code := 'OZF_WADI_UPDATE_LINE_ERROR';

Line 1983: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1979: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');
1980: l_error_message := fnd_message.get();
1981: l_code := 'OZF_WADI_UPDATE_LINE_ERROR';
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';

Line 1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1980: l_error_message := fnd_message.get();
1981: l_code := 'OZF_WADI_UPDATE_LINE_ERROR';
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:

Line 2002: x_return_status := FND_API.G_RET_STS_ERROR;

1998: UTL_FILE.FCLOSE(l_file);
1999:
2000: EXCEPTION
2001: WHEN ozf_webadi_error THEN
2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003: raise_application_error( -20000, l_error_message);
2004: WHEN UTL_FILE.INVALID_PATH THEN
2005: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
2006: WHEN UTL_FILE.INVALID_MODE THEN

Line 2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2014: WHEN UTL_FILE.READ_ERROR then
2015: RAISE_APPLICATION_ERROR(-20105,'Read Error');
2016: WHEN UTL_FILE.INTERNAL_ERROR then
2017: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2019: UTL_FILE.FCLOSE(l_file);
2020: -- Fix for Bug#10624065(+)
2021: /*
2022: IF length( SQLERRM) > 30 THEN

Line 2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2026: */
2027: fnd_message.set_name ('OZF', NVL(l_code,l_error_message));
2028: --END IF;
2029: -- Fix for Bug#10624065(-)
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: WHEN OTHERS THEN
2032: UTL_FILE.FCLOSE(l_file);
2033: -- Fix for Bug#10624065(+)
2034: /*

Line 2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2039: */
2040: fnd_message.set_name ('OZF', NVL(l_code,l_error_message));
2041: --END IF;
2042: -- Fix for Bug#10624065(-)
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2044:
2045: END RESALE_WEBADI;
2046:
2047: PROCEDURE Update_Resale_Batch (

Line 2049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2045: END RESALE_WEBADI;
2046:
2047: PROCEDURE Update_Resale_Batch (
2048: p_api_version_number IN NUMBER,
2049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2050: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2052: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
2053: x_return_status OUT NOCOPY VARCHAR2,

Line 2050: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

2046:
2047: PROCEDURE Update_Resale_Batch (
2048: p_api_version_number IN NUMBER,
2049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2050: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2052: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
2053: x_return_status OUT NOCOPY VARCHAR2,
2054: x_msg_count OUT NOCOPY NUMBER,

Line 2051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2047: PROCEDURE Update_Resale_Batch (
2048: p_api_version_number IN NUMBER,
2049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2050: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2052: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
2053: x_return_status OUT NOCOPY VARCHAR2,
2054: x_msg_count OUT NOCOPY NUMBER,
2055: x_msg_data OUT NOCOPY VARCHAR2

Line 2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2143: l_resale_batch_rec.status_code := 'OPEN';

Line 2215: p_init_msg_list => FND_API.G_FALSE,

2211:
2212: ozf_pre_process_pvt.update_interface_batch
2213: (
2214: p_api_version_number => 1.0,
2215: p_init_msg_list => FND_API.G_FALSE,
2216: P_Commit => FND_API.G_FALSE,
2217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2218: p_int_batch_rec => l_resale_batch_rec,
2219: x_return_status => x_return_status,

Line 2216: P_Commit => FND_API.G_FALSE,

2212: ozf_pre_process_pvt.update_interface_batch
2213: (
2214: p_api_version_number => 1.0,
2215: p_init_msg_list => FND_API.G_FALSE,
2216: P_Commit => FND_API.G_FALSE,
2217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2218: p_int_batch_rec => l_resale_batch_rec,
2219: x_return_status => x_return_status,
2220: x_msg_count => x_msg_count,

Line 2217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2213: (
2214: p_api_version_number => 1.0,
2215: p_init_msg_list => FND_API.G_FALSE,
2216: P_Commit => FND_API.G_FALSE,
2217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2218: p_int_batch_rec => l_resale_batch_rec,
2219: x_return_status => x_return_status,
2220: x_msg_count => x_msg_count,
2221: x_msg_data => x_msg_data

Line 2224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2220: x_msg_count => x_msg_count,
2221: x_msg_data => x_msg_data
2222: );
2223:
2224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2225: RAISE FND_API.G_EXC_ERROR;
2226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;

Line 2225: RAISE FND_API.G_EXC_ERROR;

2221: x_msg_data => x_msg_data
2222: );
2223:
2224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2225: RAISE FND_API.G_EXC_ERROR;
2226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;
2229: -- Standard call to get message count and if count is 1, get message info.

Line 2226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2222: );
2223:
2224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2225: RAISE FND_API.G_EXC_ERROR;
2226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;
2229: -- Standard call to get message count and if count is 1, get message info.
2230: FND_MSG_PUB.Count_And_Get

Line 2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2223:
2224: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2225: RAISE FND_API.G_EXC_ERROR;
2226: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2228: END IF;
2229: -- Standard call to get message count and if count is 1, get message info.
2230: FND_MSG_PUB.Count_And_Get
2231: (p_count => x_msg_count,

Line 2238: WHEN FND_API.G_EXC_ERROR THEN

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;
2240: -- Standard call to get message count and if count=1, get the message
2241: FND_MSG_PUB.Count_And_Get (
2242: p_encoded => FND_API.G_FALSE,

Line 2239: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2240: -- Standard call to get message count and if count=1, get the message
2241: FND_MSG_PUB.Count_And_Get (
2242: p_encoded => FND_API.G_FALSE,
2243: p_count => x_msg_count,

Line 2242: p_encoded => FND_API.G_FALSE,

2238: WHEN FND_API.G_EXC_ERROR THEN
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: -- Standard call to get message count and if count=1, get the message
2241: FND_MSG_PUB.Count_And_Get (
2242: p_encoded => FND_API.G_FALSE,
2243: p_count => x_msg_count,
2244: p_data => x_msg_data
2245: );
2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2242: p_encoded => FND_API.G_FALSE,
2243: p_count => x_msg_count,
2244: p_data => x_msg_data
2245: );
2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2248: -- Standard call to get message count and if count=1, get the message
2249: FND_MSG_PUB.Count_And_Get (
2250: p_encoded => FND_API.G_FALSE,

Line 2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2243: p_count => x_msg_count,
2244: p_data => x_msg_data
2245: );
2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2248: -- Standard call to get message count and if count=1, get the message
2249: FND_MSG_PUB.Count_And_Get (
2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,

Line 2250: p_encoded => FND_API.G_FALSE,

2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2248: -- Standard call to get message count and if count=1, get the message
2249: FND_MSG_PUB.Count_And_Get (
2250: p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data
2253: );
2254: WHEN OTHERS THEN

Line 2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2251: p_count => x_msg_count,
2252: p_data => x_msg_data
2253: );
2254: WHEN OTHERS THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:
2257: -- Standard call to get message count and if count=1, get the message
2258: FND_MSG_PUB.Count_And_Get (
2259: p_encoded => FND_API.G_FALSE,

Line 2259: p_encoded => FND_API.G_FALSE,

2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:
2257: -- Standard call to get message count and if count=1, get the message
2258: FND_MSG_PUB.Count_And_Get (
2259: p_encoded => FND_API.G_FALSE,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data
2262: );
2263: END Update_Resale_Batch;

Line 2270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2266:
2267:
2268: PROCEDURE Update_Resale_Int_Line (
2269: p_api_version_number IN NUMBER,
2270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2271: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2273: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2274: x_return_status OUT NOCOPY VARCHAR2,

Line 2271: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

2267:
2268: PROCEDURE Update_Resale_Int_Line (
2269: p_api_version_number IN NUMBER,
2270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2271: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2273: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2274: x_return_status OUT NOCOPY VARCHAR2,
2275: x_msg_count OUT NOCOPY NUMBER,

Line 2272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2268: PROCEDURE Update_Resale_Int_Line (
2269: p_api_version_number IN NUMBER,
2270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2271: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2273: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2274: x_return_status OUT NOCOPY VARCHAR2,
2275: x_msg_count OUT NOCOPY NUMBER,
2276: x_msg_data OUT NOCOPY VARCHAR2

Line 2628: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2632: l_int_line_tbl(1).resale_batch_id := p_int_line_tbl(1).resale_batch_id;

Line 2873: p_init_msg_list => FND_API.G_FALSE,

2869:
2870: Ozf_pre_process_pvt.Update_interface_line
2871: (
2872: p_api_version_number => 1.0,
2873: p_init_msg_list => FND_API.G_FALSE,
2874: P_Commit => FND_API.G_FALSE,
2875: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2876: p_int_line_tbl => l_int_line_tbl,
2877: x_return_status => x_return_status,

Line 2874: P_Commit => FND_API.G_FALSE,

2870: Ozf_pre_process_pvt.Update_interface_line
2871: (
2872: p_api_version_number => 1.0,
2873: p_init_msg_list => FND_API.G_FALSE,
2874: P_Commit => FND_API.G_FALSE,
2875: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2876: p_int_line_tbl => l_int_line_tbl,
2877: x_return_status => x_return_status,
2878: x_msg_count => x_msg_count,

Line 2875: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2871: (
2872: p_api_version_number => 1.0,
2873: p_init_msg_list => FND_API.G_FALSE,
2874: P_Commit => FND_API.G_FALSE,
2875: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2876: p_int_line_tbl => l_int_line_tbl,
2877: x_return_status => x_return_status,
2878: x_msg_count => x_msg_count,
2879: x_msg_data => x_msg_data

Line 2883: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END IF;

Line 2884: RAISE FND_API.G_EXC_ERROR;

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
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END IF;
2888:

Line 2885: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END IF;
2888:
2889: -- Standard call to get message count and if count is 1, get message info.

Line 2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END IF;
2888:
2889: -- Standard call to get message count and if count is 1, get message info.
2890: FND_MSG_PUB.Count_And_Get

Line 2898: WHEN FND_API.G_EXC_ERROR THEN

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;
2900: -- Standard call to get message count and if count=1, get the message
2901: FND_MSG_PUB.Count_And_Get (
2902: p_encoded => FND_API.G_FALSE,

Line 2899: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2900: -- Standard call to get message count and if count=1, get the message
2901: FND_MSG_PUB.Count_And_Get (
2902: p_encoded => FND_API.G_FALSE,
2903: p_count => x_msg_count,

Line 2902: p_encoded => FND_API.G_FALSE,

2898: WHEN FND_API.G_EXC_ERROR THEN
2899: x_return_status := FND_API.G_RET_STS_ERROR;
2900: -- Standard call to get message count and if count=1, get the message
2901: FND_MSG_PUB.Count_And_Get (
2902: p_encoded => FND_API.G_FALSE,
2903: p_count => x_msg_count,
2904: p_data => x_msg_data
2905: );
2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2902: p_encoded => FND_API.G_FALSE,
2903: p_count => x_msg_count,
2904: p_data => x_msg_data
2905: );
2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: -- Standard call to get message count and if count=1, get the message
2909: FND_MSG_PUB.Count_And_Get (
2910: p_encoded => FND_API.G_FALSE,

Line 2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2903: p_count => x_msg_count,
2904: p_data => x_msg_data
2905: );
2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: -- Standard call to get message count and if count=1, get the message
2909: FND_MSG_PUB.Count_And_Get (
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => x_msg_count,

Line 2910: p_encoded => FND_API.G_FALSE,

2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: -- Standard call to get message count and if count=1, get the message
2909: FND_MSG_PUB.Count_And_Get (
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );
2914: WHEN OTHERS THEN

Line 2915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2911: p_count => x_msg_count,
2912: p_data => x_msg_data
2913: );
2914: WHEN OTHERS THEN
2915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2916:
2917: -- Standard call to get message count and if count=1, get the message
2918: FND_MSG_PUB.Count_And_Get (
2919: p_encoded => FND_API.G_FALSE,

Line 2919: p_encoded => FND_API.G_FALSE,

2915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2916:
2917: -- Standard call to get message count and if count=1, get the message
2918: FND_MSG_PUB.Count_And_Get (
2919: p_encoded => FND_API.G_FALSE,
2920: p_count => x_msg_count,
2921: p_data => x_msg_data
2922: );
2923: END Update_Resale_Int_Line;

Line 2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2923: END Update_Resale_Int_Line;
2924:
2925: procedure insert_resale_int_line (
2926: p_api_version_number IN NUMBER,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2930: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2931: x_return_status OUT NOCOPY VARCHAR2,

Line 2928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

2924:
2925: procedure insert_resale_int_line (
2926: p_api_version_number IN NUMBER,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2930: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2931: x_return_status OUT NOCOPY VARCHAR2,
2932: x_msg_count OUT NOCOPY NUMBER,

Line 2929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2925: procedure insert_resale_int_line (
2926: p_api_version_number IN NUMBER,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2930: p_int_line_tbl IN ozf_pre_process_pvt.resale_line_int_tbl_type,
2931: x_return_status OUT NOCOPY VARCHAR2,
2932: x_msg_count OUT NOCOPY NUMBER,
2933: x_msg_data OUT NOCOPY VARCHAR2

Line 2946: IF FND_API.to_Boolean( p_init_msg_list )

2942: l_org_id NUMBER;
2943: l_amount NUMBER := 0;
2944: BEGIN
2945:
2946: IF FND_API.to_Boolean( p_init_msg_list )
2947: THEN
2948: FND_MSG_PUB.initialize;
2949: END IF;
2950:

Line 2954: x_return_status := FND_API.G_RET_STS_SUCCESS;

2950:
2951: -- Debug Message
2952:
2953: -- Initialize API return status to SUCCESS
2954: x_return_status := FND_API.G_RET_STS_SUCCESS;
2955:
2956: BEGIN
2957:
2958:

Line 3224: RAISE FND_API.G_EXC_ERROR;

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:
3228:

Line 3237: WHEN FND_API.G_EXC_ERROR THEN

3233: );
3234:
3235: EXCEPTION
3236:
3237: WHEN FND_API.G_EXC_ERROR THEN
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: -- Standard call to get message count and if count=1, get the message
3240: FND_MSG_PUB.Count_And_Get (
3241: p_encoded => FND_API.G_FALSE,

Line 3238: x_return_status := FND_API.G_RET_STS_ERROR;

3234:
3235: EXCEPTION
3236:
3237: WHEN FND_API.G_EXC_ERROR THEN
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: -- Standard call to get message count and if count=1, get the message
3240: FND_MSG_PUB.Count_And_Get (
3241: p_encoded => FND_API.G_FALSE,
3242: p_count => x_msg_count,

Line 3241: p_encoded => FND_API.G_FALSE,

3237: WHEN FND_API.G_EXC_ERROR THEN
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: -- Standard call to get message count and if count=1, get the message
3240: FND_MSG_PUB.Count_And_Get (
3241: p_encoded => FND_API.G_FALSE,
3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );
3245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3241: p_encoded => FND_API.G_FALSE,
3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );
3245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3247: -- Standard call to get message count and if count=1, get the message
3248: FND_MSG_PUB.Count_And_Get (
3249: p_encoded => FND_API.G_FALSE,

Line 3246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );
3245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3247: -- Standard call to get message count and if count=1, get the message
3248: FND_MSG_PUB.Count_And_Get (
3249: p_encoded => FND_API.G_FALSE,
3250: p_count => x_msg_count,

Line 3249: p_encoded => FND_API.G_FALSE,

3245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3247: -- Standard call to get message count and if count=1, get the message
3248: FND_MSG_PUB.Count_And_Get (
3249: p_encoded => FND_API.G_FALSE,
3250: p_count => x_msg_count,
3251: p_data => x_msg_data
3252: );
3253: WHEN OTHERS THEN

Line 3254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3250: p_count => x_msg_count,
3251: p_data => x_msg_data
3252: );
3253: WHEN OTHERS THEN
3254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3255: -- Standard call to get message count and if count=1, get the message
3256: FND_MSG_PUB.Count_And_Get (
3257: p_encoded => FND_API.G_FALSE,
3258: p_count => x_msg_count,

Line 3257: p_encoded => FND_API.G_FALSE,

3253: WHEN OTHERS THEN
3254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3255: -- Standard call to get message count and if count=1, get the message
3256: FND_MSG_PUB.Count_And_Get (
3257: p_encoded => FND_API.G_FALSE,
3258: p_count => x_msg_count,
3259: p_data => x_msg_data
3260: );
3261: