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

Line 51: Fnd_Msg_Pub.ADD;

47: IF (NVL(p_param_value,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
48: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
49: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
50: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
51: Fnd_Msg_Pub.ADD;
52: RAISE Fnd_Api.G_EXC_ERROR;
53: END IF;
54: END Check_Reqd_Param;
55:

Line 69: Fnd_Msg_Pub.ADD;

65: IF (NVL(p_param_value,Fnd_Api.G_MISS_CHAR) = Fnd_Api.G_MISS_CHAR) THEN
66: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
67: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
68: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
69: Fnd_Msg_Pub.ADD;
70: RAISE Fnd_Api.G_EXC_ERROR;
71: END IF;
72: END Check_Reqd_Param;
73:

Line 87: Fnd_Msg_Pub.ADD;

83: IF (NVL(p_param_value,Fnd_Api.G_MISS_DATE) = Fnd_Api.G_MISS_DATE) THEN
84: Fnd_Message.SET_NAME('CSD','CSD_API_MISSING_PARAM');
85: Fnd_Message.SET_TOKEN('API_NAME',p_api_name);
86: Fnd_Message.SET_TOKEN('MISSING_PARAM',p_param_name);
87: Fnd_Msg_Pub.ADD;
88: RAISE Fnd_Api.G_EXC_ERROR;
89: END IF;
90: END Check_Reqd_Param;
91:

Line 170: If fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

166: values_or_ids => l_values_or_ids)
167: -- end bug#7151536, subhat.
168: then
169: l_error_message := fnd_flex_descval.error_message;
170: If fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
171: fnd_message.set_name('CSD', 'CSD_API_DESC_FLEX_ERR');
172: fnd_message.set_token('API_NAME', p_api_name);
173: fnd_message.set_token('DESC_FLEX_MSG', l_error_message);
174: fnd_msg_pub.add;

Line 174: fnd_msg_pub.add;

170: If fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
171: fnd_message.set_name('CSD', 'CSD_API_DESC_FLEX_ERR');
172: fnd_message.set_token('API_NAME', p_api_name);
173: fnd_message.set_token('DESC_FLEX_MSG', l_error_message);
174: fnd_msg_pub.add;
175: end if;
176: l_return_status := FALSE;
177: -- bug#7043215, subhat
178: -- added else to populate the derived/validated value to the global collection

Line 550: Fnd_Msg_Pub.initialize;

546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF Fnd_Api.to_Boolean(p_init_msg_list)
549: THEN
550: Fnd_Msg_Pub.initialize;
551: END IF;
552: -- Initialize API return status to success
553: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
554: --

Line 601: Fnd_Msg_Pub.Count_And_Get

597: THEN
598: COMMIT WORK;
599: END IF;
600: -- Standard call to get message count and if count is 1, get message info.
601: Fnd_Msg_Pub.Count_And_Get
602: (p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605: --

Line 611: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

607: WHEN Fnd_Api.G_EXC_ERROR THEN
608: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
609: (P_API_NAME => L_API_NAME
610: ,P_PKG_NAME => G_PKG_NAME
611: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
612: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
613: ,X_MSG_COUNT => X_MSG_COUNT
614: ,X_MSG_DATA => X_MSG_DATA
615: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 622: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

618: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
619: Jtf_Plsql_Api.HANDLE_EXCEPTIONS
620: (P_API_NAME => L_API_NAME
621: ,P_PKG_NAME => G_PKG_NAME
622: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
623: ,P_PACKAGE_TYPE => Jtf_Plsql_Api.G_PVT
624: ,X_MSG_COUNT => X_MSG_COUNT
625: ,X_MSG_DATA => X_MSG_DATA
626: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 816: Fnd_Msg_Pub.ADD;

812: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
813: '-------------there are open jobs---------------');
814: END IF;
815: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_WIP_JOBS');
816: Fnd_Msg_Pub.ADD;
817: RAISE Fnd_Api.G_EXC_ERROR ;
818: END IF;
819: CLOSE wipjob_cur;
820: ELSIF (l_repair_mode = C_TASK_MODE) THEN

Line 836: Fnd_Msg_Pub.ADD;

832: Fnd_Log.STRING (Fnd_Log.LEVEL_STATEMENT, 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
833: '-------------there are open tasks---------------');
834: END IF;
835: Fnd_Message.set_name('CSD', 'CSD_API_OPEN_TASKS');
836: Fnd_Msg_Pub.ADD;
837: RAISE Fnd_Api.G_EXC_ERROR ;
838: END IF;
839: CLOSE task_cur;
840: END IF;

Line 851: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

847:
848: EXCEPTION
849: WHEN Fnd_Api.G_EXC_ERROR THEN
850: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
851: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
852: IF ( Fnd_Log.LEVEL_ERROR >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
853: Fnd_Log.STRING(Fnd_Log.LEVEL_ERROR,
854: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
855: 'EXC_ERROR ['||x_msg_data||']');

Line 860: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );

856: END IF;
857:
858: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
860: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
861: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
862: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
863: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',
864: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');

Line 869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

865: END IF;
866:
867: WHEN OTHERS THEN
868: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );

Line 871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );

867: WHEN OTHERS THEN
868: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
874:
875: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );

869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
870: THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME , l_api_name );
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
874:
875: IF ( Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL ) THEN
876: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,
877: 'csd.plsql.csd_repairs_util.check_task_n_wipjob',

Line 943: Fnd_Msg_Pub.ADD;

939: -- ID based attribute is NULL or MISSING
940: IF (p_repair_status_rec.repair_number IS NULL) THEN
941: -- value based parameter is also NULL or MISSING
942: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
943: Fnd_Msg_Pub.ADD;
944: x_return_status := Fnd_Api.G_RET_STS_ERROR;
945: ELSE
946: OPEN repair_id_conv_cur(p_repair_status_rec.repair_number);
947: FETCH repair_id_conv_cur INTO x_repair_status_rec.repair_line_id;

Line 953: Fnd_Msg_Pub.ADD;

949: -- Id fetch was not successful
950: -- Conversion failed.
951: CLOSE repair_id_conv_cur;
952: Fnd_Message.SET_NAME ('CSD', 'CSD_API_INV_REP_NUM');
953: Fnd_Msg_Pub.ADD;
954: x_return_status := Fnd_Api.G_RET_STS_ERROR;
955: RAISE Fnd_Api.G_EXC_ERROR;
956: END IF;
957: CLOSE repair_id_conv_cur;

Line 966: Fnd_Msg_Pub.ADD;

962: -- If the value based parameter is also passed, generate an
963: -- informational message.
964: IF (p_repair_status_rec.repair_number IS NOT NULL) THEN
965: Fnd_Message.SET_NAME('CSD', 'CSD_API_INPUT_IGNORE');
966: Fnd_Msg_Pub.ADD;
967: END IF;
968: END IF;
969:
970:

Line 976: Fnd_Msg_Pub.ADD;

972: -- ID based attribute is NULL or MISSING
973: IF (p_repair_status_rec.repair_status IS NULL) THEN
974: -- value based parameter is also NULL or MISSING
975: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
976: Fnd_Msg_Pub.ADD;
977: x_return_status := Fnd_Api.G_RET_STS_ERROR;
978: ELSE
979: OPEN flow_stat_cur(p_repair_status_Rec.repair_status);
980: FETCH flow_stat_cur INTO x_repair_status_Rec.repair_status_id;

Line 984: Fnd_Msg_Pub.ADD;

980: FETCH flow_stat_cur INTO x_repair_status_Rec.repair_status_id;
981: IF(flow_stat_cur%NOTFOUND) THEN
982: CLOSE flow_stat_cur;
983: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
984: Fnd_Msg_Pub.ADD;
985: x_return_status := Fnd_Api.G_RET_STS_ERROR;
986: RAISE Fnd_Api.G_EXC_ERROR;
987: END IF;
988: CLOSE flow_stat_cur;

Line 997: Fnd_Msg_Pub.ADD;

993: -- If the value based parameter is also passed, generate an
994: -- informational message.
995: IF (p_repair_status_rec.repair_status IS NOT NULL) THEN
996: Fnd_Message.SET_NAME('CSD', 'CSD_API_INPUT_IGNORE');
997: Fnd_Msg_Pub.ADD;
998: END IF;
999: END IF;
1000:
1001:

Line 1463: FND_MSG_PUB.Count_And_Get

1459: EXCEPTION
1460: When FND_API.G_EXC_ERROR then
1461: Rollback To change_item_ib_owner;
1462: x_return_status := FND_API.G_RET_STS_ERROR ;
1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data );
1466:
1467: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1470: FND_MSG_PUB.Count_And_Get

1466:
1467: When FND_API.G_EXC_UNEXPECTED_ERROR then
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: ROLLBACK TO change_item_ib_owner;
1470: FND_MSG_PUB.Count_And_Get
1471: ( p_count => x_msg_count,
1472: p_data => x_msg_data );
1473:
1474: When OTHERS then

Line 1477: If FND_MSG_PUB.Check_Msg_Level

1473:
1474: When OTHERS then
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1476: Rollback To change_item_ib_owner;
1477: If FND_MSG_PUB.Check_Msg_Level
1478: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1479: FND_MSG_PUB.Add_Exc_Msg
1480: (G_PKG_NAME,
1481: l_api_name );

Line 1478: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

1474: When OTHERS then
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1476: Rollback To change_item_ib_owner;
1477: If FND_MSG_PUB.Check_Msg_Level
1478: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1479: FND_MSG_PUB.Add_Exc_Msg
1480: (G_PKG_NAME,
1481: l_api_name );
1482: End If;

Line 1479: FND_MSG_PUB.Add_Exc_Msg

1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1476: Rollback To change_item_ib_owner;
1477: If FND_MSG_PUB.Check_Msg_Level
1478: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1479: FND_MSG_PUB.Add_Exc_Msg
1480: (G_PKG_NAME,
1481: l_api_name );
1482: End If;
1483: FND_MSG_PUB.Count_And_Get

Line 1483: FND_MSG_PUB.Count_And_Get

1479: FND_MSG_PUB.Add_Exc_Msg
1480: (G_PKG_NAME,
1481: l_api_name );
1482: End If;
1483: FND_MSG_PUB.Count_And_Get
1484: (p_count => x_msg_count,
1485: p_data => x_msg_data );
1486:
1487: END CHANGE_ITEM_IB_OWNER;

Line 1598: Fnd_Msg_Pub.ADD;

1594: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1595: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1596: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1597: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1598: Fnd_Msg_Pub.ADD;
1599: RAISE Fnd_Api.G_EXC_ERROR;
1600: END IF;
1601:
1602: l_inp_rec.contract_line_id := p_contract_line_id ;

Line 1633: FND_MSG_PUB.Count_And_Get

1629: EXCEPTION
1630: When FND_API.G_EXC_ERROR then
1631: Rollback To get_contract_resolve_by_date;
1632: x_return_status := FND_API.G_RET_STS_ERROR ;
1633: FND_MSG_PUB.Count_And_Get
1634: (p_count => x_msg_count,
1635: p_data => x_msg_data );
1636:
1637: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1640: FND_MSG_PUB.Count_And_Get

1636:
1637: When FND_API.G_EXC_UNEXPECTED_ERROR then
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1639: ROLLBACK TO get_contract_resolve_by_date;
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count,
1642: p_data => x_msg_data );
1643:
1644: When OTHERS then

Line 1647: If FND_MSG_PUB.Check_Msg_Level

1643:
1644: When OTHERS then
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: Rollback To get_contract_resolve_by_date;
1647: If FND_MSG_PUB.Check_Msg_Level
1648: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1649: FND_MSG_PUB.Add_Exc_Msg
1650: (G_PKG_NAME,
1651: lc_api_name );

Line 1648: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

1644: When OTHERS then
1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: Rollback To get_contract_resolve_by_date;
1647: If FND_MSG_PUB.Check_Msg_Level
1648: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1649: FND_MSG_PUB.Add_Exc_Msg
1650: (G_PKG_NAME,
1651: lc_api_name );
1652: End If;

Line 1649: FND_MSG_PUB.Add_Exc_Msg

1645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: Rollback To get_contract_resolve_by_date;
1647: If FND_MSG_PUB.Check_Msg_Level
1648: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1649: FND_MSG_PUB.Add_Exc_Msg
1650: (G_PKG_NAME,
1651: lc_api_name );
1652: End If;
1653: FND_MSG_PUB.Count_And_Get

Line 1653: FND_MSG_PUB.Count_And_Get

1649: FND_MSG_PUB.Add_Exc_Msg
1650: (G_PKG_NAME,
1651: lc_api_name );
1652: End If;
1653: FND_MSG_PUB.Count_And_Get
1654: (p_count => x_msg_count,
1655: p_data => x_msg_data );
1656:
1657: END get_contract_resolve_by_date;

Line 1756: fnd_msg_pub.initialize;

1752:
1753: IF fnd_api.to_boolean(p_init_msg_list)
1754: THEN
1755: -- initialize message list
1756: fnd_msg_pub.initialize;
1757: END IF;
1758:
1759: if lc_log_level >= lc_procedure_level then
1760: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');

Line 1985: fnd_msg_pub.initialize;

1981: end if;
1982:
1983: if FND_API.to_boolean(p_init_msg_list) then
1984: -- initialize message list
1985: fnd_msg_pub.initialize;
1986: end if;
1987:
1988: if lc_log_level >= lc_procedure_level then
1989: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');

Line 2192: FND_MSG_PUB.Count_And_Get

2188:
2189: EXCEPTION
2190: When FND_API.G_EXC_ERROR then
2191: x_return_status := FND_API.G_RET_STS_ERROR ;
2192: FND_MSG_PUB.Count_And_Get
2193: (p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2198: FND_MSG_PUB.Count_And_Get

2194: p_data => x_msg_data );
2195:
2196: When FND_API.G_EXC_UNEXPECTED_ERROR then
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data );
2201:
2202: When OTHERS then

Line 2204: If FND_MSG_PUB.Check_Msg_Level

2200: p_data => x_msg_data );
2201:
2202: When OTHERS then
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2204: If FND_MSG_PUB.Check_Msg_Level
2205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2206: FND_MSG_PUB.Add_Exc_Msg
2207: (G_PKG_NAME,
2208: lc_api_name );

Line 2205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

2201:
2202: When OTHERS then
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2204: If FND_MSG_PUB.Check_Msg_Level
2205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2206: FND_MSG_PUB.Add_Exc_Msg
2207: (G_PKG_NAME,
2208: lc_api_name );
2209: End If;

Line 2206: FND_MSG_PUB.Add_Exc_Msg

2202: When OTHERS then
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2204: If FND_MSG_PUB.Check_Msg_Level
2205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2206: FND_MSG_PUB.Add_Exc_Msg
2207: (G_PKG_NAME,
2208: lc_api_name );
2209: End If;
2210: FND_MSG_PUB.Count_And_Get

Line 2210: FND_MSG_PUB.Count_And_Get

2206: FND_MSG_PUB.Add_Exc_Msg
2207: (G_PKG_NAME,
2208: lc_api_name );
2209: End If;
2210: FND_MSG_PUB.Count_And_Get
2211: (p_count => x_msg_count,
2212: p_data => x_msg_data );
2213: END DEFAULT_RO_ATTRS_FROM_RULE;
2214: