DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on FND_MESSAGE

Line 338: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

334:
335: IF l_return_status <> FND_API.g_ret_sts_success THEN
336: FND_FILE.put_line(FND_FILE.log, x_msg_data);
337: l_api_message := 'Update_eamCost returned error';
338: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
339: FND_MESSAGE.set_token('TEXT', l_api_message);
340: FND_MSG_pub.add;
341: RAISE FND_API.g_exc_error;
342: END IF;

Line 339: FND_MESSAGE.set_token('TEXT', l_api_message);

335: IF l_return_status <> FND_API.g_ret_sts_success THEN
336: FND_FILE.put_line(FND_FILE.log, x_msg_data);
337: l_api_message := 'Update_eamCost returned error';
338: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
339: FND_MESSAGE.set_token('TEXT', l_api_message);
340: FND_MSG_pub.add;
341: RAISE FND_API.g_exc_error;
342: END IF;
343:

Line 553: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

549:
550: IF l_return_status <> FND_API.g_ret_sts_success THEN
551: FND_FILE.put_line(FND_FILE.log, x_msg_data);
552: l_api_message := 'Update_eamCost returned error';
553: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
554: FND_MESSAGE.set_token('TEXT', l_api_message);
555: FND_MSG_pub.add;
556: RAISE FND_API.g_exc_error;
557: END IF;

Line 554: FND_MESSAGE.set_token('TEXT', l_api_message);

550: IF l_return_status <> FND_API.g_ret_sts_success THEN
551: FND_FILE.put_line(FND_FILE.log, x_msg_data);
552: l_api_message := 'Update_eamCost returned error';
553: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
554: FND_MESSAGE.set_token('TEXT', l_api_message);
555: FND_MSG_pub.add;
556: RAISE FND_API.g_exc_error;
557: END IF;
558:

Line 747: FND_MESSAGE.set_name('BOM', 'CST_INVALID_PARAMS');

743: p_res_seq_num is null) OR
744: (p_period_id is null AND
745: (p_period_set_name is null or
746: p_period_name is null))) THEN
747: FND_MESSAGE.set_name('BOM', 'CST_INVALID_PARAMS');
748: FND_MESSAGE.set_token('JOB', p_wip_entity_id);
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.g_exc_error;
751: END IF;

Line 748: FND_MESSAGE.set_token('JOB', p_wip_entity_id);

744: (p_period_id is null AND
745: (p_period_set_name is null or
746: p_period_name is null))) THEN
747: FND_MESSAGE.set_name('BOM', 'CST_INVALID_PARAMS');
748: FND_MESSAGE.set_token('JOB', p_wip_entity_id);
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.g_exc_error;
751: END IF;
752:

Line 768: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');

764:
765: IF l_wip_entity_type not in (6,7) THEN
766: l_api_message := 'Job is not eAM job.';
767: l_api_message := l_api_message ||'Job id: '|| TO_CHAR(p_wip_entity_id);
768: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
769: FND_MESSAGE.set_token('TEXT', l_api_message);
770: FND_MSG_PUB.ADD;
771: RAISE fnd_api.g_exc_error;
772: END IF;

Line 769: FND_MESSAGE.set_token('TEXT', l_api_message);

765: IF l_wip_entity_type not in (6,7) THEN
766: l_api_message := 'Job is not eAM job.';
767: l_api_message := l_api_message ||'Job id: '|| TO_CHAR(p_wip_entity_id);
768: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
769: FND_MESSAGE.set_token('TEXT', l_api_message);
770: FND_MSG_PUB.ADD;
771: RAISE fnd_api.g_exc_error;
772: END IF;
773:

Line 787: FND_MESSAGE.set_token('TEXT', l_api_message);

783: x_msg_count => l_msg_count,
784: x_msg_data => l_msg_data);
785:
786: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
787: FND_MESSAGE.set_token('TEXT', l_api_message);
788: FND_MSG_PUB.ADD;
789: RAISE fnd_api.g_exc_error;
790: END IF;
791:

Line 815: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

811:
812: if (l_return_status <> fnd_api.g_ret_sts_success) then
813: FND_FILE.put_line(FND_FILE.log, x_msg_data);
814: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
815: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
816: FND_MESSAGE.set_token('TEXT', l_api_message);
817: FND_MSG_pub.add;
818: raise fnd_api.g_exc_unexpected_error;
819: end if;

Line 816: FND_MESSAGE.set_token('TEXT', l_api_message);

812: if (l_return_status <> fnd_api.g_ret_sts_success) then
813: FND_FILE.put_line(FND_FILE.log, x_msg_data);
814: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
815: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
816: FND_MESSAGE.set_token('TEXT', l_api_message);
817: FND_MSG_pub.add;
818: raise fnd_api.g_exc_unexpected_error;
819: end if;
820:

Line 830: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

826: l_eam_cost_element := Get_eamCostElement(p_txn_mode,p_org_id,p_resource_id);
827:
828: IF l_eam_cost_element = 0 THEN
829: l_api_message := 'Get_eamCostElement returned error';
830: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
831: FND_MESSAGE.set_token('TEXT', l_api_message);
832: FND_MSG_pub.add;
833: RAISE FND_API.g_exc_error;
834: END IF;

Line 831: FND_MESSAGE.set_token('TEXT', l_api_message);

