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.GMF_ITEMCOST_PVT dependencies on FND_MSG_PUB

Line 55: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere to decide to log a debug msg.

51: /*******************
52: * Global variables *
53: *******************/
54: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ItemCost_PVT';
55: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere to decide to log a debug msg.
56:
57: -- Func start of comments
58: --+==========================================================================+
59: --| Procedure Name |

Line 85: FND_MSG_PUB.Add;

81: IS
82: BEGIN
83: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
84: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
85: FND_MSG_PUB.Add;
86: END log_msg ;
87: --
88: -- Func start of comments
89: --+==========================================================================+

Line 238: FND_MSG_PUB.initialize;

234: * Initialize message list if p_init_msg_list is set to TRUE. *
235: *************************************************************/
236: IF FND_API.to_Boolean( p_init_msg_list )
237: THEN
238: FND_MSG_PUB.initialize;
239: END IF;
240:
241: /*************************************************
242: * Standard call to check for call compatibility. *

Line 254: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

250: * Initialize API return status to success *
251: ******************************************/
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
255: THEN
256: log_msg('Beginning Private Create Item Cost API.');
257: END IF;
258:

Line 259: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

255: THEN
256: log_msg('Beginning Private Create Item Cost API.');
257: END IF;
258:
259: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
260: THEN
261: log_msg(' Inserting Component Costs for Item ' || p_header_rec.inventory_item_id ||
262: ' Organization Id ' || p_header_rec.organization_id ||
263: ' Period Id ' || p_header_rec.period_id ||

Line 289: FND_MSG_PUB.Add;

285: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
286: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_this_level_dtl_tbl(i).cost_cmpntcls_id);
287: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_this_level_dtl_tbl(i).cost_analysis_code);
288: FND_MESSAGE.SET_TOKEN('COST_LEVEL',0);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: /* end duplicate record check */
293:

Line 431: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

427: p_user_id,
428: FND_GLOBAL.LOGIN_ID
429: );
430:
431: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
432: THEN
433: log_msg(' 1 this level row inserted for ' ||
434: ' Cmptcls Id ' || p_this_level_dtl_tbl(i).cost_cmpntcls_id ||
435: ' Analysis Code ' || p_this_level_dtl_tbl(i).cost_analysis_code ||

Line 452: FND_MSG_PUB.Add;

448: x_costcmpnt_ids.delete ;
449: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_THISLVL_INS_FAILED');
450: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
451: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: RAISE ;
455: END ;
456: END LOOP ;

Line 457: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: RAISE ;
455: END ;
456: END LOOP ;
457: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
458: THEN
459: log_msg('Lower level Count : ' || p_lower_level_dtl_tbl.count);
460: END IF;
461:

Line 482: FND_MSG_PUB.Add;

478: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
479: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
480: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_lower_level_dtl_tbl(i).cost_analysis_code);
481: FND_MESSAGE.SET_TOKEN('COST_LEVEL',1);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485: /* end duplicate record check */
486:

Line 624: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

620: p_user_id,
621: FND_GLOBAL.LOGIN_ID
622: );
623:
624: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
625: THEN
626: log_msg(' 1 lower level row inserted for ' ||
627: ' Cmptcls Id ' || p_lower_level_dtl_Tbl(i).cost_cmpntcls_id ||
628: ' Analysis Code ' || p_lower_level_dtl_Tbl(i).cost_analysis_code ||

Line 644: FND_MSG_PUB.Add;

640: x_costcmpnt_ids.delete ;
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_LWRLVL_INS_FAILED');
642: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_Tbl(i).cost_cmpntcls_id);
643: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_Tbl(i).cost_analysis_code);
644: FND_MSG_PUB.Add;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RAISE ;
647: END ;
648: END LOOP ;

Line 649: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: RAISE ;
647: END ;
648: END LOOP ;
649: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
650: THEN
651: log_msg( x_costcmpnt_ids.count || ' Component cost row(s) inserted');
652: END IF;
653:

Line 665: FND_MSG_PUB.Count_And_Get

661:
662: /**************************************************************************
663: * Standard call to get message count and if count is 1, get message info. *
664: **************************************************************************/
665: FND_MSG_PUB.Count_And_Get
666: (
667: p_count => x_msg_count,
668: p_data => x_msg_data
669: );

Line 674: FND_MSG_PUB.Count_And_Get

670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: ROLLBACK TO Create_Item_Cost_PVT;
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.Count_And_Get
675: (
676: p_count => x_msg_count,
677: p_data => x_msg_data
678: );

Line 682: FND_MSG_PUB.Count_And_Get

678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO Create_Item_Cost_PVT;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: FND_MSG_PUB.Count_And_Get
683: (
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );

Line 690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

686: );
687: WHEN OTHERS THEN
688: ROLLBACK TO Create_Item_Cost_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: (
694: G_PKG_NAME,

Line 692: FND_MSG_PUB.Add_Exc_Msg

688: ROLLBACK TO Create_Item_Cost_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: (
694: G_PKG_NAME,
695: l_api_name
696: );

Line 698: FND_MSG_PUB.Count_And_Get

694: G_PKG_NAME,
695: l_api_name
696: );
697: END IF;
698: FND_MSG_PUB.Count_And_Get
699: (
700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );

Line 770: FND_MSG_PUB.initialize;

766: * Initialize message list if p_init_msg_list is set to TRUE. *
767: *************************************************************/
768: IF FND_API.to_Boolean( p_init_msg_list )
769: THEN
770: FND_MSG_PUB.initialize;
771: END IF;
772:
773: /*************************************************
774: * Standard call to check for call compatibility. *

Line 786: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

782: * Initialize API return status to success *
783: ******************************************/
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
787: THEN
788: log_msg('Beginning Private Update Item Cost API.');
789: END IF;
790:

Line 791: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

787: THEN
788: log_msg('Beginning Private Update Item Cost API.');
789: END IF;
790:
791: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
792: THEN
793: log_msg(' This level Count : ' || p_this_level_dtl_tbl.count);
794: log_msg(' Processing Component Costs for Item ' || p_header_rec.inventory_item_id ||
795: ' Organization Id ' || p_header_rec.organization_id ||

Line 871: FND_MSG_PUB.Add;

867: IF p_this_level_dtl_tbl(i).delete_mark = 0
868: THEN
869: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
870: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
874: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
875: FND_MSG_PUB.Add;

Line 875: FND_MSG_PUB.Add;

871: FND_MSG_PUB.Add;
872: ELSE
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
874: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
875: FND_MSG_PUB.Add;
876: END IF ;
877: x_return_status := FND_API.G_RET_STS_ERROR ;
878: EXIT ;
879: ELSE

Line 882: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

878: EXIT ;
879: ELSE
880: IF p_this_level_dtl_tbl(i).delete_mark = 0
881: THEN
882: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
883: THEN
884: log_msg(' 1 row updated for Component Cost Id ' || p_this_level_dtl_tbl(i).cmpntcost_id);
885: END IF;
886: ELSE

Line 887: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

883: THEN
884: log_msg(' 1 row updated for Component Cost Id ' || p_this_level_dtl_tbl(i).cmpntcost_id);
885: END IF;
886: ELSE
887: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
888: THEN
889: log_msg(' 1 row deleted for Component Cost Id ' || p_this_level_dtl_tbl(i).cmpntcost_id);
890: END IF;
891: END IF ;

Line 964: FND_MSG_PUB.Add;

960: IF p_this_level_dtl_tbl(i).delete_mark = 0 THEN
961: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
962: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
963: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
964: FND_MSG_PUB.Add;
965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
968: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);

Line 969: FND_MSG_PUB.Add;

965: ELSE
966: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
967: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
968: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
969: FND_MSG_PUB.Add;
970: END IF ;
971: x_return_status := FND_API.G_RET_STS_ERROR ;
972: EXIT ;
973: ELSE

Line 976: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

972: EXIT ;
973: ELSE
974: IF p_this_level_dtl_tbl(i).delete_mark = 0
975: THEN
976: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
977: THEN
978: log_msg(' 1 row updated for Component Class Id ' || p_this_level_dtl_tbl(i).cost_cmpntcls_id ||
979: ' Analysis Code ' || p_this_level_dtl_tbl(i).cost_analysis_code);
980: END IF;

Line 982: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

978: log_msg(' 1 row updated for Component Class Id ' || p_this_level_dtl_tbl(i).cost_cmpntcls_id ||
979: ' Analysis Code ' || p_this_level_dtl_tbl(i).cost_analysis_code);
980: END IF;
981: ELSE
982: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
983: THEN
984: log_msg(' 1 row deleted for Component Class Id ' || p_this_level_dtl_tbl(i).cost_cmpntcls_id ||
985: ' Analysis Code ' || p_this_level_dtl_tbl(i).cost_analysis_code);
986: END IF;

Line 998: FND_MSG_PUB.Add;

994: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
995: THEN
996: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
997: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
998: FND_MSG_PUB.Add;
999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1002: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);

Line 1003: FND_MSG_PUB.Add;

999: ELSE
1000: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1001: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1002: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1003: FND_MSG_PUB.Add;
1004: END IF ;
1005: ELSE
1006: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1007: THEN

Line 1010: FND_MSG_PUB.Add;

1006: IF (p_this_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_this_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1007: THEN
1008: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1009: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_this_level_dtl_tbl(i).cmpntcost_id);
1010: FND_MSG_PUB.Add;
1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1014: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);

Line 1015: FND_MSG_PUB.Add;

1011: ELSE
1012: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1013: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_this_level_dtl_tbl(i).cost_cmpntcls_id);
1014: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_this_level_dtl_tbl(i).cost_analysis_code);
1015: FND_MSG_PUB.Add;
1016: END IF ;
1017: END IF ;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: RAISE ;

Line 1022: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: RAISE ;
1020: END ;
1021: END LOOP ;
1022: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1023: THEN
1024: log_msg('Lower level Count : ' || p_lower_level_dtl_tbl.count);
1025: END IF;
1026: FOR i in 1..p_lower_level_dtl_tbl.count

Line 1057: FND_MSG_PUB.Add;

1053: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1054: THEN
1055: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_ID');
1056: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1060: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1061: FND_MSG_PUB.Add;

Line 1061: FND_MSG_PUB.Add;

1057: FND_MSG_PUB.Add;
1058: ELSE
1059: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_ID');
1060: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1061: FND_MSG_PUB.Add;
1062: END IF ;
1063: x_return_status := FND_API.G_RET_STS_ERROR ;
1064: EXIT ;
1065: ELSE

Line 1068: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1064: EXIT ;
1065: ELSE
1066: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1067: THEN
1068: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1069: THEN
1070: log_msg(' 1 row updated for Component Cost Id ' || p_lower_level_dtl_tbl(i).cmpntcost_id);
1071: END IF;
1072: ELSE

Line 1073: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1069: THEN
1070: log_msg(' 1 row updated for Component Cost Id ' || p_lower_level_dtl_tbl(i).cmpntcost_id);
1071: END IF;
1072: ELSE
1073: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1074: THEN
1075: log_msg(' 1 row deleted for Component Cost Id ' || p_lower_level_dtl_tbl(i).cmpntcost_id);
1076: END IF;
1077: END IF ;

Line 1117: FND_MSG_PUB.Add;

1113: THEN
1114: FND_MESSAGE.SET_NAME('GMF','GMF_API_UPD_IC_NOT_FOUND_DTL');
1115: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1116: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1117: FND_MSG_PUB.Add;
1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1121: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);

Line 1122: FND_MSG_PUB.Add;

1118: ELSE
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_IC_NOT_FOUND_DTL');
1120: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1121: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1122: FND_MSG_PUB.Add;
1123: END IF ;
1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125: EXIT ;
1126: ELSE

Line 1129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1125: EXIT ;
1126: ELSE
1127: IF p_lower_level_dtl_tbl(i).delete_mark = 0
1128: THEN
1129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1130: THEN
1131: log_msg(' 1 row updated for Component Class Id ' || p_lower_level_dtl_tbl(i).cost_cmpntcls_id ||
1132: ' Analysis Code ' || p_lower_level_dtl_tbl(i).cost_analysis_code);
1133: END IF;

Line 1135: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1131: log_msg(' 1 row updated for Component Class Id ' || p_lower_level_dtl_tbl(i).cost_cmpntcls_id ||
1132: ' Analysis Code ' || p_lower_level_dtl_tbl(i).cost_analysis_code);
1133: END IF;
1134: ELSE
1135: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1136: THEN
1137: log_msg(' 1 row deleted for Component Class Id ' ||p_lower_level_dtl_tbl(i).cost_cmpntcls_id ||
1138: ' Analysis Code ' || p_lower_level_dtl_tbl(i).cost_analysis_code);
1139: END IF;

Line 1151: FND_MSG_PUB.Add;

1147: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1148: THEN
1149: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_ID');
1150: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1151: FND_MSG_PUB.Add;
1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1155: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);

Line 1156: FND_MSG_PUB.Add;

1152: ELSE
1153: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_UPD_FAILED_DTLS');
1154: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1155: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1156: FND_MSG_PUB.Add;
1157: END IF ;
1158: ELSE
1159: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1160: THEN

Line 1163: FND_MSG_PUB.Add;

1159: IF (p_lower_level_dtl_tbl(i).cmpntcost_id IS NOT NULL) OR (p_lower_level_dtl_tbl(i).cmpntcost_id <> FND_API.G_MISS_NUM)
1160: THEN
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_ID');
1162: FND_MESSAGE.SET_TOKEN('CMPNTCOST_ID', p_lower_level_dtl_tbl(i).cmpntcost_id);
1163: FND_MSG_PUB.Add;
1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1167: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);

