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.QP_BULK_LOADER_PUB dependencies on QP_BULK_VALIDATE

Line 473: --Validation shifted to QP_BULK_VALIDATE package.

469: and qplh.list_header_id <> qpih.list_header_id
470: )
471: -- Should not be able to update rounding factor
472: --Bug#5208112 RAVI
473: --Validation shifted to QP_BULK_VALIDATE package.
474: /**
475: AND NOT EXISTS(
476: select 1 from qp_list_headers qplh
477: where qpih.interface_action_code = 'UPDATE'

Line 1665: QP_BULK_VALIDATE.Attribute_Header(l_request_id);

1661: QP_BULK_VALUE_TO_ID.Header(l_request_id);
1662:
1663: -- Attribute level validation for headers
1664:
1665: QP_BULK_VALIDATE.Attribute_Header(l_request_id);
1666:
1667: --setting process_status_flag
1668: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
1669: ( p_table_type=>'HEADER',

Line 1668: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

1664:
1665: QP_BULK_VALIDATE.Attribute_Header(l_request_id);
1666:
1667: --setting process_status_flag
1668: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
1669: ( p_table_type=>'HEADER',
1670: p_request_id=>l_request_id);
1671:
1672: --Value to ID conversion

Line 2120: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);

2116: --Value to ID conversion before validation
2117: QP_BULK_VALUE_TO_ID.Qualifier(l_request_id);
2118:
2119: -- Attribute level validation for Qualifier
2120: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);
2121:
2122:
2123: --setting process_status_flag
2124: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

Line 2124: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

2120: QP_BULK_VALIDATE.Attribute_Qualifier(l_request_id);
2121:
2122:
2123: --setting process_status_flag
2124: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
2125: ( p_table_type=>'QUALIFIER',
2126: p_request_id=>l_request_id);
2127:
2128: --Insert Error messages into db caused by value-ID conversion

Line 2169: -- duplicate check has been moved to procedure QP_BULK_VALIDATE.ENTITY_LINE

2165: and nvl(l.process_type,' ') = nvl(p_process_type, nvl(l.process_type,' '))
2166: and l.interface_action_code IN ('INSERT','UPDATE','DELETE') )
2167: -- Bug 5208480(5208112,4188784) RAVI
2168: -- commenting code for bug 9247305 for performance reasons
2169: -- duplicate check has been moved to procedure QP_BULK_VALIDATE.ENTITY_LINE
2170: -- which will be called later on.
2171: /*AND NOT EXISTS
2172: (
2173: select 1 from qp_list_lines qpll

Line 3437: QP_BULK_VALIDATE.Dup_line_Check(l_request_id);

3433: QP_BULK_VALUE_TO_ID.Insert_Line_Error_Message(l_request_id);
3434:
3435: -- ENH duplicate line check flag RAVI
3436: IF G_QP_ENABLE_DUP_LINE_CHECK='Y' THEN
3437: QP_BULK_VALIDATE.Dup_line_Check(l_request_id);
3438: END IF;
3439:
3440: write_log('After duplicate Line Check');
3441:

Line 4667: QP_BULK_VALIDATE.Attribute_Line(l_request_id);

4663: and qpip.interface_action_code IN ('UPDATE','DELETE');
4664: **/
4665: -- Bug#5353889 RAVI END
4666:
4667: QP_BULK_VALIDATE.Attribute_Line(l_request_id);
4668:
4669: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4670: ( p_table_type=>'LINE',
4671: p_request_id=>l_request_id);

Line 4669: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

4665: -- Bug#5353889 RAVI END
4666:
4667: QP_BULK_VALIDATE.Attribute_Line(l_request_id);
4668:
4669: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4670: ( p_table_type=>'LINE',
4671: p_request_id=>l_request_id);
4672:
4673: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

Line 4673: QP_BULK_VALIDATE.Mark_Errored_Interface_Record