827:
828: IF l_eam_cost_element = 0 THEN
829: l_api_message := 'Get_eamCostElement returned error';
830: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
831: FND_MESSAGE.set_token('TEXT', l_api_message);
832: FND_MSG_pub.add;
833: RAISE FND_API.g_exc_error;
834: END IF;
835: end if; /* p_txn_mode */

Line 899: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

895:
896: IF l_return_status <> FND_API.g_ret_sts_success THEN
897: FND_FILE.put_line(FND_FILE.log, x_msg_data);
898: l_api_message := 'Get_MaintCostCat returned error';
899: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
900: FND_MESSAGE.set_token('TEXT', l_api_message);
901: FND_MSG_pub.add;
902: RAISE FND_API.g_exc_error;
903: END IF;

Line 900: FND_MESSAGE.set_token('TEXT', l_api_message);

896: IF l_return_status <> FND_API.g_ret_sts_success THEN
897: FND_FILE.put_line(FND_FILE.log, x_msg_data);
898: l_api_message := 'Get_MaintCostCat returned error';
899: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
900: FND_MESSAGE.set_token('TEXT', l_api_message);
901: FND_MSG_pub.add;
902: RAISE FND_API.g_exc_error;
903: END IF;
904:

Line 942: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

938:
939: IF l_return_status <> FND_API.g_ret_sts_success THEN
940: FND_FILE.put_line(FND_FILE.log, x_msg_data);
941: l_api_message := 'InsertUpdate_eamPerBal returned error';
942: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
943: FND_MESSAGE.set_token('TEXT', l_api_message);
944: FND_MSG_pub.add;
945: RAISE FND_API.g_exc_error;
946: END IF;

Line 943: FND_MESSAGE.set_token('TEXT', l_api_message);

939: IF l_return_status <> FND_API.g_ret_sts_success THEN
940: FND_FILE.put_line(FND_FILE.log, x_msg_data);
941: l_api_message := 'InsertUpdate_eamPerBal returned error';
942: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
943: FND_MESSAGE.set_token('TEXT', l_api_message);
944: FND_MSG_pub.add;
945: RAISE FND_API.g_exc_error;
946: END IF;
947:

Line 1169: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');

1165: (p_period_set_name is null OR
1166: p_period_name is null) THEN
1167: l_api_message := 'Must pass period id, or period set name and period name. ';
1168: l_api_message := 'Job id: ' || TO_CHAR(p_wip_entity_id);
1169: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
1170: FND_MESSAGE.set_token('TEXT', l_api_message);
1171: FND_MSG_PUB.ADD;
1172: RAISE FND_API.g_exc_error;
1173: END IF;

Line 1170: FND_MESSAGE.set_token('TEXT', l_api_message);

1166: p_period_name is null) THEN
1167: l_api_message := 'Must pass period id, or period set name and period name. ';
1168: l_api_message := 'Job id: ' || TO_CHAR(p_wip_entity_id);
1169: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
1170: FND_MESSAGE.set_token('TEXT', l_api_message);
1171: FND_MSG_PUB.ADD;
1172: RAISE FND_API.g_exc_error;
1173: END IF;
1174:

Line 3213: FND_MESSAGE.set_token('TEXT', l_api_message);

3209: x_msg_count => l_msg_count,
3210: x_msg_data => l_msg_data);
3211:
3212: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3213: FND_MESSAGE.set_token('TEXT', l_api_message);
3214: FND_MSG_PUB.ADD;
3215: RAISE fnd_api.g_exc_error;
3216: END IF;
3217:

Line 3393: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3389: l_api_message := l_api_message||' Prd Set Name: '
3390: ||l_period_set_name;
3391: l_api_message := l_api_message||' Prd Name: '
3392: ||l_period_name;
3393: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3394: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3395: FND_MSG_PUB.add;
3396:
3397: END IF;

Line 3394: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3390: ||l_period_set_name;
3391: l_api_message := l_api_message||' Prd Name: '
3392: ||l_period_name;
3393: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3394: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3395: FND_MSG_PUB.add;
3396:
3397: END IF;
3398:

Line 3430: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3426: l_api_message :=l_api_message||' Resource Type: ';
3427: l_api_message :=l_api_message||TO_CHAR(c_wor_rec.resource_type);
3428: l_api_message :=l_api_message||' WOR,Value: '||TO_CHAR(c_wor_rec.resource_value);
3429:
3430: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3431: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3432: FND_MSG_PUB.add;
3433:
3434: END IF;

Line 3431: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3427: l_api_message :=l_api_message||TO_CHAR(c_wor_rec.resource_type);
3428: l_api_message :=l_api_message||' WOR,Value: '||TO_CHAR(c_wor_rec.resource_value);
3429:
3430: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3431: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3432: FND_MSG_PUB.add;
3433:
3434: END IF;
3435:

Line 3481: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3477:
3478: l_api_message :=' MCC: ';
3479: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3480: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3481: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3482: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3483: FND_MSG_PUB.add;
3484:
3485: END IF;

Line 3482: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3478: l_api_message :=' MCC: ';
3479: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3480: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3481: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3482: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3483: FND_MSG_PUB.add;
3484:
3485: END IF;
3486:

