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.CST_EAMCOST_PUB dependencies on FND_MESSAGE

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

133:
134: IF l_return_status <> FND_API.g_ret_sts_success THEN
135: FND_FILE.put_line(FND_FILE.log, x_msg_data);
136: l_api_message := 'Update_eamCost returned error';
137: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
138: FND_MESSAGE.set_token('TEXT', l_api_message);
139: FND_MSG_pub.add;
140: RAISE FND_API.g_exc_error;
141: END IF;

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

134: IF l_return_status <> FND_API.g_ret_sts_success THEN
135: FND_FILE.put_line(FND_FILE.log, x_msg_data);
136: l_api_message := 'Update_eamCost returned error';
137: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
138: FND_MESSAGE.set_token('TEXT', l_api_message);
139: FND_MSG_pub.add;
140: RAISE FND_API.g_exc_error;
141: END IF;
142:

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

348:
349: IF l_return_status <> FND_API.g_ret_sts_success THEN
350: FND_FILE.put_line(FND_FILE.log, x_msg_data);
351: l_api_message := 'Update_eamCost returned error';
352: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
353: FND_MESSAGE.set_token('TEXT', l_api_message);
354: FND_MSG_pub.add;
355: RAISE FND_API.g_exc_error;
356: END IF;

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

349: IF l_return_status <> FND_API.g_ret_sts_success THEN
350: FND_FILE.put_line(FND_FILE.log, x_msg_data);
351: l_api_message := 'Update_eamCost returned error';
352: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
353: FND_MESSAGE.set_token('TEXT', l_api_message);
354: FND_MSG_pub.add;
355: RAISE FND_API.g_exc_error;
356: END IF;
357:

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

541: p_res_seq_num is null) OR
542: (p_period_id is null AND
543: (p_period_set_name is null or
544: p_period_name is null))) THEN
545: FND_MESSAGE.set_name('BOM', 'CST_INVALID_PARAMS');
546: FND_MESSAGE.set_token('JOB', p_wip_entity_id);
547: FND_MSG_PUB.ADD;
548: RAISE FND_API.g_exc_error;
549: END IF;

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

542: (p_period_id is null AND
543: (p_period_set_name is null or
544: p_period_name is null))) THEN
545: FND_MESSAGE.set_name('BOM', 'CST_INVALID_PARAMS');
546: FND_MESSAGE.set_token('JOB', p_wip_entity_id);
547: FND_MSG_PUB.ADD;
548: RAISE FND_API.g_exc_error;
549: END IF;
550:

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

562:
563: IF l_wip_entity_type not in (6,7) THEN
564: l_api_message := 'Job is not eAM job.';
565: l_api_message := l_api_message ||'Job id: '|| TO_CHAR(p_wip_entity_id);
566: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
567: FND_MESSAGE.set_token('TEXT', l_api_message);
568: FND_MSG_PUB.ADD;
569: RAISE fnd_api.g_exc_error;
570: END IF;

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

563: IF l_wip_entity_type not in (6,7) THEN
564: l_api_message := 'Job is not eAM job.';
565: l_api_message := l_api_message ||'Job id: '|| TO_CHAR(p_wip_entity_id);
566: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
567: FND_MESSAGE.set_token('TEXT', l_api_message);
568: FND_MSG_PUB.ADD;
569: RAISE fnd_api.g_exc_error;
570: END IF;
571:

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

581: x_msg_count => l_msg_count,
582: x_msg_data => l_msg_data);
583:
584: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
585: FND_MESSAGE.set_token('TEXT', l_api_message);
586: FND_MSG_PUB.ADD;
587: RAISE fnd_api.g_exc_error;
588: END IF;
589:

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

609:
610: if (l_return_status <> fnd_api.g_ret_sts_success) then
611: FND_FILE.put_line(FND_FILE.log, x_msg_data);
612: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
613: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
614: FND_MESSAGE.set_token('TEXT', l_api_message);
615: FND_MSG_pub.add;
616: raise fnd_api.g_exc_unexpected_error;
617: end if;

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

610: if (l_return_status <> fnd_api.g_ret_sts_success) then
611: FND_FILE.put_line(FND_FILE.log, x_msg_data);
612: l_api_message := 'get_CostElement_for_DirectItem returned unexpected error';
613: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
614: FND_MESSAGE.set_token('TEXT', l_api_message);
615: FND_MSG_pub.add;
616: raise fnd_api.g_exc_unexpected_error;
617: end if;
618:

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

