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

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: , 'Update_Row'
66: );
67: END IF;
68:
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70:
71: END Update_Row;
72:
73: -- Procedure Insert_Row

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: END IF;
188:
189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
190:
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192:
193: WHEN OTHERS THEN
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: END IF;
204:
205: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
206:
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208:
209: END Insert_Row;
210:
211: -- Procedure Delete_Row

Line 213: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM

209: END Insert_Row;
210:
211: -- Procedure Delete_Row
212: PROCEDURE Delete_Row
213: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
214: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
215: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
216: )
217: IS

Line 214: , p_header_id IN NUMBER := FND_API.G_MISS_NUM

210:
211: -- Procedure Delete_Row
212: PROCEDURE Delete_Row
213: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
214: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
215: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
216: )
217: IS
218: l_return_status VARCHAR2(30);

Line 215: , p_line_id IN NUMBER := FND_API.G_MISS_NUM

211: -- Procedure Delete_Row
212: PROCEDURE Delete_Row
213: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
214: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
215: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
216: )
217: IS
218: l_return_status VARCHAR2(30);
219:

Line 229: IF p_payment_trx_id IS NOT NULL AND p_payment_trx_id <> FND_API.G_MISS_NUM THEN

225: IF l_debug_level > 0 THEN
226: oe_debug_pub.add( 'ENTERING DELETING COMMITMENT FOR LINE: '||P_LINE_ID , 1 ) ;
227: END IF;
228:
229: IF p_payment_trx_id IS NOT NULL AND p_payment_trx_id <> FND_API.G_MISS_NUM THEN
230: DELETE FROM oe_payments
231: WHERE payment_trx_id = p_payment_trx_id;
232: END IF;
233:

Line 234: IF p_line_id IS NOT NULL AND p_line_id <> FND_API.G_MISS_NUM

230: DELETE FROM oe_payments
231: WHERE payment_trx_id = p_payment_trx_id;
232: END IF;
233:
234: IF p_line_id IS NOT NULL AND p_line_id <> FND_API.G_MISS_NUM
235: AND p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN
236: DELETE FROM oe_payments
237: WHERE line_id = p_line_id
238: AND header_id = p_header_id;

Line 235: AND p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN

231: WHERE payment_trx_id = p_payment_trx_id;
232: END IF;
233:
234: IF p_line_id IS NOT NULL AND p_line_id <> FND_API.G_MISS_NUM
235: AND p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN
236: DELETE FROM oe_payments
237: WHERE line_id = p_line_id
238: AND header_id = p_header_id;
239: END IF;

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

251: , 'Delete_Row'
252: );
253: END IF;
254:
255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
256:
257: END Delete_Row;
258:
259: -- Procedure Query_Row

Line 286: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM

282: END Query_Row;
283:
284: -- Procedure Query_Rows
285: PROCEDURE Query_Rows
286: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
287: , p_Header_id IN NUMBER := FND_API.G_MISS_NUM
288: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
289: , x_Payment_Types_Tbl IN OUT NOCOPY Payment_Types_Tbl_Type
290: , x_return_status OUT NOCOPY VARCHAR2

Line 287: , p_Header_id IN NUMBER := FND_API.G_MISS_NUM

283:
284: -- Procedure Query_Rows
285: PROCEDURE Query_Rows
286: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
287: , p_Header_id IN NUMBER := FND_API.G_MISS_NUM
288: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
289: , x_Payment_Types_Tbl IN OUT NOCOPY Payment_Types_Tbl_Type
290: , x_return_status OUT NOCOPY VARCHAR2
291:

Line 288: , p_line_id IN NUMBER := FND_API.G_MISS_NUM

284: -- Procedure Query_Rows
285: PROCEDURE Query_Rows
286: ( p_payment_trx_id IN NUMBER := FND_API.G_MISS_NUM
287: , p_Header_id IN NUMBER := FND_API.G_MISS_NUM
288: , p_line_id IN NUMBER := FND_API.G_MISS_NUM
289: , x_Payment_Types_Tbl IN OUT NOCOPY Payment_Types_Tbl_Type
290: , x_return_status OUT NOCOPY VARCHAR2
291:
292: )

Line 400: p_price_adjustment_id <> FND_API.G_MISS_NUM)

396: /***
397: IF
398: (p_price_adjustment_id IS NOT NULL
399: AND
400: p_price_adjustment_id <> FND_API.G_MISS_NUM)
401: AND
402: (p_line_id IS NOT NULL
403: AND
404: p_line_id <> FND_API.G_MISS_NUM)

Line 404: p_line_id <> FND_API.G_MISS_NUM)

400: p_price_adjustment_id <> FND_API.G_MISS_NUM)
401: AND
402: (p_line_id IS NOT NULL
403: AND
404: p_line_id <> FND_API.G_MISS_NUM)
405: THEN
406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', line_id = '|| p_line_id
412: );
413: END IF;
414:
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416:
417: END IF;
418: ***/
419:

Line 469: x_payment_types_tbl(l_count).db_flag := FND_API.G_TRUE;

465: x_payment_types_tbl(l_count).attribute15 := l_implicit_rec.ATTRIBUTE15;
466: x_payment_types_tbl(l_count).payment_amount := l_implicit_rec.payment_amount;
467:
468: -- set values for non-DB fields
469: x_payment_types_tbl(l_count).db_flag := FND_API.G_TRUE;
470: x_payment_types_tbl(l_count).operation := FND_API.G_MISS_CHAR;
471: x_payment_types_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
472:
473: l_count := l_count + 1;

Line 470: x_payment_types_tbl(l_count).operation := FND_API.G_MISS_CHAR;

466: x_payment_types_tbl(l_count).payment_amount := l_implicit_rec.payment_amount;
467:
468: -- set values for non-DB fields
469: x_payment_types_tbl(l_count).db_flag := FND_API.G_TRUE;
470: x_payment_types_tbl(l_count).operation := FND_API.G_MISS_CHAR;
471: x_payment_types_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
472:
473: l_count := l_count + 1;
474:

Line 471: x_payment_types_tbl(l_count).return_status := FND_API.G_MISS_CHAR;

467:
468: -- set values for non-DB fields
469: x_payment_types_tbl(l_count).db_flag := FND_API.G_TRUE;
470: x_payment_types_tbl(l_count).operation := FND_API.G_MISS_CHAR;
471: x_payment_types_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
472:
473: l_count := l_count + 1;
474:
475: END LOOP;

Line 483: p_payment_id <> FND_API.G_MISS_NUM)

479: /***
480: IF
481: (p_payment_id IS NOT NULL
482: AND
483: p_payment_id <> FND_API.G_MISS_NUM)
484: AND
485: (x_payment_types_tbl.COUNT = 0)
486: THEN
487: RAISE NO_DATA_FOUND;

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492: -- Return fetched table
493:
494: EXCEPTION
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
499: END IF;
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
499: END IF;
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501:
502: WHEN OTHERS THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: , 'Query_Rows'
511: );
512: END IF;
513:
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515:
516: END Query_Rows;
517:
518: -- get the balance of applied commitment