DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_PVT dependencies on OE_HOLDS_PUB

Line 1230: OE_HOLDS_PUB.Check_Holds

1226: oe_debug_pub.add( 'OEXVPPYB: IN CHECK FOR PREPAYMENT HOLD' , 3 ) ;
1227: END IF;
1228:
1229: -- Checking existense of unreleased holds on this order
1230: OE_HOLDS_PUB.Check_Holds
1231: ( p_api_version => 1.0
1232: , p_header_id => p_header_id
1233: , p_hold_id => 13
1234: , p_entity_code => 'O'

Line 1250: OE_HOLDS_PUB.Check_Holds

1246: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 13 EXISTS ON ORDER' , 3 ) ;
1247: END IF;
1248: return;
1249: ELSE
1250: OE_HOLDS_PUB.Check_Holds
1251: ( p_api_version => 1.0
1252: , p_header_id => p_header_id
1253: , p_hold_id => 14
1254: , p_entity_code => 'O'

Line 1268: OE_HOLDS_PUB.Check_Holds

1264: oe_debug_pub.add( 'OEXVPPYB: PREPAYMENT HOLD 14 EXISTS ON ORDER' , 3 ) ;
1265: END IF;
1266: return;
1267: ELSE
1268: OE_HOLDS_PUB.Check_Holds
1269: ( p_api_version => 1.0
1270: , p_header_id => p_header_id
1271: , p_hold_id => 15
1272: , p_entity_code => 'O'

Line 1373: OE_Holds_PUB.Apply_Holds

1369: IF p_hold_id in (14, 15) THEN
1370: l_hold_source_rec.hold_comment := SUBSTR(p_msg_data,1,2000);
1371: END IF;
1372:
1373: OE_Holds_PUB.Apply_Holds
1374: ( p_api_version => 1.0
1375: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1376: , p_hold_source_rec => l_hold_source_rec
1377: , x_msg_count => l_msg_count

Line 1509: OE_Holds_PUB.Release_Holds

1505:
1506: l_hold_release_rec.release_reason_code := 'PREPAYMENT';
1507: l_hold_release_rec.release_comment := 'Prepayment has been processed. Hold released automatically.';
1508:
1509: OE_Holds_PUB.Release_Holds
1510: ( p_api_version => 1.0
1511: , p_hold_source_rec => l_hold_source_rec
1512: , p_hold_release_rec => l_hold_release_rec
1513: , x_msg_count => l_msg_count

Line 1553: OE_Holds_PUB.Release_Holds

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

Line 1595: OE_Holds_PUB.Release_Holds

1591:
1592: l_hold_release_rec.release_reason_code := 'PREPAYMENT';
1593: l_hold_release_rec.release_comment := 'Prepayment has been processed. Hold released automatically.';
1594:
1595: OE_Holds_PUB.Release_Holds
1596: ( p_api_version => 1.0
1597: , p_hold_source_rec => l_hold_source_rec
1598: , p_hold_release_rec => l_hold_release_rec
1599: , x_msg_count => l_msg_count

Line 1716: OE_Holds_PUB.Release_Holds

1712: l_hold_release_rec.release_comment := 'Payment has been processed. Hold released automatically.';
1713: END IF;
1714:
1715:
1716: OE_Holds_PUB.Release_Holds
1717: ( p_api_version => 1.0
1718: , p_hold_source_rec => l_hold_source_rec
1719: , p_hold_release_rec => l_hold_release_rec
1720: , x_msg_count => l_msg_count

Line 4507: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;

4503: , p_hold_exists OUT NOCOPY VARCHAR2
4504: )
4505: IS
4506: l_hold_result VARCHAR2(30);
4507: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;
4508: l_return_status VARCHAR2(30);
4509: l_msg_count NUMBER;
4510: l_msg_data VARCHAR2(2000);
4511: --

Line 4536: OE_HOLDS_PUB.Check_Holds

4532: END IF;
4533: RETURN ;
4534: ELSE
4535: --pnpl adding checks for holds 11 and 12
4536: OE_HOLDS_PUB.Check_Holds
4537: ( p_api_version => 1.0
4538: , p_header_id => p_header_id
4539: , p_hold_id => 11 -- CC failure hold
4540: , p_entity_code => 'O'

Line 4556: OE_HOLDS_PUB.Check_Holds

4552: END IF;
4553: return;
4554:
4555: ELSE
4556: OE_HOLDS_PUB.Check_Holds
4557: ( p_api_version => 1.0
4558: , p_header_id => p_header_id
4559: , p_hold_id => 12 -- CC risk hold
4560: , p_entity_code => 'O'

Line 4575: OE_HOLDS_PUB.Check_Holds

4571: END IF;
4572: return;
4573: ELSE
4574: -- check if there exists header level pending authorization hold.
4575: OE_HOLDS_PUB.Check_Holds
4576: ( p_api_version => 1.0
4577: , p_header_id => p_header_id
4578: , p_hold_id => 16
4579: , p_entity_code => 'O'

Line 4597: OE_HOLDS_PUB.Check_Any_Line_Hold

4593: ELSE
4594: -- check if there exists line level pending authorization hold.
4595: p_hold_rec.header_id := p_header_id;
4596: p_hold_rec.hold_id := 16;
4597: OE_HOLDS_PUB.Check_Any_Line_Hold
4598: (x_hold_rec => p_hold_rec
4599: ,x_return_status => l_return_status
4600: ,x_msg_count => l_msg_count
4601: ,x_msg_data => l_msg_data

Line 4625: OE_HOLDS_PUB.Check_Holds_Line

4621:
4622: --pnpl added check for line level holds
4623: ELSE --p_line_id IS NOT NULL
4624: -- Checking existense of unreleased holds on this order line
4625: OE_HOLDS_PUB.Check_Holds_Line
4626: ( p_hdr_id => p_header_id
4627: , p_line_id => p_line_id
4628: , p_hold_id => 11 -- CC failure hold
4629: , p_entity_code => 'O'

Line 4645: OE_HOLDS_PUB.Check_Holds_Line

4641: END IF;
4642: return;
4643:
4644: ELSE
4645: OE_HOLDS_PUB.Check_Holds_Line
4646: ( p_hdr_id => p_header_id
4647: , p_line_id => p_line_id
4648: , p_hold_id => 12 -- CC risk hold
4649: , p_entity_code => 'O'

Line 4663: OE_HOLDS_PUB.Check_Holds_Line

4659: oe_debug_pub.add( 'OEXVPPYB: Credit Card Risk hold EXISTS ON ORDER LINE' , 3 ) ;
4660: END IF;
4661: return;
4662: ELSE
4663: OE_HOLDS_PUB.Check_Holds_Line
4664: ( p_hdr_id => p_header_id
4665: , p_line_id => p_line_id
4666: , p_hold_id => 16 -- pending authorization hold
4667: , p_entity_code => 'O'