Line 3547: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3543: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(c_wor_rec.cost_element_id) ;
3544: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_acct_id) || ',';
3545: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3546: l_api_message :=l_api_message|| ' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3547: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3548: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3549: FND_MSG_PUB.add;
3550: END IF;
3551:

Line 3548: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3544: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_acct_id) || ',';
3545: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3546: l_api_message :=l_api_message|| ' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3547: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3548: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3549: FND_MSG_PUB.add;
3550: END IF;
3551:
3552: Insert_eamBalAcct(

Line 3594: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3590: ELSE
3591:
3592: IF (p_debug = 'Y') THEN
3593: l_api_message :=' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3594: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3595: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3596: FND_MSG_PUB.add;
3597: END IF;
3598:

Line 3595: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3591:
3592: IF (p_debug = 'Y') THEN
3593: l_api_message :=' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3594: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3595: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3596: FND_MSG_PUB.add;
3597: END IF;
3598:
3599: END IF; -- if c_wor_rec.resource_value !=0

Line 3626: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3622: l_api_message :=l_api_message||' RBO,Value: '||TO_CHAR(c_rbo_rec.rbo_value);
3623: l_api_message :=l_api_message||' MCC: ';
3624: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3625: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3626: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3627: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3628: FND_MSG_PUB.add;
3629:
3630: END IF;

Line 3627: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3623: l_api_message :=l_api_message||' MCC: ';
3624: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3625: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3626: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3627: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3628: FND_MSG_PUB.add;
3629:
3630: END IF;
3631:

Line 3690: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3686: l_api_message :=l_api_message|| ' mfg_cost_element_id = 5,' ;
3687: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3688: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3689: l_api_message :=l_api_message|| ' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3690: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3691: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3692: FND_MSG_PUB.add;
3693: END IF;
3694:

Line 3691: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3687: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3688: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3689: l_api_message :=l_api_message|| ' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3690: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3691: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3692: FND_MSG_PUB.add;
3693: END IF;
3694:
3695: Insert_eamBalAcct(

Line 3737: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3733:
3734: ELSE
3735: IF (p_debug = 'Y') THEN
3736: l_api_message :=' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3737: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3738: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3739: FND_MSG_PUB.add;
3740: END IF;
3741: END IF; -- if l_sum_rbo != 0

Line 3738: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3734: ELSE
3735: IF (p_debug = 'Y') THEN
3736: l_api_message :=' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3737: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3738: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3739: FND_MSG_PUB.add;
3740: END IF;
3741: END IF; -- if l_sum_rbo != 0
3742:

Line 3816: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3812: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.operation_seq_num);
3813: l_api_message :=l_api_message||' Department Id: ';
3814: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.department_id);
3815: l_api_message :=l_api_message||' DBO,Value: '||TO_CHAR(c_dbo_rec.dbo_value);
3816: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3817: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3818: FND_MSG_PUB.add;
3819:
3820: END IF;

Line 3817: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3813: l_api_message :=l_api_message||' Department Id: ';
3814: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.department_id);
3815: l_api_message :=l_api_message||' DBO,Value: '||TO_CHAR(c_dbo_rec.dbo_value);
3816: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3817: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3818: FND_MSG_PUB.add;
3819:
3820: END IF;
3821:

Line 3864: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3860:
3861: l_api_message :=' MCC: ';
3862: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3863: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3864: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3865: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3866: FND_MSG_PUB.add;
3867:
3868: END IF;

Line 3865: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3861: l_api_message :=' MCC: ';
3862: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3863: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3864: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3865: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3866: FND_MSG_PUB.add;
3867:
3868: END IF;
3869:

Line 3922: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3918: l_api_message :=l_api_message|| ' mfg_cost_element_id = 5,' ;
3919: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3920: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3921: l_api_message :=l_api_message|| ' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3922: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3923: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3924: FND_MSG_PUB.add;
3925: END IF;
3926:

Line 3923: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3919: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3920: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3921: l_api_message :=l_api_message|| ' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3922: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3923: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3924: FND_MSG_PUB.add;
3925: END IF;
3926:
3927: Insert_eamBalAcct(

Line 3969: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3965:
3966: ELSE
3967: IF (p_debug = 'Y') THEN
3968: l_api_message :=' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3969: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3970: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3971: FND_MSG_PUB.add;
3972: END IF;
3973:

Line 3970: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3966: ELSE
3967: IF (p_debug = 'Y') THEN
3968: l_api_message :=' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3969: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3970: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3971: FND_MSG_PUB.add;
3972: END IF;
3973:
3974: END LOOP; */

Line 3994: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

3990: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.operation_seq_num);
3991: l_api_message :=l_api_message||' Department Id: ' ;
3992: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.department_id);
3993: l_api_message :=l_api_message||' WRO,Value: '||TO_CHAR(c_wro_rec.mat_value);
3994: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3995: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3996: FND_MSG_PUB.add;
3997:
3998: END IF;

Line 3995: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

3991: l_api_message :=l_api_message||' Department Id: ' ;
3992: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.department_id);
3993: l_api_message :=l_api_message||' WRO,Value: '||TO_CHAR(c_wro_rec.mat_value);
3994: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3995: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3996: FND_MSG_PUB.add;
3997:
3998: END IF;
3999:

Line 4042: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4038:
4039: l_api_message :=' MCC: ';
4040: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4041: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4042: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4043: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4044: FND_MSG_PUB.add;
4045:
4046: END IF;

Line 4043: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4039: l_api_message :=' MCC: ';
4040: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4041: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4042: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4043: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4044: FND_MSG_PUB.add;
4045:
4046: END IF;
4047:

Line 4149: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4145: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) ;
4146: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_account) || ',';
4147: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4148: l_api_message :=l_api_message|| ' Sum WRO = ' || TO_CHAR(l_value);
4149: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4150: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4151: FND_MSG_PUB.add;
4152: END IF;
4153:

Line 4150: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4146: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_account) || ',';
4147: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4148: l_api_message :=l_api_message|| ' Sum WRO = ' || TO_CHAR(l_value);
4149: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4150: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4151: FND_MSG_PUB.add;
4152: END IF;
4153:
4154: If (l_exec_flag = 1) then

Line 4196: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4192: END IF;
4193:
4194: IF (p_debug = 'Y') THEN
4195: l_api_message :=' Sum WRO = 0';
4196: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4197: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4198: FND_MSG_PUB.add;
4199: END IF;
4200: End If;

Line 4197: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4193:
4194: IF (p_debug = 'Y') THEN
4195: l_api_message :=' Sum WRO = 0';
4196: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4197: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4198: FND_MSG_PUB.add;
4199: END IF;
4200: End If;
4201: End loop; /* End For Loop for l_index_var */

Line 4288: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4284: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.operation_seq_num);
4285: l_api_message :=l_api_message||' Department Id: ' ;
4286: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.department_id);
4287: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wrodi_rec.mat_value);
4288: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4289: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4290: FND_MSG_PUB.add;
4291:
4292: END IF;

Line 4289: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4285: l_api_message :=l_api_message||' Department Id: ' ;
4286: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.department_id);
4287: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wrodi_rec.mat_value);
4288: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4289: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4290: FND_MSG_PUB.add;
4291:
4292: END IF;
4293:

Line 4334: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4330:
4331: l_api_message :=' MCC: ';
4332: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4333: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4334: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4335: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4336: FND_MSG_PUB.add;
4337:
4338: END IF;

Line 4335: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4331: l_api_message :=' MCC: ';
4332: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4333: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4334: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4335: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4336: FND_MSG_PUB.add;
4337:
4338: END IF;
4339:

Line 4403: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4399: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) || ',';
4400: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4401: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4402: l_api_message :=l_api_message|| ' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4403: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4404: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4405: FND_MSG_PUB.add;
4406: END IF;
4407:

Line 4404: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4400: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4401: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4402: l_api_message :=l_api_message|| ' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4403: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4404: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4405: FND_MSG_PUB.add;
4406: END IF;
4407:
4408: Insert_eamBalAcct(

Line 4450: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4446:
4447: ELSE
4448: IF (p_debug = 'Y') THEN
4449: l_api_message :=' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4450: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4451: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4452: FND_MSG_PUB.add;
4453: END IF;
4454:

Line 4451: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4447: ELSE
4448: IF (p_debug = 'Y') THEN
4449: l_api_message :=' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4450: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4451: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4452: FND_MSG_PUB.add;
4453: END IF;
4454:
4455: END IF; -- if c_wrodi_rec.mat_value != 0

Line 4562: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4558: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.category_id);
4559: l_api_message :=l_api_message||' Direct Item Sequence ID: ' ;
4560: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.direct_item_id);
4561: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wedi_rec.wedi_value);
4562: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4563: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4564: FND_MSG_PUB.add;
4565:
4566: END IF;

Line 4563: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4559: l_api_message :=l_api_message||' Direct Item Sequence ID: ' ;
4560: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.direct_item_id);
4561: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wedi_rec.wedi_value);
4562: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4563: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4564: FND_MSG_PUB.add;
4565:
4566: END IF;
4567:

Line 4608: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4604:
4605: l_api_message :=' MCC: ';
4606: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4607: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4608: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4609: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4610: FND_MSG_PUB.add;
4611:
4612: END IF;

Line 4609: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4605: l_api_message :=' MCC: ';
4606: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4607: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4608: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4609: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4610: FND_MSG_PUB.add;
4611:
4612: END IF;
4613:

Line 4675: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4671: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR( l_mfg_cost_element_id);
4672: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4673: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4674: l_api_message :=l_api_message|| ' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4675: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4676: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4677: FND_MSG_PUB.add;
4678: END IF;
4679:

Line 4676: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4672: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4673: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4674: l_api_message :=l_api_message|| ' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4675: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4676: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4677: FND_MSG_PUB.add;
4678: END IF;
4679:
4680: Insert_eamBalAcct(

Line 4722: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4718:
4719: Else
4720: IF (p_debug = 'Y') THEN
4721: l_api_message :=' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4722: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4723: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4724: FND_MSG_PUB.add;
4725: END IF;
4726:

Line 4723: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4719: Else
4720: IF (p_debug = 'Y') THEN
4721: l_api_message :=' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4722: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4723: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4724: FND_MSG_PUB.add;
4725: END IF;
4726:
4727: End If; -- if c_wedi_rec.wedi_value !=0

Line 4856: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4852: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_id);
4853: l_api_message :=l_api_message||' Category Date ';
4854: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_date);
4855: l_api_message :=l_api_message||' PDA,Value: '||TO_CHAR(c_pda_rec.pda_value);
4856: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4857: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4858: FND_MSG_PUB.add;
4859:
4860: END IF;