4669: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4670: ( p_table_type=>'LINE',
4671: p_request_id=>l_request_id);
4672:
4673: QP_BULK_VALIDATE.Mark_Errored_Interface_Record
4674: ( p_table_type=>'PRICING_ATTRIBS',
4675: p_request_id=>l_request_id);
4676:
4677: Process_line(l_request_id,p_process_parent); -- 6028305

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

4763: write_log('Records loaded for INS:'||G_INS_HEADER_REC.orig_sys_header_ref.count);
4764:
4765: IF G_INS_HEADER_REC.orig_sys_header_ref.count>0 THEN
4766:
4767: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_INS_HEADER_REC);
4768:
4769: QP_BULK_UTIL.Insert_Header(p_header_rec=>G_INS_HEADER_REC);
4770: QP_BULK_MSG.Save_Message(p_request_id);
4771:

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

4789: write_log('Records loaded for UDT:'||G_UDT_HEADER_REC.orig_sys_header_ref.count);
4790:
4791: IF G_UDT_HEADER_REC.orig_sys_header_ref.count>0 THEN
4792:
4793: QP_BULK_VALIDATE.ENTITY_HEADER(p_header_rec=>G_UDT_HEADER_REC);
4794:
4795: QP_BULK_UTIL.Update_Header(p_header_rec=>G_UDT_HEADER_REC);
4796: QP_BULK_MSG.Save_Message(p_request_id);
4797:

Line 5100: QP_BULK_VALIDATE.ENTITY_QUALIFIER

5096: || G_INS_qualifier_rec.process_flag.count);
5097:
5098: IF G_INS_qualifier_rec.orig_sys_qualifier_ref.count >0 Then
5099:
5100: QP_BULK_VALIDATE.ENTITY_QUALIFIER
5101: (p_qualifier_rec=>G_INS_QUALIFIER_REC);
5102:
5103: QP_BULK_UTIL.Insert_Qualifier(p_qualifier_rec=>G_INS_QUALIFIER_REC);
5104:

Line 5251: QP_BULK_VALIDATE.ENTITY_QUALIFIER

5247: || G_UDT_qualifier_rec.process_flag.count);
5248:
5249: IF G_UDT_qualifier_rec.orig_sys_qualifier_ref.count >0 Then
5250:
5251: QP_BULK_VALIDATE.ENTITY_QUALIFIER
5252: (p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5253:
5254: QP_BULK_UTIL.Update_Qualifier(p_qualifier_rec=>G_UDT_QUALIFIER_REC);
5255:

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

5736: IF G_UDT_LINE_REC.orig_sys_line_ref.count>0 THEN
5737:
5738: G_UDT_LINE_REC_OLD:=G_UDT_LINE_REC; -- 6028305
5739:
5740: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_UDT_LINE_REC);
5741:
5742: QP_BULK_MSG.Save_Message(p_request_id);
5743:
5744: -- 6028305

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

6010: write_log('Lines Loaded for INS: '||G_INS_LINE_REC.orig_sys_line_ref.count);
6011:
6012: IF G_INS_LINE_REC.orig_sys_line_ref.count>0 THEN
6013:
6014: QP_BULK_VALIDATE.Entity_Line(p_line_rec=>G_INS_LINE_REC);
6015:
6016: QP_BULK_MSG.Save_Message(p_request_id);
6017:
6018: -- 6028305

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

6447: ||G_INS_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT);
6448:
6449: IF (G_INS_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT >0 ) THEN
6450:
6451: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_INS_PRICING_ATTR_REC);
6452:
6453: QP_BULK_MSG.Save_Message(p_request_id);
6454:
6455:

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

6662: ||G_UDT_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT);
6663:
6664: IF (G_UDT_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF.COUNT >0 ) THEN
6665:
6666: QP_BULK_VALIDATE.Entity_pricing_attr(p_pricing_attr_rec=>G_UDT_PRICING_ATTR_REC);
6667:
6668: QP_BULK_MSG.Save_Message(p_request_id);
6669:
6670: -- 6028305