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 1102: x_return_status := FND_API.G_RET_STS_SUCCESS;

1098:
1099: IF l_debug_level > 0 THEN
1100: oe_debug_pub.add( 'SUCCESSFULLY INSERTED LINE HISTORY RECORD' ) ;
1101: END IF;
1102: x_return_status := FND_API.G_RET_STS_SUCCESS;
1103: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1104: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1105: -- oe_sales_can_util.G_REQUIRE_REASON := FALSE;
1106: EXCEPTION WHEN OTHERS THEN

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

1109: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1110: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1111: oe_debug_pub.add( 'IN INNER EXCEPTION' , 5 ) ;
1112: END IF;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- nocopy analysis
1114: END;
1115: EXCEPTION
1116: -- to fix bug 2295947
1117: WHEN NO_DATA_FOUND THEN

Line 1123: x_return_status := FND_API.G_RET_STS_SUCCESS;

1119: oe_debug_pub.add( 'AUDIT HISTORY: DID NOT INSERT FOR LINE ID : '||P_LINE_ID , 1 ) ;
1120: oe_debug_pub.add( 'NO DATA FOUND ' , 1 ) ;
1121: END IF;
1122: NULL;
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;
1124: WHEN OTHERS THEN
1125: l_err_text := substr(SQLERRM,1,74);
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;

Line 1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1133: END IF;
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1136: END IF;
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: END RecordLineHist;
1139:
1140: Procedure RecordHeaderHist
1141: (p_header_id In Number

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

1164: --
1165: BEGIN
1166:
1167: if (p_header_rec.header_id is not null AND
1168: p_header_rec.header_id <> FND_API.G_MISS_NUM) then
1169: l_header_rec := p_header_rec;
1170: else
1171: -- query the header record
1172: l_header_rec := OE_HEADER_UTIL.Query_Row

Line 1610: x_return_status := FND_API.G_RET_STS_SUCCESS;

1606: l_instrument_id
1607:
1608: );
1609:
1610: x_return_status := FND_API.G_RET_STS_SUCCESS;
1611: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1612: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1613: IF l_debug_level > 0 THEN
1614: oe_debug_pub.add( 'EXITING RECORDHEADERHIST' ) ;

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1620: FND_MSG_PUB.Add_Exc_Msg
1621: (G_PKG_NAME
1622: ,'RecordHeaderHist');
1623: END IF;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625: END RecordHeaderHist;
1626:
1627: Procedure RecordHSCreditHist
1628: (p_header_scredit_id In Number

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

1652: END IF;
1653:
1654: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1655: if (p_header_scredit_rec.sales_credit_id is not null AND
1656: p_header_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then
1657: l_header_scredit_rec := p_header_scredit_rec;
1658: else
1659: -- query the header record
1660: OE_HEADER_SCREDIT_UTIL.Query_Row

Line 1761: x_return_status := FND_API.G_RET_STS_SUCCESS;

1757: p_version_number,
1758: p_reason_id
1759: --VERSIONING Changes END
1760: );
1761: x_return_status := FND_API.G_RET_STS_SUCCESS;
1762: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1763: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1764: IF l_debug_level > 0 THEN
1765: oe_debug_pub.add( 'EXITING RECORDHSCREDITHIST' ) ;

Line 1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1771: FND_MSG_PUB.Add_Exc_Msg
1772: (G_PKG_NAME
1773: ,'RecordHSCreditHist');
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: END RecordHSCreditHist;
1777:
1778: Procedure RecordLSCreditHist
1779: (p_line_scredit_id In Number

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

1801: END IF;
1802:
1803: -- JPN: Added the G_MISS_NUM check before inserting the history record.
1804: if (p_line_scredit_rec.sales_credit_id is not null AND
1805: p_line_scredit_rec.sales_credit_id <> FND_API.G_MISS_NUM) then
1806: l_line_scredit_rec := p_line_scredit_rec;
1807: else
1808: -- query the header record
1809: OE_LINE_SCREDIT_UTIL.Query_Row

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910: );
1911:
1912: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1913: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915: IF l_debug_level > 0 THEN
1916: oe_debug_pub.add( 'EXITING RECORDLSCREDITHIST' ) ;
1917: END IF;
1918:

Line 1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1922: FND_MSG_PUB.Add_Exc_Msg
1923: (G_PKG_NAME
1924: ,'RecordLSCreditHist');
1925: END IF;
1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1927: END RecordLSCreditHist;
1928:
1929: Procedure RecordHPAdjHist
1930: (p_header_adj_id In Number

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

1952: oe_debug_pub.add( 'ENTERING RECORDHPADJHIST' ) ;
1953: END IF;
1954:
1955: if (p_header_adj_rec.price_adjustment_id is not null AND
1956: p_header_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then
1957: l_header_adj_rec := p_header_adj_rec;
1958: else
1959: -- query the header record
1960: OE_HEADER_ADJ_UTIL.Query_Row

Line 2194: x_return_status := FND_API.G_RET_STS_SUCCESS;

2190: );
2191:
2192: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2193: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2194: x_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: IF l_debug_level > 0 THEN
2197: oe_debug_pub.add( 'EXITING RECORD HEADER ADJUSTMENTS HISTORY ' , 5 ) ;
2198: END IF;

Line 2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2203: FND_MSG_PUB.Add_Exc_Msg
2204: (G_PKG_NAME
2205: ,'RecordHPAdjHist');
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: END RecordHPAdjHist;
2209:
2210: Procedure RecordLPAdjHist
2211: (p_line_adj_id In Number

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

2234: END IF;
2235:
2236: -- JPN: Added the G_MISS_NUM check before inserting the history record.
2237: if (p_line_adj_rec.price_adjustment_id is not null AND
2238: p_line_adj_rec.price_adjustment_id <> FND_API.G_MISS_NUM) then
2239: l_line_adj_rec := p_line_adj_rec;
2240: else
2241: -- query the header record
2242: OE_LINE_ADJ_UTIL.Query_Row

Line 2480: x_return_status := FND_API.G_RET_STS_SUCCESS;

2476: );
2477:
2478: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
2479: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
2480: x_return_status := FND_API.G_RET_STS_SUCCESS;
2481: IF l_debug_level > 0 THEN
2482: oe_debug_pub.add( 'EXITING AFTER INSERTING LINE PRICE ADJUSTMENTS HISTORY' , 5 ) ;
2483: END IF;
2484:

Line 2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2488: FND_MSG_PUB.Add_Exc_Msg
2489: (G_PKG_NAME
2490: ,'RecordLPAdjHist');
2491: END IF;
2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2493: END RecordLPAdjHist;
2494:
2495: -- Added to fix 2964593
2496: PROCEDURE Reset_Audit_History_Flags IS