Line 4857: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4853: l_api_message :=l_api_message||' Category Date ';
4854: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_date);
4855: l_api_message :=l_api_message||' PDA,Value: '||TO_CHAR(c_pda_rec.pda_value);
4856: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4857: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4858: FND_MSG_PUB.add;
4859:
4860: END IF;
4861:

Line 4913: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4909:
4910: l_api_message :=' MCC: ';
4911: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4912: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4913: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4914: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4915: FND_MSG_PUB.add;
4916:
4917: END IF;

Line 4914: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4910: l_api_message :=' MCC: ';
4911: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4912: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4913: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4914: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4915: FND_MSG_PUB.add;
4916:
4917: END IF;
4918:

Line 4981: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

4977: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) || ',';
4978: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4979: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4980: l_api_message :=l_api_message|| ' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4981: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4982: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4983: FND_MSG_PUB.add;
4984: END IF;
4985:

Line 4982: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

4978: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4979: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4980: l_api_message :=l_api_message|| ' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4981: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4982: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4983: FND_MSG_PUB.add;
4984: END IF;
4985:
4986: Insert_eamBalAcct(

Line 5027: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

5023: END IF;
5024: Else
5025: IF (p_debug = 'Y') THEN
5026: l_api_message :=' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
5027: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
5028: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
5029: FND_MSG_PUB.add;
5030: END IF;
5031: End If; -- if c_pda_rec.pda_value != 0

Line 5028: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

5024: Else
5025: IF (p_debug = 'Y') THEN
5026: l_api_message :=' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
5027: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
5028: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
5029: FND_MSG_PUB.add;
5030: END IF;
5031: End If; -- if c_pda_rec.pda_value != 0
5032:

Line 6690: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

6686:
6687: IF l_return_status <> FND_API.g_ret_sts_success THEN
6688: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6689: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6690: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6691: FND_MESSAGE.set_token('TEXT', l_api_message);
6692: FND_MSG_pub.add;
6693: RAISE FND_API.g_exc_error;
6694: END IF;

Line 6691: FND_MESSAGE.set_token('TEXT', l_api_message);

6687: IF l_return_status <> FND_API.g_ret_sts_success THEN
6688: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6689: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6690: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6691: FND_MESSAGE.set_token('TEXT', l_api_message);
6692: FND_MSG_pub.add;
6693: RAISE FND_API.g_exc_error;
6694: END IF;
6695:

Line 7018: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

7014:
7015: if (l_return_status <> fnd_api.g_ret_sts_success) then
7016: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7017: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7018: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7019: FND_MESSAGE.set_token('TEXT', l_api_message);
7020: FND_MSG_pub.add;
7021: raise fnd_api.g_exc_unexpected_error;
7022: end if;

Line 7019: FND_MESSAGE.set_token('TEXT', l_api_message);

7015: if (l_return_status <> fnd_api.g_ret_sts_success) then
7016: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7017: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7018: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7019: FND_MESSAGE.set_token('TEXT', l_api_message);
7020: FND_MSG_pub.add;
7021: raise fnd_api.g_exc_unexpected_error;
7022: end if;
7023:

Line 7427: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

7423:
7424: if (l_return_status <> fnd_api.g_ret_sts_success) then
7425: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7426: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7427: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7428: FND_MESSAGE.set_token('TEXT', l_api_message);
7429: FND_MSG_pub.add;
7430: raise fnd_api.g_exc_unexpected_error;
7431: end if;

Line 7428: FND_MESSAGE.set_token('TEXT', l_api_message);

7424: if (l_return_status <> fnd_api.g_ret_sts_success) then
7425: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7426: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7427: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7428: FND_MESSAGE.set_token('TEXT', l_api_message);
7429: FND_MSG_pub.add;
7430: raise fnd_api.g_exc_unexpected_error;
7431: end if;
7432:

Line 7777: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

7773:
7774: if (x_return_status <> fnd_api.g_ret_sts_success) then
7775: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7776: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7777: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7778: FND_MESSAGE.set_token('TEXT', l_api_message);
7779: FND_MSG_pub.add;
7780: raise fnd_api.g_exc_unexpected_error;
7781: end if;

Line 7778: FND_MESSAGE.set_token('TEXT', l_api_message);

7774: if (x_return_status <> fnd_api.g_ret_sts_success) then
7775: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7776: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7777: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7778: FND_MESSAGE.set_token('TEXT', l_api_message);
7779: FND_MSG_pub.add;
7780: raise fnd_api.g_exc_unexpected_error;
7781: end if;
7782:

Line 8209: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

8205: -------------------------------------------------
8206: l_statement := 40;
8207: if (p_wip_entity_id is null) then
8208: l_api_message := 'Please specify a wip entity id';
8209: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8210: FND_MESSAGE.set_token('TEXT', l_api_message);
8211: FND_MSG_PUB.add;
8212:
8213: RAISE fnd_api.g_exc_error;

Line 8210: FND_MESSAGE.set_token('TEXT', l_api_message);

8206: l_statement := 40;
8207: if (p_wip_entity_id is null) then
8208: l_api_message := 'Please specify a wip entity id';
8209: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8210: FND_MESSAGE.set_token('TEXT', l_api_message);
8211: FND_MSG_PUB.add;
8212:
8213: RAISE fnd_api.g_exc_error;
8214: end if;

Line 8660: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');

8656: l_weightage_factor := 1/l_number_members;
8657:
8658: l_api_message := ' Number Members: ' ||TO_CHAR(l_number_members);
8659: l_api_message := l_api_message || ' Weightage Factor: '||TO_CHAR(l_weightage_factor);
8660: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
8661: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
8662: FND_MSG_PUB.add;
8663:
8664: -------------------------------------------------------------

Line 8661: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);

8657:
8658: l_api_message := ' Number Members: ' ||TO_CHAR(l_number_members);
8659: l_api_message := l_api_message || ' Weightage Factor: '||TO_CHAR(l_weightage_factor);
8660: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
8661: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
8662: FND_MSG_PUB.add;
8663:
8664: -------------------------------------------------------------
8665: -- Get variance amounts pl + moh, resource , osp, overhead

Line 9194: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9190: -----------------------------
9191: l_statement := 40;
9192: if (p_txn_id is null or p_mnt_or_mfg is null) then
9193: l_api_message := 'One of the IN parameter is null';
9194: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9195: FND_MESSAGE.set_token('TEXT', l_api_message);
9196: FND_MSG_PUB.add;
9197: RAISE fnd_api.g_exc_error;
9198: end if;

Line 9195: FND_MESSAGE.set_token('TEXT', l_api_message);

9191: l_statement := 40;
9192: if (p_txn_id is null or p_mnt_or_mfg is null) then
9193: l_api_message := 'One of the IN parameter is null';
9194: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9195: FND_MESSAGE.set_token('TEXT', l_api_message);
9196: FND_MSG_PUB.add;
9197: RAISE fnd_api.g_exc_error;
9198: end if;
9199:

Line 9222: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9218: where wcti.transaction_id = p_txn_id;
9219: exception
9220: when no_data_found then
9221: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
9222: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9223: FND_MESSAGE.set_token('TEXT', l_api_message);
9224: FND_MSG_PUB.add;
9225: RAISE fnd_api.g_exc_error;
9226: end;

Line 9223: FND_MESSAGE.set_token('TEXT', l_api_message);

9219: exception
9220: when no_data_found then
9221: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
9222: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9223: FND_MESSAGE.set_token('TEXT', l_api_message);
9224: FND_MSG_PUB.add;
9225: RAISE fnd_api.g_exc_error;
9226: end;
9227: ELSE -- Done to support eAM in PAC, get data from WT as WCTI contains nothing at this moment

Line 9245: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9241: where wt.transaction_id = p_txn_id;
9242: exception
9243: when no_data_found then
9244: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
9245: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9246: FND_MESSAGE.set_token('TEXT', l_api_message);
9247: FND_MSG_PUB.add;
9248: RAISE fnd_api.g_exc_error;
9249: end;

Line 9246: FND_MESSAGE.set_token('TEXT', l_api_message);

9242: exception
9243: when no_data_found then
9244: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
9245: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9246: FND_MESSAGE.set_token('TEXT', l_api_message);
9247: FND_MSG_PUB.add;
9248: RAISE fnd_api.g_exc_error;
9249: end;
9250: END IF;

Line 9265: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9261: where pha.po_header_id = l_po_header_id;
9262: else
9263: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9264: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9265: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9266: FND_MESSAGE.set_token('TEXT', l_api_message);
9267: FND_MSG_pub.add;
9268: RAISE FND_API.g_exc_error;
9269: end if;

Line 9266: FND_MESSAGE.set_token('TEXT', l_api_message);

9262: else
9263: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9264: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9265: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9266: FND_MESSAGE.set_token('TEXT', l_api_message);
9267: FND_MSG_pub.add;
9268: RAISE FND_API.g_exc_error;
9269: end if;
9270:

Line 9283: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9279: where pla.po_line_id = l_po_line_id;
9280: else
9281: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9282: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9283: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9284: FND_MESSAGE.set_token('TEXT', l_api_message);
9285: FND_MSG_pub.add;
9286: RAISE FND_API.g_exc_error;
9287: end if;

Line 9284: FND_MESSAGE.set_token('TEXT', l_api_message);

9280: else
9281: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9282: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9283: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9284: FND_MESSAGE.set_token('TEXT', l_api_message);
9285: FND_MSG_pub.add;
9286: RAISE FND_API.g_exc_error;
9287: end if;
9288:

Line 9310: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9306:
9307: Else
9308: l_api_message := 'No PO Distribution exist for transaction ID: ' || TO_CHAR(p_txn_id);
9309: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9310: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9311: FND_MESSAGE.set_token('TEXT', l_api_message);
9312: FND_MSG_pub.add;
9313: RAISE FND_API.g_exc_error;
9314: End if;

Line 9311: FND_MESSAGE.set_token('TEXT', l_api_message);

9307: Else
9308: l_api_message := 'No PO Distribution exist for transaction ID: ' || TO_CHAR(p_txn_id);
9309: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9310: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9311: FND_MESSAGE.set_token('TEXT', l_api_message);
9312: FND_MSG_pub.add;
9313: RAISE FND_API.g_exc_error;
9314: End if;
9315:

Line 9326: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9322: where transaction_id = l_rcv_txn_id;
9323: Else
9324: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9325: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9326: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9327: FND_MESSAGE.set_token('TEXT', l_api_message);
9328: FND_MSG_pub.add;
9329: RAISE FND_API.g_exc_error;
9330: End if;

Line 9327: FND_MESSAGE.set_token('TEXT', l_api_message);

9323: Else
9324: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9325: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9326: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9327: FND_MESSAGE.set_token('TEXT', l_api_message);
9328: FND_MSG_pub.add;
9329: RAISE FND_API.g_exc_error;
9330: End if;
9331:

Line 9342: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9338: where po_release_id = l_po_release_id;
9339: Else
9340: l_api_message := 'No po_release_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9341: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9342: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9343: FND_MESSAGE.set_token('TEXT', l_api_message);
9344: FND_MSG_pub.add;
9345: RAISE FND_API.g_exc_error;
9346: End if;

Line 9343: FND_MESSAGE.set_token('TEXT', l_api_message);

9339: Else
9340: l_api_message := 'No po_release_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9341: l_api_message := l_api_message || ' wip_cost_txn_interface ';
9342: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9343: FND_MESSAGE.set_token('TEXT', l_api_message);
9344: FND_MSG_pub.add;
9345: RAISE FND_API.g_exc_error;
9346: End if;
9347:

Line 9377: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9373: end;
9374: end if;
9375: elsif (l_category_id = -1) then
9376: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
9377: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9378: FND_MESSAGE.set_token('TEXT', l_api_message);
9379: FND_MSG_pub.add;
9380: RAISE FND_API.g_exc_error;
9381: else

Line 9378: FND_MESSAGE.set_token('TEXT', l_api_message);

9374: end if;
9375: elsif (l_category_id = -1) then
9376: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
9377: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9378: FND_MESSAGE.set_token('TEXT', l_api_message);
9379: FND_MSG_pub.add;
9380: RAISE FND_API.g_exc_error;
9381: else
9382: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);

Line 9384: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9380: RAISE FND_API.g_exc_error;
9381: else
9382: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
9383: l_api_message := l_api_message || ' has not been approved';
9384: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9385: FND_MESSAGE.set_token('TEXT', l_api_message);
9386: FND_MSG_pub.add;
9387: RAISE FND_API.g_exc_error;
9388: end if;

Line 9385: FND_MESSAGE.set_token('TEXT', l_api_message);

9381: else
9382: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
9383: l_api_message := l_api_message || ' has not been approved';
9384: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9385: FND_MESSAGE.set_token('TEXT', l_api_message);
9386: FND_MSG_pub.add;
9387: RAISE FND_API.g_exc_error;
9388: end if;
9389:

Line 9540: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9536: -----------------------------
9537: l_statement := 40;
9538: if (p_txn_id is null) then
9539: l_api_message := 'IN parameter is null';
9540: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9541: FND_MESSAGE.set_token('TEXT', l_api_message);
9542: FND_MSG_PUB.add;
9543: RAISE fnd_api.g_exc_error;
9544: end if;

Line 9541: FND_MESSAGE.set_token('TEXT', l_api_message);

9537: l_statement := 40;
9538: if (p_txn_id is null) then
9539: l_api_message := 'IN parameter is null';
9540: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9541: FND_MESSAGE.set_token('TEXT', l_api_message);
9542: FND_MSG_PUB.add;
9543: RAISE fnd_api.g_exc_error;
9544: end if;
9545:

Line 9565: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9561: where wt.transaction_id = p_txn_id;
9562: exception
9563: when no_data_found then
9564: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
9565: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9566: FND_MESSAGE.set_token('TEXT', l_api_message);
9567: FND_MSG_PUB.add;
9568: RAISE fnd_api.g_exc_error;
9569: end;

Line 9566: FND_MESSAGE.set_token('TEXT', l_api_message);

9562: exception
9563: when no_data_found then
9564: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
9565: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9566: FND_MESSAGE.set_token('TEXT', l_api_message);
9567: FND_MSG_PUB.add;
9568: RAISE fnd_api.g_exc_error;
9569: end;
9570:

Line 9583: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9579: where pha.po_header_id = l_po_header_id;
9580: else
9581: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9582: l_api_message := l_api_message || ' wip_transactions ';
9583: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9584: FND_MESSAGE.set_token('TEXT', l_api_message);
9585: FND_MSG_pub.add;
9586: RAISE FND_API.g_exc_error;
9587: end if;

Line 9584: FND_MESSAGE.set_token('TEXT', l_api_message);

9580: else
9581: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9582: l_api_message := l_api_message || ' wip_transactions ';
9583: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9584: FND_MESSAGE.set_token('TEXT', l_api_message);
9585: FND_MSG_pub.add;
9586: RAISE FND_API.g_exc_error;
9587: end if;
9588:

Line 9601: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9597: where pla.po_line_id = l_po_line_id;
9598: else
9599: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9600: l_api_message := l_api_message || ' wip_transactions ';
9601: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9602: FND_MESSAGE.set_token('TEXT', l_api_message);
9603: FND_MSG_pub.add;
9604: RAISE FND_API.g_exc_error;
9605: end if;

Line 9602: FND_MESSAGE.set_token('TEXT', l_api_message);

9598: else
9599: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9600: l_api_message := l_api_message || ' wip_transactions ';
9601: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9602: FND_MESSAGE.set_token('TEXT', l_api_message);
9603: FND_MSG_pub.add;
9604: RAISE FND_API.g_exc_error;
9605: end if;
9606:

Line 9642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9638: l_expenditure_type := to_char(-1);
9639: end;
9640: elsif (l_category_id = -1) then
9641: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
9642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9643: FND_MESSAGE.set_token('TEXT', l_api_message);
9644: FND_MSG_pub.add;
9645: RAISE FND_API.g_exc_error;
9646: else

Line 9643: FND_MESSAGE.set_token('TEXT', l_api_message);

9639: end;
9640: elsif (l_category_id = -1) then
9641: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
9642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9643: FND_MESSAGE.set_token('TEXT', l_api_message);
9644: FND_MSG_pub.add;
9645: RAISE FND_API.g_exc_error;
9646: else
9647: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);

Line 9649: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9645: RAISE FND_API.g_exc_error;
9646: else
9647: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
9648: l_api_message := l_api_message || ' has not been approved';
9649: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9650: FND_MESSAGE.set_token('TEXT', l_api_message);
9651: FND_MSG_pub.add;
9652: RAISE FND_API.g_exc_error;
9653: end if;

Line 9650: FND_MESSAGE.set_token('TEXT', l_api_message);

9646: else
9647: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
9648: l_api_message := l_api_message || ' has not been approved';
9649: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9650: FND_MESSAGE.set_token('TEXT', l_api_message);
9651: FND_MSG_pub.add;
9652: RAISE FND_API.g_exc_error;
9653: end if;
9654:

Line 9702: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

9698: end if;
9699: l_expenditure_type := to_char(-1);
9700: l_api_message := 'No expenditure type has been setup in the category, project prameters';
9701: l_api_message := l_api_message || ' or project organization parameters';
9702: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9703: FND_MESSAGE.set_token('TEXT', l_api_message);
9704: FND_MSG_pub.add;
9705: RAISE FND_API.g_exc_error;
9706: end;

Line 9703: FND_MESSAGE.set_token('TEXT', l_api_message);

9699: l_expenditure_type := to_char(-1);
9700: l_api_message := 'No expenditure type has been setup in the category, project prameters';
9701: l_api_message := l_api_message || ' or project organization parameters';
9702: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
9703: FND_MESSAGE.set_token('TEXT', l_api_message);
9704: FND_MSG_pub.add;
9705: RAISE FND_API.g_exc_error;
9706: end;
9707: end if;

Line 11582: FND_MESSAGE.SET_NAME( 'BOM', 'CST_ACCOUNT_UNDEFINED' );

11578: debug(x_msg_data);
11579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11580: x_acct := NULL;
11581: WHEN account_name THEN
11582: FND_MESSAGE.SET_NAME( 'BOM', 'CST_ACCOUNT_UNDEFINED' );
11583: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);
11584: FND_MSG_PUB.ADD;
11585: fnd_msg_pub.count_and_get(
11586: p_encoded => fnd_api.g_false,

Line 11583: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);

11579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11580: x_acct := NULL;
11581: WHEN account_name THEN
11582: FND_MESSAGE.SET_NAME( 'BOM', 'CST_ACCOUNT_UNDEFINED' );
11583: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);
11584: FND_MSG_PUB.ADD;
11585: fnd_msg_pub.count_and_get(
11586: p_encoded => fnd_api.g_false,
11587: p_count => x_msg_count,

Line 11599: FND_MESSAGE.SET_NAME( 'BOM' , 'CST_NO_ACCOUNT_FOUND' );

11595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11596: x_acct := NULL;
11597: debug(x_msg_data);
11598: WHEN acct_null THEN
11599: FND_MESSAGE.SET_NAME( 'BOM' , 'CST_NO_ACCOUNT_FOUND' );
11600: FND_MESSAGE.SET_TOKEN( 'ID' , p_wip_entity_id);
11601: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);
11602: FND_MSG_PUB.ADD;
11603: fnd_msg_pub.count_and_get(

Line 11600: FND_MESSAGE.SET_TOKEN( 'ID' , p_wip_entity_id);

11596: x_acct := NULL;
11597: debug(x_msg_data);
11598: WHEN acct_null THEN
11599: FND_MESSAGE.SET_NAME( 'BOM' , 'CST_NO_ACCOUNT_FOUND' );
11600: FND_MESSAGE.SET_TOKEN( 'ID' , p_wip_entity_id);
11601: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);
11602: FND_MSG_PUB.ADD;
11603: fnd_msg_pub.count_and_get(
11604: p_encoded => fnd_api.g_false,

Line 11601: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);

11597: debug(x_msg_data);
11598: WHEN acct_null THEN
11599: FND_MESSAGE.SET_NAME( 'BOM' , 'CST_NO_ACCOUNT_FOUND' );
11600: FND_MESSAGE.SET_TOKEN( 'ID' , p_wip_entity_id);
11601: FND_MESSAGE.SET_TOKEN( 'ACCOUNT', p_account_name);
11602: FND_MSG_PUB.ADD;
11603: fnd_msg_pub.count_and_get(
11604: p_encoded => fnd_api.g_false,
11605: p_count => x_msg_count,