624: l_eam_cost_element := Get_eamCostElement(p_txn_mode,p_org_id,p_resource_id);
625:
626: IF l_eam_cost_element = 0 THEN
627: l_api_message := 'Get_eamCostElement returned error';
628: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
629: FND_MESSAGE.set_token('TEXT', l_api_message);
630: FND_MSG_pub.add;
631: RAISE FND_API.g_exc_error;
632: END IF;

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

625:
626: IF l_eam_cost_element = 0 THEN
627: l_api_message := 'Get_eamCostElement returned error';
628: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
629: FND_MESSAGE.set_token('TEXT', l_api_message);
630: FND_MSG_pub.add;
631: RAISE FND_API.g_exc_error;
632: END IF;
633: end if; /* p_txn_mode */

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

673:
674: IF l_return_status <> FND_API.g_ret_sts_success THEN
675: FND_FILE.put_line(FND_FILE.log, x_msg_data);
676: l_api_message := 'Get_MaintCostCat returned error';
677: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
678: FND_MESSAGE.set_token('TEXT', l_api_message);
679: FND_MSG_pub.add;
680: RAISE FND_API.g_exc_error;
681: END IF;

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

674: IF l_return_status <> FND_API.g_ret_sts_success THEN
675: FND_FILE.put_line(FND_FILE.log, x_msg_data);
676: l_api_message := 'Get_MaintCostCat returned error';
677: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
678: FND_MESSAGE.set_token('TEXT', l_api_message);
679: FND_MSG_pub.add;
680: RAISE FND_API.g_exc_error;
681: END IF;
682:

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

716:
717: IF l_return_status <> FND_API.g_ret_sts_success THEN
718: FND_FILE.put_line(FND_FILE.log, x_msg_data);
719: l_api_message := 'InsertUpdate_eamPerBal returned error';
720: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
721: FND_MESSAGE.set_token('TEXT', l_api_message);
722: FND_MSG_pub.add;
723: RAISE FND_API.g_exc_error;
724: END IF;

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

717: IF l_return_status <> FND_API.g_ret_sts_success THEN
718: FND_FILE.put_line(FND_FILE.log, x_msg_data);
719: l_api_message := 'InsertUpdate_eamPerBal returned error';
720: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
721: FND_MESSAGE.set_token('TEXT', l_api_message);
722: FND_MSG_pub.add;
723: RAISE FND_API.g_exc_error;
724: END IF;
725:

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

943: (p_period_set_name is null OR
944: p_period_name is null) THEN
945: l_api_message := 'Must pass period id, or period set name and period name. ';
946: l_api_message := 'Job id: ' || TO_CHAR(p_wip_entity_id);
947: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
948: FND_MESSAGE.set_token('TEXT', l_api_message);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.g_exc_error;
951: END IF;

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

944: p_period_name is null) THEN
945: l_api_message := 'Must pass period id, or period set name and period name. ';
946: l_api_message := 'Job id: ' || TO_CHAR(p_wip_entity_id);
947: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
948: FND_MESSAGE.set_token('TEXT', l_api_message);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.g_exc_error;
951: END IF;
952:

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

2987: x_msg_count => l_msg_count,
2988: x_msg_data => l_msg_data);
2989:
2990: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2991: FND_MESSAGE.set_token('TEXT', l_api_message);
2992: FND_MSG_PUB.ADD;
2993: RAISE fnd_api.g_exc_error;
2994: END IF;
2995:

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

3167: l_api_message := l_api_message||' Prd Set Name: '
3168: ||l_period_set_name;
3169: l_api_message := l_api_message||' Prd Name: '
3170: ||l_period_name;
3171: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3172: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3173: FND_MSG_PUB.add;
3174:
3175: END IF;

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

3168: ||l_period_set_name;
3169: l_api_message := l_api_message||' Prd Name: '
3170: ||l_period_name;
3171: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3172: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3173: FND_MSG_PUB.add;
3174:
3175: END IF;
3176:

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

3204: l_api_message :=l_api_message||' Resource Type: ';
3205: l_api_message :=l_api_message||TO_CHAR(c_wor_rec.resource_type);
3206: l_api_message :=l_api_message||' WOR,Value: '||TO_CHAR(c_wor_rec.resource_value);
3207:
3208: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3209: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3210: FND_MSG_PUB.add;
3211:
3212: END IF;

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

3205: l_api_message :=l_api_message||TO_CHAR(c_wor_rec.resource_type);
3206: l_api_message :=l_api_message||' WOR,Value: '||TO_CHAR(c_wor_rec.resource_value);
3207:
3208: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3209: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3210: FND_MSG_PUB.add;
3211:
3212: END IF;
3213:

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

