DBA Data[Home] [Help]

APPS.QP_BULK_LOADER_PUB dependencies on QP_BULK_VALIDATE

Line 361: --Validation shifted to QP_BULK_VALIDATE package.

357: and qplh.list_header_id <> qpih.list_header_id
358: )
359: -- Should not be able to update rounding factor
360: --Bug#5208112 RAVI
361: --Validation shifted to QP_BULK_VALIDATE package.
362: /**
363: AND NOT EXISTS(
364: select 1 from qp_list_headers qplh
365: where qpih.interface_action_code = 'UPDATE'

Line 1553: QP_BULK_VALIDATE.Attribute_Header(l_request_id);

1549: QP_BULK_VALUE_TO_ID.Header(l_request_id);
1550:
1551: -- Attribute level validation for headers
1552:
1553: QP_BULK_VALIDATE.Attribute_Header(l_request_id);
1554:
1555: --setting process_status_flag
1556: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
1557: ( p_table_type=>'HEADER',

Line 1556: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

1552:
1553: QP_BULK_VALIDATE.Attribute_Header(l_request_id);
1554:
1555: --setting process_status_flag
1556: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
1557: ( p_table_type=>'HEADER',
1558: p_request_id=>l_request_id);
1559:
1560: --Value to ID conversion

Line 2008: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);

2004: --Value to ID conversion before validation
2005: QP_BULK_VALUE_TO_ID.Qualifier(l_request_id);
2006:
2007: -- Attribute level validation for Qualifier
2008: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);
2009:
2010:
2011: --setting process_status_flag
2012: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

Line 2012: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

2008: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);
2009:
2010:
2011: --setting process_status_flag
2012: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
2013: ( p_table_type=>'QUALIFIER',
2014: p_request_id=>l_request_id);
2015:
2016: --Insert Error messages into db caused by value-ID conversion

Line 3318: QP_BULK_VALIDATE.Dup_line_Check(l_request_id);

3314: QP_BULK_VALUE_TO_ID.Insert_Line_Error_Message(l_request_id);
3315:
3316: -- ENH duplicate line check flag RAVI
3317: IF G_QP_ENABLE_DUP_LINE_CHECK='Y' THEN
3318: QP_BULK_VALIDATE.Dup_line_Check(l_request_id);
3319: END IF;
3320:
3321: write_log('After duplicate Line Check');
3322:

Line 4548: QP_BULK_VALIDATE.Attribute_Line(l_request_id);

4544: and qpip.interface_action_code IN ('UPDATE','DELETE');
4545: **/
4546: -- Bug#5353889 RAVI END
4547:
4548: QP_BULK_VALIDATE.Attribute_Line(l_request_id);
4549:
4550: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4551: ( p_table_type=>'LINE',
4552: p_request_id=>l_request_id);

Line 4550: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

4546: -- Bug#5353889 RAVI END
4547:
4548: QP_BULK_VALIDATE.Attribute_Line(l_request_id);
4549:
4550: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4551: ( p_table_type=>'LINE',
4552: p_request_id=>l_request_id);
4553:
4554: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

Line 4554: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

4550: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4551: ( p_table_type=>'LINE',
4552: p_request_id=>l_request_id);
4553:
4554: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4555: ( p_table_type=>'PRICING_ATTRIBS',
4556: p_request_id=>l_request_id);
4557:
4558: Process_line(l_request_id,p_process_parent); -- 6028305

Line 4648: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_INS_HEADER_REC);

4644: write_log('Records loaded for INS:'||G_INS_HEADER_REC.orig_sys_header_ref.count);
4645:
4646: IF G_INS_HEADER_REC.orig_sys_header_ref.count>0 THEN
4647:
4648: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_INS_HEADER_REC);
4649:
4650: QP_BULK_UTIL.Insert_Header(p_header_rec=>G_INS_HEADER_REC);
4651: QP_BULK_MSG.Save_Message(p_request_id);
4652:

Line 4674: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_UDT_HEADER_REC);

4670: write_log('Records loaded for UDT:'||G_UDT_HEADER_REC.orig_sys_header_ref.count);
4671:
4672: IF G_UDT_HEADER_REC.orig_sys_header_ref.count>0 THEN
4673:
4674: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_UDT_HEADER_REC);
4675:
4676: QP_BULK_UTIL.Update_Header(p_header_rec=>G_UDT_HEADER_REC);
4677: QP_BULK_MSG.Save_Message(p_request_id);
4678:

Line 4981: QP_BULK_VALIDATE.ENTITY_QUALIFIER

4977: || G_INS_qualifier_rec.process_flag.count);
4978:
4979: IF G_INS_qualifier_rec.orig_sys_qualifier_ref.count >0 Then
4980:
4981: QP_BULK_VALIDATE.ENTITY_QUALIFIER
4982: (p_qualifier_rec=>G_INS_QUALIFIER_REC);
4983:
4984: QP_BULK_UTIL.Insert_Qualifier(p_qualifier_rec=>G_INS_QUALIFIER_REC);
4985:

Line 5132: QP_BULK_VALIDATE.ENTITY_QUALIFIER

5128: || G_UDT_qualifier_rec.process_flag.count);
5129:
5130: IF G_UDT_qualifier_rec.orig_sys_qualifier_ref.count >0 Then
5131:
5132: QP_BULK_VALIDATE.ENTITY_QUALIFIER
5133: (p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5134:
5135: QP_BULK_UTIL.Update_Qualifier(p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5136:

Line 5617: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_INS_LINE_REC);

5613: write_log('Lines Loaded for INS: '||G_INS_LINE_REC.orig_sys_line_ref.count);
5614:
5615: IF G_INS_LINE_REC.orig_sys_line_ref.count>0 THEN
5616:
5617: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_INS_LINE_REC);
5618:
5619: QP_BULK_MSG.Save_Message(p_request_id);
5620:
5621: -- 6028305

Line 5968: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_UDT_LINE_REC);

5964: IF G_UDT_LINE_REC.orig_sys_line_ref.count>0 THEN
5965:
5966: G_UDT_LINE_REC_OLD:=G_UDT_LINE_REC; -- 6028305
5967:
5968: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_UDT_LINE_REC);
5969:
5970: QP_BULK_MSG.Save_Message(p_request_id);
5971:
5972: -- 6028305

Line 6327: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_INS_PRICING_ATTR_REC);

6323: ||G_INS_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT);
6324:
6325: IF (G_INS_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT >0 ) THEN
6326:
6327: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_INS_PRICING_ATTR_REC);
6328:
6329: QP_BULK_MSG.Save_Message(p_request_id);
6330:
6331:

Line 6542: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_UDT_PRICING_ATTR_REC);

6538: ||G_UDT_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT);
6539:
6540: IF (G_UDT_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT >0 ) THEN
6541:
6542: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_UDT_PRICING_ATTR_REC);
6543:
6544: QP_BULK_MSG.Save_Message(p_request_id);
6545:
6546: -- 6028305