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_PREPAYMENT_PVT dependencies on OE_HOLDS_PUB

Line 1192: OE_HOLDS_PUB.Check_Holds

1188: oe_debug_pub.add( 'OEXVPPYB: IN CHECK FOR PREPAYMENT HOLD' , 3 ) ;
1189: END IF;
1190:
1191: -- Checking existense of unreleased holds on this order
1192: OE_HOLDS_PUB.Check_Holds
1193: ( p_api_version => 1.0
1194: , p_header_id => p_header_id
1195: , p_hold_id => 13
1196: , p_entity_code => 'O'

Line 1212: OE_HOLDS_PUB.Check_Holds

1208: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 13 EXISTS ON ORDER' , 3 ) ;
1209: END IF;
1210: return;
1211: ELSE
1212: OE_HOLDS_PUB.Check_Holds
1213: ( p_api_version => 1.0
1214: , p_header_id => p_header_id
1215: , p_hold_id => 14
1216: , p_entity_code => 'O'

Line 1230: OE_HOLDS_PUB.Check_Holds

1226: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 14 EXISTS ON ORDER' , 3 ) ;
1227: END IF;
1228: return;
1229: ELSE
1230: OE_HOLDS_PUB.Check_Holds
1231: ( p_api_version => 1.0
1232: , p_header_id => p_header_id
1233: , p_hold_id => 15
1234: , p_entity_code => 'O'

Line 1335: OE_Holds_PUB.Apply_Holds

1331: IF p_hold_id in (14, 15) THEN
1332: l_hold_source_rec.hold_comment := SUBSTR(p_msg_data,1,2000);
1333: END IF;
1334:
1335: OE_Holds_PUB.Apply_Holds
1336: ( p_api_version => 1.0
1337: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1338: , p_hold_source_rec => l_hold_source_rec
1339: , x_msg_count => l_msg_count

Line 1470: OE_Holds_PUB.Release_Holds

1466:
1467: l_hold_release_rec.release_reason_code := 'PREPAYMENT';
1468: l_hold_release_rec.release_comment := 'Prepayment has been processed. Hold released automatically.';
1469:
1470: OE_Holds_PUB.Release_Holds
1471: ( p_api_version => 1.0
1472: , p_hold_source_rec => l_hold_source_rec
1473: , p_hold_release_rec => l_hold_release_rec
1474: , x_msg_count => l_msg_count

Line 1514: OE_Holds_PUB.Release_Holds

1510:
1511: l_hold_release_rec.release_reason_code := 'PREPAYMENT';
1512: l_hold_release_rec.release_comment := 'Prepayment has been processed. Hold released automatically.';
1513:
1514: OE_Holds_PUB.Release_Holds
1515: ( p_api_version => 1.0
1516: , p_hold_source_rec => l_hold_source_rec
1517: , p_hold_release_rec => l_hold_release_rec
1518: , x_msg_count => l_msg_count

Line 1556: OE_Holds_PUB.Release_Holds

1552:
1553: l_hold_release_rec.release_reason_code := 'PREPAYMENT';
1554: l_hold_release_rec.release_comment := 'Prepayment has been processed. Hold released automatically.';
1555:
1556: OE_Holds_PUB.Release_Holds
1557: ( p_api_version => 1.0
1558: , p_hold_source_rec => l_hold_source_rec
1559: , p_hold_release_rec => l_hold_release_rec
1560: , x_msg_count => l_msg_count

Line 1673: OE_Holds_PUB.Release_Holds

1669: l_hold_release_rec.release_comment := 'Payment has been processed. Hold released automatically.';
1670: END IF;
1671:
1672:
1673: OE_Holds_PUB.Release_Holds
1674: ( p_api_version => 1.0
1675: , p_hold_source_rec => l_hold_source_rec
1676: , p_hold_release_rec => l_hold_release_rec
1677: , x_msg_count => l_msg_count

Line 4373: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;

4369: , p_hold_exists OUT NOCOPY VARCHAR2
4370: )
4371: IS
4372: l_hold_result VARCHAR2(30);
4373: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;
4374: l_return_status VARCHAR2(30);
4375: l_msg_count NUMBER;
4376: l_msg_data VARCHAR2(2000);
4377: --

Line 4402: OE_HOLDS_PUB.Check_Holds

4398: END IF;
4399: RETURN ;
4400: ELSE
4401: --pnpl adding checks for holds 11 and 12
4402: OE_HOLDS_PUB.Check_Holds
4403: ( p_api_version => 1.0
4404: , p_header_id => p_header_id
4405: , p_hold_id => 11 -- CC failure hold
4406: , p_entity_code => 'O'

Line 4422: OE_HOLDS_PUB.Check_Holds

4418: END IF;
4419: return;
4420:
4421: ELSE
4422: OE_HOLDS_PUB.Check_Holds
4423: ( p_api_version => 1.0
4424: , p_header_id => p_header_id
4425: , p_hold_id => 12 -- CC risk hold
4426: , p_entity_code => 'O'

Line 4441: OE_HOLDS_PUB.Check_Holds

4437: END IF;
4438: return;
4439: ELSE
4440: -- check if there exists header level pending authorization hold.
4441: OE_HOLDS_PUB.Check_Holds
4442: ( p_api_version => 1.0
4443: , p_header_id => p_header_id
4444: , p_hold_id => 16
4445: , p_entity_code => 'O'

Line 4463: OE_HOLDS_PUB.Check_Any_Line_Hold

4459: ELSE
4460: -- check if there exists line level pending authorization hold.
4461: p_hold_rec.header_id := p_header_id;
4462: p_hold_rec.hold_id := 16;
4463: OE_HOLDS_PUB.Check_Any_Line_Hold
4464: (x_hold_rec => p_hold_rec
4465: ,x_return_status => l_return_status
4466: ,x_msg_count => l_msg_count
4467: ,x_msg_data => l_msg_data

Line 4491: OE_HOLDS_PUB.Check_Holds_Line

4487:
4488: --pnpl added check for line level holds
4489: ELSE --p_line_id IS NOT NULL
4490: -- Checking existense of unreleased holds on this order line
4491: OE_HOLDS_PUB.Check_Holds_Line
4492: ( p_hdr_id => p_header_id
4493: , p_line_id => p_line_id
4494: , p_hold_id => 11 -- CC failure hold
4495: , p_entity_code => 'O'

Line 4511: OE_HOLDS_PUB.Check_Holds_Line

4507: END IF;
4508: return;
4509:
4510: ELSE
4511: OE_HOLDS_PUB.Check_Holds_Line
4512: ( p_hdr_id => p_header_id
4513: , p_line_id => p_line_id
4514: , p_hold_id => 12 -- CC risk hold
4515: , p_entity_code => 'O'

Line 4529: OE_HOLDS_PUB.Check_Holds_Line

4525: oe_debug_pub.add( 'OEXVPPYB: Credit Card Risk hold EXISTS ON ORDER LINE' , 3 ) ;
4526: END IF;
4527: return;
4528: ELSE
4529: OE_HOLDS_PUB.Check_Holds_Line
4530: ( p_hdr_id => p_header_id
4531: , p_line_id => p_line_id
4532: , p_hold_id => 16 -- pending authorization hold
4533: , p_entity_code => 'O'