3255:
3256: l_api_message :=' MCC: ';
3257: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3258: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3259: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3260: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3261: FND_MSG_PUB.add;
3262:
3263: END IF;

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

3256: l_api_message :=' MCC: ';
3257: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3258: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3259: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3260: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3261: FND_MSG_PUB.add;
3262:
3263: END IF;
3264:

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

3321: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(c_wor_rec.cost_element_id) ;
3322: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_acct_id) || ',';
3323: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3324: l_api_message :=l_api_message|| ' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3325: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3326: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3327: FND_MSG_PUB.add;
3328: END IF;
3329:

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

3322: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_acct_id) || ',';
3323: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3324: l_api_message :=l_api_message|| ' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3325: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3326: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3327: FND_MSG_PUB.add;
3328: END IF;
3329:
3330: Insert_eamBalAcct(

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

3368: ELSE
3369:
3370: IF (p_debug = 'Y') THEN
3371: l_api_message :=' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3372: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3373: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3374: FND_MSG_PUB.add;
3375: END IF;
3376:

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

3369:
3370: IF (p_debug = 'Y') THEN
3371: l_api_message :=' Sum WOR = ' || TO_CHAR( c_wor_rec.resource_value);
3372: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3373: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3374: FND_MSG_PUB.add;
3375: END IF;
3376:
3377: END IF; -- if c_wor_rec.resource_value !=0

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

3400: l_api_message :=l_api_message||' RBO,Value: '||TO_CHAR(c_rbo_rec.rbo_value);
3401: l_api_message :=l_api_message||' MCC: ';
3402: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3403: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3404: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3405: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3406: FND_MSG_PUB.add;
3407:
3408: END IF;

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

3401: l_api_message :=l_api_message||' MCC: ';
3402: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3403: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3404: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3405: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3406: FND_MSG_PUB.add;
3407:
3408: END IF;
3409:

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

3464: l_api_message :=l_api_message|| ' mfg_cost_element_id = 5,' ;
3465: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3466: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3467: l_api_message :=l_api_message|| ' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3468: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3469: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3470: FND_MSG_PUB.add;
3471: END IF;
3472:

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

3465: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3466: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3467: l_api_message :=l_api_message|| ' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3468: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3469: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3470: FND_MSG_PUB.add;
3471: END IF;
3472:
3473: Insert_eamBalAcct(

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

3511:
3512: ELSE
3513: IF (p_debug = 'Y') THEN
3514: l_api_message :=' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3515: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3516: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3517: FND_MSG_PUB.add;
3518: END IF;
3519: END IF; -- if l_sum_rbo != 0

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

3512: ELSE
3513: IF (p_debug = 'Y') THEN
3514: l_api_message :=' Sum RBO = ' || TO_CHAR(l_sum_rbo);
3515: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3516: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3517: FND_MSG_PUB.add;
3518: END IF;
3519: END IF; -- if l_sum_rbo != 0
3520:

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

3590: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.operation_seq_num);
3591: l_api_message :=l_api_message||' Department Id: ';
3592: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.department_id);
3593: l_api_message :=l_api_message||' DBO,Value: '||TO_CHAR(c_dbo_rec.dbo_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:
3598: END IF;

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

3591: l_api_message :=l_api_message||' Department Id: ';
3592: l_api_message :=l_api_message||TO_CHAR(c_dbo_rec.department_id);
3593: l_api_message :=l_api_message||' DBO,Value: '||TO_CHAR(c_dbo_rec.dbo_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:
3598: END IF;
3599:

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

3638:
3639: l_api_message :=' MCC: ';
3640: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3641: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3642: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3643: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3644: FND_MSG_PUB.add;
3645:
3646: END IF;

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

3639: l_api_message :=' MCC: ';
3640: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3641: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3642: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3643: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3644: FND_MSG_PUB.add;
3645:
3646: END IF;
3647:

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

3696: l_api_message :=l_api_message|| ' mfg_cost_element_id = 5,' ;
3697: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3698: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3699: l_api_message :=l_api_message|| ' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3700: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3701: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3702: FND_MSG_PUB.add;
3703: END IF;
3704:

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

3697: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_overhead_account) || ',';
3698: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3699: l_api_message :=l_api_message|| ' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3700: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3701: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3702: FND_MSG_PUB.add;
3703: END IF;
3704:
3705: Insert_eamBalAcct(

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

3743:
3744: ELSE
3745: IF (p_debug = 'Y') THEN
3746: l_api_message :=' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3747: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3748: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3749: FND_MSG_PUB.add;
3750: END IF;
3751:

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

3744: ELSE
3745: IF (p_debug = 'Y') THEN
3746: l_api_message :=' Sum DBO = ' || TO_CHAR(l_sum_dbo);
3747: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3748: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3749: FND_MSG_PUB.add;
3750: END IF;
3751:
3752: END LOOP; */

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

3768: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.operation_seq_num);
3769: l_api_message :=l_api_message||' Department Id: ' ;
3770: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.department_id);
3771: l_api_message :=l_api_message||' WRO,Value: '||TO_CHAR(c_wro_rec.mat_value);
3772: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3773: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3774: FND_MSG_PUB.add;
3775:
3776: END IF;

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

3769: l_api_message :=l_api_message||' Department Id: ' ;
3770: l_api_message :=l_api_message||TO_CHAR(c_wro_rec.department_id);
3771: l_api_message :=l_api_message||' WRO,Value: '||TO_CHAR(c_wro_rec.mat_value);
3772: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3773: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3774: FND_MSG_PUB.add;
3775:
3776: END IF;
3777:

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

3816:
3817: l_api_message :=' MCC: ';
3818: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3819: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3820: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3821: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3822: FND_MSG_PUB.add;
3823:
3824: END IF;

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

3817: l_api_message :=' MCC: ';
3818: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
3819: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
3820: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3821: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3822: FND_MSG_PUB.add;
3823:
3824: END IF;
3825:

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

3923: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) ;
3924: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_account) || ',';
3925: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3926: l_api_message :=l_api_message|| ' Sum WRO = ' || TO_CHAR(l_value);
3927: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3928: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3929: FND_MSG_PUB.add;
3930: END IF;
3931:

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

3924: l_api_message :=l_api_message|| ', account_id = ' || TO_CHAR(l_account) || ',';
3925: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
3926: l_api_message :=l_api_message|| ' Sum WRO = ' || TO_CHAR(l_value);
3927: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3928: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3929: FND_MSG_PUB.add;
3930: END IF;
3931:
3932: If (l_exec_flag = 1) then

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

3970: END IF;
3971:
3972: IF (p_debug = 'Y') THEN
3973: l_api_message :=' Sum WRO = 0';
3974: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3975: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3976: FND_MSG_PUB.add;
3977: END IF;
3978: End If;

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

3971:
3972: IF (p_debug = 'Y') THEN
3973: l_api_message :=' Sum WRO = 0';
3974: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3975: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
3976: FND_MSG_PUB.add;
3977: END IF;
3978: End If;
3979: End loop; /* End For Loop for l_index_var */

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

4062: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.operation_seq_num);
4063: l_api_message :=l_api_message||' Department Id: ' ;
4064: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.department_id);
4065: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wrodi_rec.mat_value);
4066: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4067: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4068: FND_MSG_PUB.add;
4069:
4070: END IF;

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

4063: l_api_message :=l_api_message||' Department Id: ' ;
4064: l_api_message :=l_api_message||TO_CHAR(c_wrodi_rec.department_id);
4065: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wrodi_rec.mat_value);
4066: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4067: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4068: FND_MSG_PUB.add;
4069:
4070: END IF;
4071:

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

4108:
4109: l_api_message :=' MCC: ';
4110: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4111: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4112: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4113: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4114: FND_MSG_PUB.add;
4115:
4116: END IF;

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

4109: l_api_message :=' MCC: ';
4110: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4111: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4112: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4113: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4114: FND_MSG_PUB.add;
4115:
4116: END IF;
4117:

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

4177: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) || ',';
4178: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4179: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4180: l_api_message :=l_api_message|| ' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4181: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4182: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4183: FND_MSG_PUB.add;
4184: END IF;
4185:

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

4178: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4179: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4180: l_api_message :=l_api_message|| ' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4181: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4182: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4183: FND_MSG_PUB.add;
4184: END IF;
4185:
4186: Insert_eamBalAcct(

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

4224:
4225: ELSE
4226: IF (p_debug = 'Y') THEN
4227: l_api_message :=' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4228: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4229: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4230: FND_MSG_PUB.add;
4231: END IF;
4232:

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

4225: ELSE
4226: IF (p_debug = 'Y') THEN
4227: l_api_message :=' Sum WRODI = ' || TO_CHAR(c_wrodi_rec.mat_value);
4228: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4229: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4230: FND_MSG_PUB.add;
4231: END IF;
4232:
4233: END IF; -- if c_wrodi_rec.mat_value != 0

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

4336: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.category_id);
4337: l_api_message :=l_api_message||' Direct Item Sequence ID: ' ;
4338: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.direct_item_id);
4339: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wedi_rec.wedi_value);
4340: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4341: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4342: FND_MSG_PUB.add;
4343:
4344: END IF;

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

4337: l_api_message :=l_api_message||' Direct Item Sequence ID: ' ;
4338: l_api_message :=l_api_message||TO_CHAR(c_wedi_rec.direct_item_id);
4339: l_api_message :=l_api_message||' WRO Direct Items,Value: '||TO_CHAR(c_wedi_rec.wedi_value);
4340: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4341: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4342: FND_MSG_PUB.add;
4343:
4344: END IF;
4345:

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

4382:
4383: l_api_message :=' MCC: ';
4384: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4385: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4386: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4388: FND_MSG_PUB.add;
4389:
4390: END IF;

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

4383: l_api_message :=' MCC: ';
4384: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4385: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4386: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4388: FND_MSG_PUB.add;
4389:
4390: END IF;
4391:

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

4449: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR( l_mfg_cost_element_id);
4450: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4451: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4452: l_api_message :=l_api_message|| ' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4453: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4454: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4455: FND_MSG_PUB.add;
4456: END IF;
4457:

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

4450: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4451: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4452: l_api_message :=l_api_message|| ' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4453: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4454: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4455: FND_MSG_PUB.add;
4456: END IF;
4457:
4458: Insert_eamBalAcct(

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

4496:
4497: Else
4498: IF (p_debug = 'Y') THEN
4499: l_api_message :=' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4500: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4501: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4502: FND_MSG_PUB.add;
4503: END IF;
4504:

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

4497: Else
4498: IF (p_debug = 'Y') THEN
4499: l_api_message :=' Sum WEDI = ' || TO_CHAR(c_wedi_rec.wedi_value);
4500: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4501: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4502: FND_MSG_PUB.add;
4503: END IF;
4504:
4505: End If; -- if c_wedi_rec.wedi_value !=0

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

4630: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_id);
4631: l_api_message :=l_api_message||' Category Date ';
4632: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_date);
4633: l_api_message :=l_api_message||' PDA,Value: '||TO_CHAR(c_pda_rec.pda_value);
4634: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4635: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4636: FND_MSG_PUB.add;
4637:
4638: END IF;

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

4631: l_api_message :=l_api_message||' Category Date ';
4632: l_api_message :=l_api_message||TO_CHAR(c_pda_rec.category_date);
4633: l_api_message :=l_api_message||' PDA,Value: '||TO_CHAR(c_pda_rec.pda_value);
4634: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4635: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4636: FND_MSG_PUB.add;
4637:
4638: END IF;
4639:

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

4687:
4688: l_api_message :=' MCC: ';
4689: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4690: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4691: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4692: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4693: FND_MSG_PUB.add;
4694:
4695: END IF;

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

4688: l_api_message :=' MCC: ';
4689: l_api_message :=l_api_message||TO_CHAR(l_maint_cost_category);
4690: l_api_message :=l_api_message||' CE: '||TO_CHAR(l_eam_cost_element);
4691: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4692: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4693: FND_MSG_PUB.add;
4694:
4695: END IF;
4696:

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

4755: l_api_message :=l_api_message|| ' mfg_cost_element_id = ' || TO_CHAR(l_mfg_cost_element_id) || ',';
4756: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4757: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4758: l_api_message :=l_api_message|| ' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4759: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4760: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4761: FND_MSG_PUB.add;
4762: END IF;
4763:

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

4756: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_acct_id) || ',';
4757: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
4758: l_api_message :=l_api_message|| ' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4759: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4760: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4761: FND_MSG_PUB.add;
4762: END IF;
4763:
4764: Insert_eamBalAcct(

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

4801: END IF;
4802: Else
4803: IF (p_debug = 'Y') THEN
4804: l_api_message :=' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4805: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4806: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4807: FND_MSG_PUB.add;
4808: END IF;
4809: End If; -- if c_pda_rec.pda_value != 0

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

4802: Else
4803: IF (p_debug = 'Y') THEN
4804: l_api_message :=' Sum PDA = ' || TO_CHAR( c_pda_rec.pda_value);
4805: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
4806: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
4807: FND_MSG_PUB.add;
4808: END IF;
4809: End If; -- if c_pda_rec.pda_value != 0
4810:

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

6332:
6333: IF l_return_status <> FND_API.g_ret_sts_success THEN
6334: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6335: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6336: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6337: FND_MESSAGE.set_token('TEXT', l_api_message);
6338: FND_MSG_pub.add;
6339: RAISE FND_API.g_exc_error;
6340: END IF;

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

6333: IF l_return_status <> FND_API.g_ret_sts_success THEN
6334: FND_FILE.put_line(FND_FILE.log, l_msg_data);
6335: l_api_message := 'WIP_EAM_RESOURCE_TRANSACTION.WIP_EAMRCVDIRECTITEM_HOOK returned error';
6336: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6337: FND_MESSAGE.set_token('TEXT', l_api_message);
6338: FND_MSG_pub.add;
6339: RAISE FND_API.g_exc_error;
6340: END IF;
6341:

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

6606:
6607: if (l_return_status <> fnd_api.g_ret_sts_success) then
6608: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6609: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6610: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6611: FND_MESSAGE.set_token('TEXT', l_api_message);
6612: FND_MSG_pub.add;
6613: raise fnd_api.g_exc_unexpected_error;
6614: end if;

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

6607: if (l_return_status <> fnd_api.g_ret_sts_success) then
6608: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6609: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6610: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6611: FND_MESSAGE.set_token('TEXT', l_api_message);
6612: FND_MSG_pub.add;
6613: raise fnd_api.g_exc_unexpected_error;
6614: end if;
6615:

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

6979:
6980: if (l_return_status <> fnd_api.g_ret_sts_success) then
6981: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6982: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6983: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6984: FND_MESSAGE.set_token('TEXT', l_api_message);
6985: FND_MSG_pub.add;
6986: raise fnd_api.g_exc_unexpected_error;
6987: end if;

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

6980: if (l_return_status <> fnd_api.g_ret_sts_success) then
6981: FND_FILE.put_line(FND_FILE.log, x_msg_data);
6982: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
6983: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
6984: FND_MESSAGE.set_token('TEXT', l_api_message);
6985: FND_MSG_pub.add;
6986: raise fnd_api.g_exc_unexpected_error;
6987: end if;
6988:

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

7220:
7221: if (x_return_status <> fnd_api.g_ret_sts_success) then
7222: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7223: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7224: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7225: FND_MESSAGE.set_token('TEXT', l_api_message);
7226: FND_MSG_pub.add;
7227: raise fnd_api.g_exc_unexpected_error;
7228: end if;

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

7221: if (x_return_status <> fnd_api.g_ret_sts_success) then
7222: FND_FILE.put_line(FND_FILE.log, x_msg_data);
7223: l_api_message := 'get_CostEle_for_DirectItem returned unexpected error';
7224: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7225: FND_MESSAGE.set_token('TEXT', l_api_message);
7226: FND_MSG_pub.add;
7227: raise fnd_api.g_exc_unexpected_error;
7228: end if;
7229:

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

7632: -------------------------------------------------
7633: l_statement := 40;
7634: if (p_wip_entity_id is null) then
7635: l_api_message := 'Please specify a wip entity id';
7636: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7637: FND_MESSAGE.set_token('TEXT', l_api_message);
7638: FND_MSG_PUB.add;
7639:
7640: RAISE fnd_api.g_exc_error;

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

7633: l_statement := 40;
7634: if (p_wip_entity_id is null) then
7635: l_api_message := 'Please specify a wip entity id';
7636: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
7637: FND_MESSAGE.set_token('TEXT', l_api_message);
7638: FND_MSG_PUB.add;
7639:
7640: RAISE fnd_api.g_exc_error;
7641: end if;

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

8083: l_weightage_factor := 1/l_number_members;
8084:
8085: l_api_message := ' Number Members: ' ||TO_CHAR(l_number_members);
8086: l_api_message := l_api_message || ' Weightage Factor: '||TO_CHAR(l_weightage_factor);
8087: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
8088: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
8089: FND_MSG_PUB.add;
8090:
8091: -------------------------------------------------------------

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

8084:
8085: l_api_message := ' Number Members: ' ||TO_CHAR(l_number_members);
8086: l_api_message := l_api_message || ' Weightage Factor: '||TO_CHAR(l_weightage_factor);
8087: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
8088: FND_MESSAGE.SET_TOKEN ('TEXT', l_api_message);
8089: FND_MSG_PUB.add;
8090:
8091: -------------------------------------------------------------
8092: -- Get variance amounts pl + moh, resource , osp, overhead

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

8614: -----------------------------
8615: l_statement := 40;
8616: if (p_txn_id is null or p_mnt_or_mfg is null) then
8617: l_api_message := 'One of the IN parameter is null';
8618: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8619: FND_MESSAGE.set_token('TEXT', l_api_message);
8620: FND_MSG_PUB.add;
8621: RAISE fnd_api.g_exc_error;
8622: end if;

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

8615: l_statement := 40;
8616: if (p_txn_id is null or p_mnt_or_mfg is null) then
8617: l_api_message := 'One of the IN parameter is null';
8618: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8619: FND_MESSAGE.set_token('TEXT', l_api_message);
8620: FND_MSG_PUB.add;
8621: RAISE fnd_api.g_exc_error;
8622: end if;
8623:

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

8638: where wcti.transaction_id = p_txn_id;
8639: exception
8640: when no_data_found then
8641: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
8642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8643: FND_MESSAGE.set_token('TEXT', l_api_message);
8644: FND_MSG_PUB.add;
8645: RAISE fnd_api.g_exc_error;
8646: end;

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

8639: exception
8640: when no_data_found then
8641: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
8642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8643: FND_MESSAGE.set_token('TEXT', l_api_message);
8644: FND_MSG_PUB.add;
8645: RAISE fnd_api.g_exc_error;
8646: end;
8647: ELSE -- Done to support eAM in PAC, get data from WT as WCTI contains nothing at this moment

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

8657: where wt.transaction_id = p_txn_id;
8658: exception
8659: when no_data_found then
8660: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
8661: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8662: FND_MESSAGE.set_token('TEXT', l_api_message);
8663: FND_MSG_PUB.add;
8664: RAISE fnd_api.g_exc_error;
8665: end;

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

8658: exception
8659: when no_data_found then
8660: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
8661: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8662: FND_MESSAGE.set_token('TEXT', l_api_message);
8663: FND_MSG_PUB.add;
8664: RAISE fnd_api.g_exc_error;
8665: end;
8666: END IF;

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

8679: where pha.po_header_id = l_po_header_id;
8680: else
8681: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8682: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8683: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8684: FND_MESSAGE.set_token('TEXT', l_api_message);
8685: FND_MSG_pub.add;
8686: RAISE FND_API.g_exc_error;
8687: end if;

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

8680: else
8681: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8682: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8683: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8684: FND_MESSAGE.set_token('TEXT', l_api_message);
8685: FND_MSG_pub.add;
8686: RAISE FND_API.g_exc_error;
8687: end if;
8688:

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

8697: where pla.po_line_id = l_po_line_id;
8698: else
8699: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8700: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8701: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8702: FND_MESSAGE.set_token('TEXT', l_api_message);
8703: FND_MSG_pub.add;
8704: RAISE FND_API.g_exc_error;
8705: end if;

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

8698: else
8699: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8700: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8701: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8702: FND_MESSAGE.set_token('TEXT', l_api_message);
8703: FND_MSG_pub.add;
8704: RAISE FND_API.g_exc_error;
8705: end if;
8706:

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

8719: where transaction_id = l_rcv_txn_id;
8720: Else
8721: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8722: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8723: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8724: FND_MESSAGE.set_token('TEXT', l_api_message);
8725: FND_MSG_pub.add;
8726: RAISE FND_API.g_exc_error;
8727: End if;

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

8720: Else
8721: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8722: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8723: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8724: FND_MESSAGE.set_token('TEXT', l_api_message);
8725: FND_MSG_pub.add;
8726: RAISE FND_API.g_exc_error;
8727: End if;
8728:

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

8733: where po_release_id = l_po_release_id;
8734: Else
8735: l_api_message := 'No po_release_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8736: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8737: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8738: FND_MESSAGE.set_token('TEXT', l_api_message);
8739: FND_MSG_pub.add;
8740: RAISE FND_API.g_exc_error;
8741: End if;

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

8734: Else
8735: l_api_message := 'No po_release_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8736: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8737: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8738: FND_MESSAGE.set_token('TEXT', l_api_message);
8739: FND_MSG_pub.add;
8740: RAISE FND_API.g_exc_error;
8741: End if;
8742:

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

8768: end;
8769: end if;
8770: elsif (l_category_id = -1) then
8771: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
8772: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8773: FND_MESSAGE.set_token('TEXT', l_api_message);
8774: FND_MSG_pub.add;
8775: RAISE FND_API.g_exc_error;
8776: else

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

8769: end if;
8770: elsif (l_category_id = -1) then
8771: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
8772: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8773: FND_MESSAGE.set_token('TEXT', l_api_message);
8774: FND_MSG_pub.add;
8775: RAISE FND_API.g_exc_error;
8776: else
8777: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);

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

