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.PO_RETROACTIVE_PRICING_PVT dependencies on FND_API

Line 103: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds

99: * po_headers or po_releases with the new revision number and set
100: * authorization_status to "Requires Reapproval" and initiate
101: * Workflow if the document was already in Approved state.
102: * Returns:
103: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
104: * FND_API.G_RET_STS_ERROR if control action fails
105: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
106: */
107: --------------------------------------------------------------------------------

Line 104: * FND_API.G_RET_STS_ERROR if control action fails

100: * authorization_status to "Requires Reapproval" and initiate
101: * Workflow if the document was already in Approved state.
102: * Returns:
103: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
104: * FND_API.G_RET_STS_ERROR if control action fails
105: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
106: */
107: --------------------------------------------------------------------------------
108: --Start of Comments

Line 105: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

101: * Workflow if the document was already in Approved state.
102: * Returns:
103: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
104: * FND_API.G_RET_STS_ERROR if control action fails
105: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
106: */
107: --------------------------------------------------------------------------------
108: --Start of Comments
109: --Name: MassUpdate_Releases

Line 158: -- FND_API.G_RET_STS_SUCCESS if API succeeds

154: --p_communicate_update
155: -- Communicate Price Updates to Supplier
156: --OUT:
157: --x_return_status
158: -- FND_API.G_RET_STS_SUCCESS if API succeeds
159: -- FND_API.G_RET_STS_ERROR if API fails
160: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
161: --Testing:
162: --

Line 159: -- FND_API.G_RET_STS_ERROR if API fails

155: -- Communicate Price Updates to Supplier
156: --OUT:
157: --x_return_status
158: -- FND_API.G_RET_STS_SUCCESS if API succeeds
159: -- FND_API.G_RET_STS_ERROR if API fails
160: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
161: --Testing:
162: --
163: --End of Comments

Line 160: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

156: --OUT:
157: --x_return_status
158: -- FND_API.G_RET_STS_SUCCESS if API succeeds
159: -- FND_API.G_RET_STS_ERROR if API fails
160: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
161: --Testing:
162: --
163: --End of Comments
164: --------------------------------------------------------------------------------

Line 663: IF (NOT FND_API.Compatible_API_Call(l_api_version

659:
660:
661: -- Standard call to check for call compatibility
662:
663: IF (NOT FND_API.Compatible_API_Call(l_api_version
664: ,p_api_version
665: ,l_api_name
666: ,G_PKG_NAME))
667: THEN

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: ,p_api_version
665: ,l_api_name
666: ,G_PKG_NAME))
667: THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: -- Initialize API return status to success
672:

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: END IF;
670:
671: -- Initialize API return status to success
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: IF g_debug_stmt then
676: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
677: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,

Line 1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1741:
1742: PO_DEBUG.put_line('End of Retroactive Pricing Program');
1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1749: l_module,SQLERRM(SQLCODE));

Line 1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1742: PO_DEBUG.put_line('End of Retroactive Pricing Program');
1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1749: l_module,SQLERRM(SQLCODE));
1750: END IF;

Line 1753: x_return_status := FND_API.G_RET_STS_ERROR;

1749: l_module,SQLERRM(SQLCODE));
1750: END IF;
1751: ROLLBACK;
1752: when l_tax_failure then
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1755: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1756: l_module,SQLERRM(SQLCODE));
1757: END IF;

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR;

1756: l_module,SQLERRM(SQLCODE));
1757: END IF;
1758: ROLLBACK;
1759: when no_data_found then
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1762: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1763: l_module,SQLERRM(SQLCODE));
1764: END IF;

Line 1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1763: l_module,SQLERRM(SQLCODE));
1764: END IF;
1765: ROLLBACK;
1766: when others then
1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1768: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1770: l_module,SQLERRM(SQLCODE));
1771: END IF;

Line 2006: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2002: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2003: 'Callin Tax : Return Status ' ||l_return_status);
2004: END IF;
2005: END IF;
2006: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2007: RAISE l_tax_failure;
2008: END IF;
2009: --
2010: END LOOP;

Line 2154: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module,
2151: 'Callin Tax : Return Status ' ||l_return_status);
2152: END IF;
2153: END IF;
2154: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2155: RAISE l_tax_failure;
2156: END IF;
2157: --
2158: END LOOP;

Line 2689: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2685: * erroring out here but just logging it and then continue
2686: * trying to submit next document for approval.
2687: */
2688:
2689: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2690: l_msg_buf := null;
2691: l_msg_buf := FND_MSG_PUB.Get(p_msg_index => 1,
2692: p_encoded => 'F');
2693: l_msg_buf := 'Std PO ' ||g_po_header_id_table(i)||

Line 2700: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and

2696: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2697: l_module,l_msg_buf);
2698: END IF;
2699: end if;
2700: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2701: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2702:
2703: l_msg_buf := 'Std PO: ' ||g_po_header_id_table(i)||
2704: ' Online Report Id: '||x_online_report_id;

Line 2701: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN

2697: l_module,l_msg_buf);
2698: END IF;
2699: end if;
2700: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2701: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2702:
2703: l_msg_buf := 'Std PO: ' ||g_po_header_id_table(i)||
2704: ' Online Report Id: '||x_online_report_id;
2705: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2733: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and

2729: --
2730: end if;
2731: l_module := g_log_head||l_api_name||'.'||'010'||'.';
2732:
2733: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2734: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN
2735:
2736: PO_RETROACTIVE_PRICING_PVT.Retroactive_Launch_Approval
2737: ( p_doc_id => g_po_header_id_table(i),

Line 2734: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN

2730: end if;
2731: l_module := g_log_head||l_api_name||'.'||'010'||'.';
2732:
2733: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2734: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN
2735:
2736: PO_RETROACTIVE_PRICING_PVT.Retroactive_Launch_Approval
2737: ( p_doc_id => g_po_header_id_table(i),
2738: p_doc_type => 'PO',

Line 2834: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2830: * are really exception that happened but we are not
2831: * erroring out here but just logging it and then continue
2832: * trying to submit next document for approval.
2833: */
2834: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2835: l_msg_buf := null;
2836: l_msg_buf := FND_MSG_PUB.Get(p_msg_index => 1,
2837: p_encoded => 'F');
2838: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||

Line 2846: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and

2842: l_module,l_msg_buf);
2843: END IF;
2844: end if;
2845:
2846: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2847: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2848:
2849: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2850: 'Online Report Id '||x_online_report_id;

Line 2847: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN

2843: END IF;
2844: end if;
2845:
2846: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2847: (x_sub_check_status = FND_API.G_RET_STS_ERROR)) THEN
2848:
2849: l_msg_buf := 'Release ' ||g_po_release_id_table(i)||
2850: 'Online Report Id '||x_online_report_id;
2851: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 2879: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and

2875: --
2876: end if;
2877:
2878: l_module := g_log_head||l_api_name||'.'||'010'||'.';
2879: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2880: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN
2881:
2882: PO_RETROACTIVE_PRICING_PVT.Retroactive_Launch_Approval
2883: ( p_doc_id => g_po_release_id_table(i),

Line 2880: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN

2876: end if;
2877:
2878: l_module := g_log_head||l_api_name||'.'||'010'||'.';
2879: If ((x_return_status = FND_API.G_RET_STS_SUCCESS) and
2880: (x_sub_check_status = FND_API.G_RET_STS_SUCCESS)) THEN
2881:
2882: PO_RETROACTIVE_PRICING_PVT.Retroactive_Launch_Approval
2883: ( p_doc_id => g_po_release_id_table(i),
2884: p_doc_type => 'RELEASE',

Line 3459: -- FND_API.G_RET_STS_SUCCESS if API succeeds

3455: -- PO : Standard PO
3456: -- RELEASE : Release
3457: --OUT:
3458: --x_return_status
3459: -- FND_API.G_RET_STS_SUCCESS if API succeeds
3460: -- FND_API.G_RET_STS_ERROR if API fails
3461: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3462: --x_msg_count
3463: -- Number of Error messages

Line 3460: -- FND_API.G_RET_STS_ERROR if API fails

3456: -- RELEASE : Release
3457: --OUT:
3458: --x_return_status
3459: -- FND_API.G_RET_STS_SUCCESS if API succeeds
3460: -- FND_API.G_RET_STS_ERROR if API fails
3461: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3462: --x_msg_count
3463: -- Number of Error messages
3464: --x_msg_data

Line 3461: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

3457: --OUT:
3458: --x_return_status
3459: -- FND_API.G_RET_STS_SUCCESS if API succeeds
3460: -- FND_API.G_RET_STS_ERROR if API fails
3461: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3462: --x_msg_count
3463: -- Number of Error messages
3464: --x_msg_data
3465: -- Contains error msg in case x_return_status returned

Line 3466: -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

3462: --x_msg_count
3463: -- Number of Error messages
3464: --x_msg_data
3465: -- Contains error msg in case x_return_status returned
3466: -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
3467: --Testing:
3468: --
3469: --End of Comments
3470: -------------------------------------------------------------------------------

Line 3730: x_return_status := FND_API.G_RET_STS_SUCCESS;

3726: ELSE
3727: po_debug.set_file_io(null);
3728: END IF;
3729:
3730: x_return_status := FND_API.G_RET_STS_SUCCESS;
3731: x_msg_count := 0;
3732: x_msg_data := NULL;
3733:
3734: IF g_debug_stmt THEN

Line 3741: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

3737: PO_DEBUG.debug_var(l_log_head,l_progress,'p_document_type', p_document_type);
3738: END IF;
3739:
3740: -- Standard call to check for call compatibility
3741: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
3742: THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;
3745:

Line 3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3739:
3740: -- Standard call to check for call compatibility
3741: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
3742: THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;
3745:
3746: -- Bug 3314204, Pass Inventory API price in functional price
3747: SELECT nvl(FND.precision, 2)

Line 3887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

3883: PO_DEBUG.put_line('Return status : ' || l_return_status);
3884: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3885: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3886:
3887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

3884: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3885: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3886:
3887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

Line 3889: RAISE FND_API.G_EXC_ERROR;

3885: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3886:
3887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3893: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

Line 3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3893: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3894:
3895: /** INVCONV rseshadr - call OPM API for process organizations **/

Line 3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

3888: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3893: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3894:
3895: /** INVCONV rseshadr - call OPM API for process organizations **/
3896: l_progress := '106';

Line 3893: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

3889: RAISE FND_API.G_EXC_ERROR;
3890: ELSE
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3893: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3894:
3895: /** INVCONV rseshadr - call OPM API for process organizations **/
3896: l_progress := '106';
3897: IF g_debug_stmt THEN

Line 3905: p_init_msg_list => FND_API.G_FALSE,

3901: PO_DEBUG.put_line('Call GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns');
3902:
3903: GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns(
3904: p_api_version => 1.0,
3905: p_init_msg_list => FND_API.G_FALSE,
3906: p_commit => FND_API.G_FALSE,
3907: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3908: p_po_header_id => l_po_header_ids_tbl(i),
3909: p_po_release_id => l_po_release_ids_tbl(i),

Line 3906: p_commit => FND_API.G_FALSE,

3902:
3903: GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns(
3904: p_api_version => 1.0,
3905: p_init_msg_list => FND_API.G_FALSE,
3906: p_commit => FND_API.G_FALSE,
3907: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3908: p_po_header_id => l_po_header_ids_tbl(i),
3909: p_po_release_id => l_po_release_ids_tbl(i),
3910: p_po_line_id => l_po_line_ids_tbl(i),

Line 3907: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3903: GMF_Rcv_Accounting_Pkg.Create_Adjust_Txns(
3904: p_api_version => 1.0,
3905: p_init_msg_list => FND_API.G_FALSE,
3906: p_commit => FND_API.G_FALSE,
3907: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3908: p_po_header_id => l_po_header_ids_tbl(i),
3909: p_po_release_id => l_po_release_ids_tbl(i),
3910: p_po_line_id => l_po_line_ids_tbl(i),
3911: p_po_line_location_id=> l_line_location_ids_tbl(i),

Line 3929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

3925: PO_DEBUG.put_line('Return status : ' || l_return_status);
3926: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3927: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3928:
3929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

3926: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
3927: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3928:
3929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

Line 3931: RAISE FND_API.G_EXC_ERROR;

3927: PO_DEBUG.put_line('Message data : '|| l_msg_data);
3928:
3929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3935: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

Line 3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3935: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3936: /** INVCONV rseshadr - end of changes **/
3937:

Line 3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

3930: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3935: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3936: /** INVCONV rseshadr - end of changes **/
3937:
3938: END LOOP;

Line 3935: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

3931: RAISE FND_API.G_EXC_ERROR;
3932: ELSE
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
3935: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
3936: /** INVCONV rseshadr - end of changes **/
3937:
3938: END LOOP;
3939:

Line 4209: p_init_msg_lst => FND_API.G_FALSE,

4205: PO_DEBUG.put_line('Call Inventory API');
4206:
4207: INV_LOGICAL_TRANSACTIONS_PUB.create_logical_transactions(
4208: p_api_version_number => 1.0,
4209: p_init_msg_lst => FND_API.G_FALSE,
4210: p_validation_flag => FND_API.G_TRUE,
4211: p_trx_flow_header_id => NULL,
4212: p_defer_logical_transactions=> NULL,
4213: p_logical_trx_type_code => 4,

Line 4210: p_validation_flag => FND_API.G_TRUE,

4206:
4207: INV_LOGICAL_TRANSACTIONS_PUB.create_logical_transactions(
4208: p_api_version_number => 1.0,
4209: p_init_msg_lst => FND_API.G_FALSE,
4210: p_validation_flag => FND_API.G_TRUE,
4211: p_trx_flow_header_id => NULL,
4212: p_defer_logical_transactions=> NULL,
4213: p_logical_trx_type_code => 4,
4214: p_exploded_flag => 2,

Line 4231: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

4227: PO_DEBUG.put_line('Return status : ' || l_return_status);
4228: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
4229: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4230:
4231: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then

4228: PO_DEBUG.put_line('Message Count: ' || l_msg_count);
4229: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4230:
4231: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

Line 4233: RAISE FND_API.G_EXC_ERROR;

4229: PO_DEBUG.put_line('Message data : '|| l_msg_data);
4230:
4231: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
4237: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

Line 4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4231: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
4237: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
4238:
4239: END IF; /* IF (l_mtl_index > 0) */

Line 4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */

4232: IF (l_return_status = FND_API.G_RET_STS_ERROR) Then
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
4237: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
4238:
4239: END IF; /* IF (l_mtl_index > 0) */
4240:

Line 4237: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */

4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSE
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF; /* IF (l_return_status = FND_API.G_RET_STS_ERROR) */
4237: END IF; /* IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) */
4238:
4239: END IF; /* IF (l_mtl_index > 0) */
4240:
4241: l_progress := '380';

Line 4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4307:
4308: COMMIT; --
4309:
4310: EXCEPTION
4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4312: ROLLBACK TO RETRO_INVOICE_SP;
4313: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4314: p_encoded => 'F');
4315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4312: ROLLBACK TO RETRO_INVOICE_SP;
4313: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4314: p_encoded => 'F');
4315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4316:
4317: IF g_debug_unexp THEN
4318: PO_DEBUG.debug_exc(l_log_head,l_progress);
4319: END IF;

Line 4333: WHEN FND_API.G_EXC_ERROR THEN

4329: END IF;
4330: IF (c_consigned_release%ISOPEN) THEN
4331: CLOSE c_consigned_release;
4332: END IF;
4333: WHEN FND_API.G_EXC_ERROR THEN
4334: ROLLBACK TO RETRO_INVOICE_SP;
4335: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4336: p_encoded => 'F');
4337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4337: x_return_status := FND_API.G_RET_STS_ERROR;

4333: WHEN FND_API.G_EXC_ERROR THEN
4334: ROLLBACK TO RETRO_INVOICE_SP;
4335: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4336: p_encoded => 'F');
4337: x_return_status := FND_API.G_RET_STS_ERROR;
4338:
4339: IF g_debug_unexp THEN
4340: PO_DEBUG.debug_exc(l_log_head,l_progress);
4341: END IF;

Line 4367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4363: END IF;
4364:
4365: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
4366: p_encoded => 'F');
4367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4368:
4369: IF (c_stdpo%ISOPEN) THEN
4370: CLOSE c_stdpo;
4371: END IF;