DBA Data[Home] [Help]

APPS.OE_CHG_ORDER_PVT dependencies on FND_API

Line 47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

43: OE_MSG_PUB.Add_Exc_Msg
44: (G_PKG_NAME
45: , 'Start_ChangeOrderFlow'
46: );
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49: END Start_ChangeOrderFlow;
50:
51: -- This procedure is called by the Notification Window

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: THEN
207: OE_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME
209: , 'Create_ChgOrderWorkItem');
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: --oe_debug_pub.dumpdebug;
214: --oe_debug_pub.Debug_Off;

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: THEN
239: OE_MSG_PUB.Add_Exc_Msg
240: ( G_PKG_NAME
241: , 'Create_ChgOrderWorkItem');
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245:
246: END Update_User_Text;

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: THEN
266: OE_MSG_PUB.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Create_ChgOrderWorkItem');
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:
272: END Update_Order_Number;
273:

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: OE_MSG_PUB.Add_Exc_Msg
341: (G_PKG_NAME
342: , 'Generate_PLSQLDoc'
343: );
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: END Generate_PLSQLDoc;
348:

Line 384: p_line_rec.line_id <> FND_API.G_MISS_NUM) then

380: END IF;
381:
382: -- JPN: Added the G_MISS_NUM check before inserting the history record.
383: if (p_line_rec.line_id is not null AND
384: p_line_rec.line_id <> FND_API.G_MISS_NUM) then
385: l_line_id := p_line_rec.line_id;
386: l_line_rec := p_line_rec;
387: else
388: -- query the line record

Line 391: IF p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND

387: else
388: -- query the line record
389: OE_LINE_UTIL.Query_Row (p_line_id => l_line_id ,x_line_rec => l_line_rec);
390: end if;
391: IF p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
392: p_line_rec.ordered_quantity IS NOT NULL THEN
393:
394: -- bug 3443676, derive new ordered quantity from global picture
395: OE_Order_Util.Return_Glb_Ent_Index(p_entity_code => 'LINE', p_entity_id => l_line_id, x_index => l_index_id, x_result => l_result, x_return_status => x_return_status);

Line 397: IF l_result = FND_API.G_TRUE THEN

393:
394: -- bug 3443676, derive new ordered quantity from global picture
395: OE_Order_Util.Return_Glb_Ent_Index(p_entity_code => 'LINE', p_entity_id => l_line_id, x_index => l_index_id, x_result => l_result, x_return_status => x_return_status);
396:
397: IF l_result = FND_API.G_TRUE THEN
398: l_new_ordered_quantity := OE_Order_Util.G_Line_Tbl(l_index_id).ordered_quantity;
399: ELSE
400: l_new_ordered_quantity := p_line_rec.ordered_quantity;
401: END IF;

Line 1120: x_return_status := FND_API.G_RET_STS_SUCCESS;

1116:
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;
1119: END IF;
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1122: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1123: -- oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1124: EXCEPTION WHEN OTHERS THEN

Line 1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis

1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1128: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1129: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1130: END IF;
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1132: END;
1133: EXCEPTION
1134: -- to fix bug 2295947
1135: WHEN NO_DATA_FOUND THEN

Line 1141: x_return_status := FND_API.G_RET_STS_SUCCESS;

1137: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1138: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1139: END IF;
1140: NULL;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142: WHEN OTHERS THEN
1143: l_err_text := substr(SQLERRM,1,74);
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;

Line 1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1151: END IF;
1152: IF l_debug_level > 0 THEN
1153: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1154: END IF;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: END RecordLineHist;
1157:
1158: Procedure RecordHeaderHist
1159: (p_header_id In Number

Line 1186: p_header_rec.header_id <> FND_API.G_MISS_NUM) then

1182: --
1183: BEGIN
1184:
1185: if (p_header_rec.header_id is not null AND
1186: p_header_rec.header_id <> FND_API.G_MISS_NUM) then
1187: l_header_rec := p_header_rec;
1188: else
1189: -- query the header record
1190: l_header_rec := OE_HEADER_UTIL.Query_Row

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: l_instrument_id
1625:
1626: );
1627:
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1630: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1631: IF l_debug_level > 0 THEN
1632: oe_debug_pub.add( 'EXITING RECORDHEADERHIST' ) ;

Line 1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1638: FND_MSG_PUB.Add_Exc_Msg
1639: (G_PKG_NAME
1640: ,'RecordHeaderHist');
1641: END IF;
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: END RecordHeaderHist;
1644:
1645: Procedure RecordHSCreditHist
1646: (p_header_scredit_id In Number

Line 1674: p_header_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then

1670: END IF;
1671:
1672: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1673: if (p_header_scredit_rec.sales_credit_id is not null AND
1674: p_header_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then
1675: l_header_scredit_rec := p_header_scredit_rec;
1676: else
1677: -- query the header record
1678: OE_HEADER_SCREDIT_UTIL.Query_Row

Line 1779: x_return_status := FND_API.G_RET_STS_SUCCESS;

1775: p_version_number,
1776: p_reason_id
1777: --VERSIONING Changes END
1778: );
1779: x_return_status := FND_API.G_RET_STS_SUCCESS;
1780: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1781: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1782: IF l_debug_level > 0 THEN
1783: oe_debug_pub.add( 'EXITING RECORDHSCREDITHIST' ) ;

Line 1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1789: FND_MSG_PUB.Add_Exc_Msg
1790: (G_PKG_NAME
1791: ,'RecordHSCreditHist');
1792: END IF;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: END RecordHSCreditHist;
1795:
1796: Procedure RecordLSCreditHist
1797: (p_line_scredit_id In Number

Line 1823: p_line_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then

1819: END IF;
1820:
1821: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1822: if (p_line_scredit_rec.sales_credit_id is not null AND
1823: p_line_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then
1824: l_line_scredit_rec := p_line_scredit_rec;
1825: else
1826: -- query the header record
1827: OE_LINE_SCREDIT_UTIL.Query_Row

Line 1932: x_return_status := FND_API.G_RET_STS_SUCCESS;

1928: );
1929:
1930: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1931: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933: IF l_debug_level > 0 THEN
1934: oe_debug_pub.add( 'EXITING RECORDLSCREDITHIST' ) ;
1935: END IF;
1936:

Line 1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1940: FND_MSG_PUB.Add_Exc_Msg
1941: (G_PKG_NAME
1942: ,'RecordLSCreditHist');
1943: END IF;
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: END RecordLSCreditHist;
1946:
1947: Procedure RecordHPAdjHist
1948: (p_header_adj_id In Number

Line 1974: p_header_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then

1970: oe_debug_pub.add( 'ENTERING RECORDHPADJHIST' ) ;
1971: END IF;
1972:
1973: if (p_header_adj_rec.price_adjustment_id is not null AND
1974: p_header_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then
1975: l_header_adj_rec := p_header_adj_rec;
1976: else
1977: -- query the header record
1978: OE_HEADER_ADJ_UTIL.Query_Row

Line 2212: x_return_status := FND_API.G_RET_STS_SUCCESS;

2208: );
2209:
2210: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2211: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2212: x_return_status := FND_API.G_RET_STS_SUCCESS;
2213:
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'EXITING RECORD HEADER ADJUSTMENTS HISTORY ' , 5 ) ;
2216: END IF;

Line 2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2221: FND_MSG_PUB.Add_Exc_Msg
2222: (G_PKG_NAME
2223: ,'RecordHPAdjHist');
2224: END IF;
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: END RecordHPAdjHist;
2227:
2228: Procedure RecordLPAdjHist
2229: (p_line_adj_id In Number

Line 2256: p_line_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then

2252: END IF;
2253:
2254: -- JPN: Added the G_MISS_NUM check before inserting the history record.
2255: if (p_line_adj_rec.price_adjustment_id is not null AND
2256: p_line_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then
2257: l_line_adj_rec := p_line_adj_rec;
2258: else
2259: -- query the header record
2260: OE_LINE_ADJ_UTIL.Query_Row

Line 2498: x_return_status := FND_API.G_RET_STS_SUCCESS;

2494: );
2495:
2496: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2497: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2498: x_return_status := FND_API.G_RET_STS_SUCCESS;
2499: IF l_debug_level > 0 THEN
2500: oe_debug_pub.add( 'EXITING AFTER INSERTING LINE PRICE ADJUSTMENTS HISTORY' , 5 ) ;
2501: END IF;
2502:

Line 2510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2506: FND_MSG_PUB.Add_Exc_Msg
2507: (G_PKG_NAME
2508: ,'RecordLPAdjHist');
2509: END IF;
2510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2511: END RecordLPAdjHist;
2512:
2513: -- Added to fix 2964593
2514: PROCEDURE Reset_Audit_History_Flags IS