Line 1168: FND_MSG_PUB.Add;

1164: ELSE
1165: FND_MESSAGE.SET_NAME('GMF','GMF_API_IC_DEL_FAILED_DTLS');
1166: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_lower_level_dtl_tbl(i).cost_cmpntcls_id);
1167: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_lower_level_dtl_tbl(i).cost_analysis_code);
1168: FND_MSG_PUB.Add;
1169: END IF ;
1170: END IF ;
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: RAISE ;

Line 1187: FND_MSG_PUB.Count_And_Get

1183:
1184: /**************************************************************************
1185: * Standard call to get message count and if count is 1, get message info. *
1186: **************************************************************************/
1187: FND_MSG_PUB.Count_And_Get
1188: (
1189: p_count => x_msg_count,
1190: p_data => x_msg_data
1191: );

Line 1196: FND_MSG_PUB.Count_And_Get

1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO UPDATE_ITEM_COST_PVT;
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count,
1199: p_data => x_msg_data
1200: );

Line 1204: FND_MSG_PUB.Count_And_Get

1200: );
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: ROLLBACK TO UPDATE_ITEM_COST_PVT;
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204: FND_MSG_PUB.Count_And_Get
1205: (
1206: p_count => x_msg_count,
1207: p_data => x_msg_data
1208: );

Line 1212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1208: );
1209: WHEN OTHERS THEN
1210: ROLLBACK TO Update_Item_Cost_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1213: THEN
1214: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1215: END IF;
1216: FND_MSG_PUB.Count_And_Get

Line 1214: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1210: ROLLBACK TO Update_Item_Cost_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1213: THEN
1214: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1215: END IF;
1216: FND_MSG_PUB.Count_And_Get
1217: (
1218: p_count => x_msg_count,

Line 1216: FND_MSG_PUB.Count_And_Get

1212: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1213: THEN
1214: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1215: END IF;
1216: FND_MSG_PUB.Count_And_Get
1217: (
1218: p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );

Line 1314: FND_MSG_PUB.initialize;

1310: * Initialize message list if p_init_msg_list is set to TRUE. *
1311: *************************************************************/
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;
1315: END IF;
1316:
1317: /*************************************************
1318: * Standard call to check for call compatibility. *

Line 1330: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1326: * Initialize API return status to success *
1327: ******************************************/
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:
1330: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1331: THEN
1332: log_msg('Beginning Private Get Item Cost API.');
1333: END IF;
1334:

Line 1335: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1331: THEN
1332: log_msg('Beginning Private Get Item Cost API.');
1333: END IF;
1334:
1335: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1336: THEN
1337: log_msg(' Retrieving Component Costs for Item ' || p_header_rec.inventory_item_id ||
1338: ' Organization id ' || p_header_rec.organization_id ||
1339: ' Period Id' || p_header_rec.Period_id ||

Line 1401: FND_MSG_PUB.Count_And_Get

1397:
1398: /**************************************************************************
1399: * Standard call to get message count and if count is 1, get message info. *
1400: **************************************************************************/
1401: FND_MSG_PUB.Count_And_Get
1402: (
1403: p_count => x_msg_count,
1404: p_data => x_msg_data
1405: );

Line 1411: FND_MSG_PUB.Count_And_Get

1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: ROLLBACK TO GET_ITEM_COST_PVT;
1410: x_return_status := FND_API.G_RET_STS_ERROR ;
1411: FND_MSG_PUB.Count_And_Get
1412: (
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );

Line 1419: FND_MSG_PUB.Count_And_Get

1415: );
1416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1417: ROLLBACK TO GET_ITEM_COST_PVT;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: FND_MSG_PUB.Count_And_Get
1420: (
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );

Line 1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1423: );
1424: WHEN OTHERS THEN
1425: ROLLBACK TO GET_ITEM_COST_PVT;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1428: THEN
1429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1430: END IF;
1431: FND_MSG_PUB.Count_And_Get

Line 1429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1425: ROLLBACK TO GET_ITEM_COST_PVT;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1428: THEN
1429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1430: END IF;
1431: FND_MSG_PUB.Count_And_Get
1432: (
1433: p_count => x_msg_count,

Line 1431: FND_MSG_PUB.Count_And_Get

1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1428: THEN
1429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1430: END IF;
1431: FND_MSG_PUB.Count_And_Get
1432: (
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );