[Home] [Help]
3791: p_sequence + ROWNUM,
3792: substr(g_linemsg||g_delim||PRL.line_num||g_delim||l_textline,1,240),
3793: 'PO_SUB_REQ_RATE_NULL'
3794: FROM PO_REQ_LINES_GT PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
3795: GL_SETS_OF_BOOKS SOB
3796: WHERE PRL.requisition_header_id = p_document_id AND
3797: nvl(PRL.cancel_flag, 'N') = 'N' AND
3798: nvl(PRL.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
3799: SOB.set_of_books_id = FSP.set_of_books_id AND
4695: ||l_textline,1,240),
4696: 'PO_SUB_REL_RATE_NULL'
4697: FROM PO_DISTRIBUTIONS_GT POD, --
4698: PO_LINE_LOCATIONS_GT POLL,PO_LINES POL,
4699: PO_RELEASES_GT POR,PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,
4700: FINANCIALS_SYSTEM_PARAMETERS FSP
4701: WHERE POLL.po_release_id = POR.po_release_id
4702: AND POD.line_location_id = POLL.line_location_id
4703: AND POLL.po_line_id = POL.po_line_id
6291: BEGIN
6292: SELECT FND.currency_code, nvl(FND.extended_precision,5)
6293: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
6294: FROM fnd_currencies FND, financials_system_parameters FSP,
6295: gl_sets_of_books SOB
6296: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6297: AND SOB.currency_code = FND.currency_code;
6298: EXCEPTION
6299: WHEN OTHERS THEN
6377: WHERE NOT EXISTS
6378: (SELECT DISTINCT 1
6379: FROM PO_REQUISITION_LINES_ALL PRL,
6380: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
6381: GL_SETS_OF_BOOKS SOB
6382: WHERE PRL.LINE_LOCATION_ID = l_line_location_id(shipment_line)
6383: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
6384: AND FSP.ORG_ID = PRL.ORG_ID
6385: AND NVL(PRL.CURRENCY_CODE,SOB.CURRENCY_CODE) <> l_po_curr)
6586: IF l_req_ou_func_curr IS NULL THEN
6587: BEGIN
6588: SELECT SOB.currency_code
6589: INTO l_req_ou_func_curr
6590: FROM financials_system_params_all FSP, gl_sets_of_books SOB
6591: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6592: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
6593: EXCEPTION
6594: WHEN OTHERS THEN
6948: IF l_req_ou_func_curr IS NULL THEN
6949: BEGIN
6950: SELECT SOB.currency_code
6951: INTO l_req_ou_func_curr
6952: FROM financials_system_params_all FSP, gl_sets_of_books SOB
6953: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6954: AND NVL(FSP.org_id, -99) = NVL(l_requesting_org_id(req_line),-99);
6955: EXCEPTION
6956: WHEN OTHERS THEN
7241: l_rate,
7242: l_rate_date,
7243: l_acceptance_required
7244: FROM PO_HEADERS_GT POH,
7245: GL_SETS_OF_BOOKS SOB,
7246: FINANCIALS_SYSTEM_PARAMETERS FSP
7247: WHERE POH.po_header_id = p_document_id
7248: AND SOB.set_of_books_id = FSP.set_of_books_id;
7249: EXCEPTION
8519: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8520: ||l_textline,1,240),
8521: 'PO_SUB_DIST_RATE_NULL'
8522: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8523: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8524: WHERE POD.po_header_id = POH.po_header_id
8525: AND POD.line_location_id = PLL.line_location_id
8526: AND PLL.po_line_id = POL.po_line_id
8527: AND POH.po_header_id = p_document_id
8578: ||g_distmsg||g_delim||POD.distribution_num||g_delim
8579: ||l_textline,1,240),
8580: 'PO_SUB_DIST_RATE_NOT_NULL'
8581: FROM PO_DISTRIBUTIONS_GT POD,PO_LINE_LOCATIONS_GT PLL,PO_LINES_GT POL,
8582: PO_HEADERS_GT POH,GL_SETS_OF_BOOKS SOB,FINANCIALS_SYSTEM_PARAMETERS FSP
8583: WHERE POD.po_header_id = POH.po_header_id
8584: AND POD.line_location_id = PLL.line_location_id
8585: AND PLL.po_line_id = POL.po_line_id
8586: AND POH.po_header_id = p_document_id
23663: Nvl2( PRD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID','PO_CHARGE_NOT_NULL' )
23664: FROM
23665: po_req_distributions_gt PRD,
23666: po_req_lines_gt PRL,
23667: gl_sets_of_books sob
23668: WHERE
23669: PRD.requisition_line_id = PRL.requisition_line_id
23670: AND PRL.requisition_header_id = p_document_id
23671: AND sob.set_of_books_id = prd.set_of_books_id
23720: Nvl2( prd.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
23721: FROM
23722: po_req_distributions_gt PRD,
23723: po_req_lines_gt PRL,
23724: gl_sets_of_books sob
23725: WHERE
23726: PRD.requisition_line_id = PRL.requisition_line_id
23727: AND PRL.requisition_header_id = p_document_id
23728: AND sob.set_of_books_id = prd.set_of_books_id
23777: Nvl2( prd.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
23778: FROM
23779: po_req_distributions_gt PRD,
23780: po_req_lines_gt PRL,
23781: gl_sets_of_books sob
23782: WHERE
23783: PRD.requisition_line_id = PRL.requisition_line_id
23784: AND PRL.requisition_header_id = p_document_id
23785: AND sob.set_of_books_id = prd.set_of_books_id
23833: Nvl2( prd.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
23834: FROM
23835: po_req_distributions_gt PRD,
23836: po_req_lines_gt PRL,
23837: gl_sets_of_books sob
23838: WHERE
23839: PRD.requisition_line_id = PRL.requisition_line_id
23840: AND PRL.requisition_header_id = p_document_id
23841: AND sob.set_of_books_id = prd.set_of_books_id
23899: ),
23900: Nvl2( PoD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID', 'PO_CHARGE_NOT_NULL' )
23901: FROM
23902: PO_DISTRIBUTIONS_GT POD,
23903: gl_sets_of_books sob,
23904: PO_LINE_LOCATIONS_GT POLL
23905: WHERE
23906: POD.PO_RELEASE_ID = P_DOCUMENT_ID
23907: AND POD.line_location_id = POLL.line_location_id
23959: ),
23960: Nvl2( PoD.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
23961: FROM
23962: PO_DISTRIBUTIONS_GT POD,
23963: gl_sets_of_books sob,
23964: PO_LINE_LOCATIONS_GT POLL
23965: WHERE
23966: POD.PO_RELEASE_ID = P_DOCUMENT_ID
23967: AND POD.line_location_id = POLL.line_location_id
24019: ),
24020: Nvl2( PoD.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
24021: FROM
24022: PO_DISTRIBUTIONS_GT POD,
24023: gl_sets_of_books sob,
24024: PO_LINE_LOCATIONS_GT POLL
24025: WHERE
24026: POD.PO_RELEASE_ID = P_DOCUMENT_ID
24027: AND POD.line_location_id = POLL.line_location_id
24077: ),
24078: Nvl2( PoD.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
24079: FROM
24080: PO_DISTRIBUTIONS_GT POD,
24081: gl_sets_of_books sob,
24082: PO_LINE_LOCATIONS_GT POLL
24083: WHERE
24084: POD.PO_RELEASE_ID = P_DOCUMENT_ID
24085: AND POD.line_location_id = POLL.line_location_id
24146: ),
24147: Nvl2( PoD.code_combination_id, 'PO_RI_INVALID_CHARGE_ACC_ID', 'PO_CHARGE_NOT_NULL' )
24148: FROM
24149: PO_DISTRIBUTIONS_GT POD,
24150: gl_sets_of_books sob,
24151: PO_LINE_LOCATIONS_GT POLL,
24152: PO_LINES_GT POL
24153: WHERE
24154: POD.PO_HEADER_ID = P_DOCUMENT_ID
24209: ),
24210: Nvl2( PoD.budget_account_id, 'PO_RI_INVALID_BUDGET_ACC_ID', 'PO_BUDGET_NOT_NULL' )
24211: FROM
24212: PO_DISTRIBUTIONS_GT POD,
24213: gl_sets_of_books sob,
24214: PO_LINE_LOCATIONS_GT POLL,
24215: PO_LINES_GT POL
24216: WHERE
24217: POD.PO_HEADER_ID = P_DOCUMENT_ID
24276: ),
24277: Nvl2( PoD.accrual_account_id, 'PO_RI_INVALID_ACCRUAL_ACC_ID', 'PO_ACCRUAL_NOT_NULL' )
24278: FROM
24279: PO_DISTRIBUTIONS_GT POD,
24280: gl_sets_of_books sob,
24281: PO_LINE_LOCATIONS_GT POLL,
24282: PO_LINES_GT POL
24283: WHERE
24284: POD.PO_HEADER_ID = P_DOCUMENT_ID
24338: ),
24339: Nvl2( PoD.variance_account_id, 'PO_RI_INVALID_VARIANCE_ACC_ID', 'PO_VARIANCE_NOT_NULL' )
24340: FROM
24341: PO_DISTRIBUTIONS_GT POD,
24342: gl_sets_of_books sob,
24343: PO_LINE_LOCATIONS_GT POLL,
24344: PO_LINES_GT POL
24345: WHERE
24346: POD.PO_HEADER_ID = P_DOCUMENT_ID