273: IF (l_err_code <> 0) THEN
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: /* x_msg_count := FND_MSG_PUB.Count_Msg;
276: IF x_msg_count = 1 THEN
277: PA_INTERFACE_UTILS_PUB.get_messages
278: (p_encoded => FND_API.G_TRUE,
279: p_msg_index => 1,
280: p_msg_count => 1,
281: p_msg_data => l_msg_data ,
320: ,p_owned_by_person_id => l_owned_by_person_id
321: ,p_owning_organization_id => l_owning_org_id
322: ,p_agreement_currency_code => l_agr_curr_code
323: ,p_invoice_limit_flag => l_invoice_limit_flag
324: ,p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
325: ,p_end_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
326: ,p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 5522880
327: ,p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 5522880
328: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
321: ,p_owning_organization_id => l_owning_org_id
322: ,p_agreement_currency_code => l_agr_curr_code
323: ,p_invoice_limit_flag => l_invoice_limit_flag
324: ,p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
325: ,p_end_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
326: ,p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 5522880
327: ,p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 5522880
328: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
329:
322: ,p_agreement_currency_code => l_agr_curr_code
323: ,p_invoice_limit_flag => l_invoice_limit_flag
324: ,p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
325: ,p_end_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
326: ,p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 5522880
327: ,p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 5522880
328: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
329:
330: IF l_debug_mode = 'Y' THEN
323: ,p_invoice_limit_flag => l_invoice_limit_flag
324: ,p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
325: ,p_end_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
326: ,p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 5522880
327: ,p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 5522880
328: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
329:
330: IF l_debug_mode = 'Y' THEN
331: PA_DEBUG.write_log (x_module =>
324: ,p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
325: ,p_end_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE -- Bug 5522880
326: ,p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 5522880
327: ,p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 5522880
328: ,p_amount => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM); -- Bug 5522880
329:
330: IF l_debug_mode = 'Y' THEN
331: PA_DEBUG.write_log (x_module =>
332: 'pa.plsql.pa_fp_ci_implement_pkg.create_ci_impact_fund_lines'
336: IF l_upd_agr_allowed = 'N' THEN
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: /* x_msg_count := FND_MSG_PUB.Count_Msg;
339: IF x_msg_count = 1 THEN
340: PA_INTERFACE_UTILS_PUB.get_messages
341: (p_encoded => FND_API.G_TRUE,
342: p_msg_index => 1,
343: p_msg_count => 1,
344: p_msg_data => l_msg_data ,
394: p_pm_product_code => NULL,
395: p_agreement_currency_code => l_agr_curr_code,
396: p_owning_organization_id => l_owning_org_id,
397: p_invoice_limit_flag => l_invoice_limit_flag,
398: p_customer_order_number => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 5522880
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
395: p_agreement_currency_code => l_agr_curr_code,
396: p_owning_organization_id => l_owning_org_id,
397: p_invoice_limit_flag => l_invoice_limit_flag,
398: p_customer_order_number => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 5522880
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
396: p_owning_organization_id => l_owning_org_id,
397: p_invoice_limit_flag => l_invoice_limit_flag,
398: p_customer_order_number => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 5522880
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397: p_invoice_limit_flag => l_invoice_limit_flag,
398: p_customer_order_number => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 5522880
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
398: p_customer_order_number => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 5522880
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399: p_advance_required => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400: p_start_date => PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401: p_billing_sequence => PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
402: p_line_of_account => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403: p_Attribute11 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
404: p_Attribute12 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
405: p_Attribute13 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
406: p_Attribute14 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
407: p_Attribute15 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
408: p_Attribute16 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
409: p_Attribute17 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
417: p_Attribute25 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR); -- Bug 5522880
410: p_Attribute18 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
417: p_Attribute25 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR); -- Bug 5522880
418:
411: p_Attribute19 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
417: p_Attribute25 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR); -- Bug 5522880
418:
419:
412: p_Attribute20 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
417: p_Attribute25 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR); -- Bug 5522880
418:
419:
420: END IF;
413: p_Attribute21 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
414: p_Attribute22 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
415: p_Attribute23 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
416: p_Attribute24 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
417: p_Attribute25 => PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR); -- Bug 5522880
418:
419:
420: END IF;
421:
462:
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: /* x_msg_count := FND_MSG_PUB.Count_Msg;
465: IF x_msg_count = 1 THEN
466: PA_INTERFACE_UTILS_PUB.get_messages
467: (p_encoded => FND_API.G_TRUE,
468: p_msg_index => 1,
469: p_msg_count => 1,
470: p_msg_data => l_msg_data ,
677: IF l_add_funding_ok_flag <> 'Y' THEN
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: /* x_msg_count := FND_MSG_PUB.Count_Msg;
680: IF x_msg_count = 1 THEN
681: PA_INTERFACE_UTILS_PUB.get_messages
682: (p_encoded => FND_API.G_TRUE,
683: p_msg_index => 1,
684: p_msg_count => 1,
685: p_msg_data => l_msg_data ,
771: p_msg_name => l_err_stage );
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: /* x_msg_count := FND_MSG_PUB.Count_Msg;
774: IF x_msg_count = 1 THEN
775: PA_INTERFACE_UTILS_PUB.get_messages
776: (p_encoded => FND_API.G_TRUE,
777: p_msg_index => 1,
778: p_msg_count => 1,
779: p_msg_data => l_msg_data ,