8775: RAISE FND_API.g_exc_error;
8776: else
8777: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
8778: l_api_message := l_api_message || ' has not been approved';
8779: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8780: FND_MESSAGE.set_token('TEXT', l_api_message);
8781: FND_MSG_pub.add;
8782: RAISE FND_API.g_exc_error;
8783: end if;

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

8776: else
8777: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
8778: l_api_message := l_api_message || ' has not been approved';
8779: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8780: FND_MESSAGE.set_token('TEXT', l_api_message);
8781: FND_MSG_pub.add;
8782: RAISE FND_API.g_exc_error;
8783: end if;
8784:

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

8897: -----------------------------
8898: l_statement := 40;
8899: if (p_txn_id is null) then
8900: l_api_message := 'IN parameter is null';
8901: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8902: FND_MESSAGE.set_token('TEXT', l_api_message);
8903: FND_MSG_PUB.add;
8904: RAISE fnd_api.g_exc_error;
8905: end if;

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

8898: l_statement := 40;
8899: if (p_txn_id is null) then
8900: l_api_message := 'IN parameter is null';
8901: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8902: FND_MESSAGE.set_token('TEXT', l_api_message);
8903: FND_MSG_PUB.add;
8904: RAISE fnd_api.g_exc_error;
8905: end if;
8906:

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

8917: where wt.transaction_id = p_txn_id;
8918: exception
8919: when no_data_found then
8920: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
8921: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8922: FND_MESSAGE.set_token('TEXT', l_api_message);
8923: FND_MSG_PUB.add;
8924: RAISE fnd_api.g_exc_error;
8925: end;

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

8918: exception
8919: when no_data_found then
8920: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
8921: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8922: FND_MESSAGE.set_token('TEXT', l_api_message);
8923: FND_MSG_PUB.add;
8924: RAISE fnd_api.g_exc_error;
8925: end;
8926:

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

8935: where pha.po_header_id = l_po_header_id;
8936: else
8937: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8938: l_api_message := l_api_message || ' wip_transactions ';
8939: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8940: FND_MESSAGE.set_token('TEXT', l_api_message);
8941: FND_MSG_pub.add;
8942: RAISE FND_API.g_exc_error;
8943: end if;

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

8936: else
8937: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8938: l_api_message := l_api_message || ' wip_transactions ';
8939: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8940: FND_MESSAGE.set_token('TEXT', l_api_message);
8941: FND_MSG_pub.add;
8942: RAISE FND_API.g_exc_error;
8943: end if;
8944:

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

8953: where pla.po_line_id = l_po_line_id;
8954: else
8955: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8956: l_api_message := l_api_message || ' wip_transactions ';
8957: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8958: FND_MESSAGE.set_token('TEXT', l_api_message);
8959: FND_MSG_pub.add;
8960: RAISE FND_API.g_exc_error;
8961: end if;

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

8954: else
8955: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8956: l_api_message := l_api_message || ' wip_transactions ';
8957: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8958: FND_MESSAGE.set_token('TEXT', l_api_message);
8959: FND_MSG_pub.add;
8960: RAISE FND_API.g_exc_error;
8961: end if;
8962:

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

8979: l_expenditure_type := to_char(-1);
8980: end;
8981: elsif (l_category_id = -1) then
8982: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
8983: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8984: FND_MESSAGE.set_token('TEXT', l_api_message);
8985: FND_MSG_pub.add;
8986: RAISE FND_API.g_exc_error;
8987: else

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

8980: end;
8981: elsif (l_category_id = -1) then
8982: l_api_message := 'No category_id exist for PO Line ID: ' || TO_CHAR(l_po_line_id);
8983: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8984: FND_MESSAGE.set_token('TEXT', l_api_message);
8985: FND_MSG_pub.add;
8986: RAISE FND_API.g_exc_error;
8987: else
8988: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);

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

8986: RAISE FND_API.g_exc_error;
8987: else
8988: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
8989: l_api_message := l_api_message || ' has not been approved';
8990: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8991: FND_MESSAGE.set_token('TEXT', l_api_message);
8992: FND_MSG_pub.add;
8993: RAISE FND_API.g_exc_error;
8994: end if;

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

8987: else
8988: l_api_message := 'PO Header ID ' || TO_CHAR(l_po_header_id);
8989: l_api_message := l_api_message || ' has not been approved';
8990: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8991: FND_MESSAGE.set_token('TEXT', l_api_message);
8992: FND_MSG_pub.add;
8993: RAISE FND_API.g_exc_error;
8994: end if;
8995: