DBA Data[Home] [Help]

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 552: Fnd_Msg_Pub.initialize;

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

Line 603: Fnd_Msg_Pub.Count_And_Get

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

Line 613: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

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

Line 624: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

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

Line 818: Fnd_Msg_Pub.ADD;

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

Line 838: Fnd_Msg_Pub.ADD;

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

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

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

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

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

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

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

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

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

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

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

Line 945: Fnd_Msg_Pub.ADD;

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

Line 955: Fnd_Msg_Pub.ADD;

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

Line 968: Fnd_Msg_Pub.ADD;

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

Line 978: Fnd_Msg_Pub.ADD;

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

Line 986: Fnd_Msg_Pub.ADD;

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

Line 999: Fnd_Msg_Pub.ADD;

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

Line 1493: FND_MSG_PUB.Count_And_Get

1489: EXCEPTION
1490: When FND_API.G_EXC_ERROR then
1491: Rollback To change_item_ib_owner;
1492: x_return_status := FND_API.G_RET_STS_ERROR ;
1493: FND_MSG_PUB.Count_And_Get
1494: (p_count => x_msg_count,
1495: p_data => x_msg_data );
1496:
1497: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1500: FND_MSG_PUB.Count_And_Get

1496:
1497: When FND_API.G_EXC_UNEXPECTED_ERROR then
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1499: ROLLBACK TO change_item_ib_owner;
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data );
1503:
1504: When OTHERS then

Line 1507: If FND_MSG_PUB.Check_Msg_Level

1503:
1504: When OTHERS then
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506: Rollback To change_item_ib_owner;
1507: If FND_MSG_PUB.Check_Msg_Level
1508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1509: FND_MSG_PUB.Add_Exc_Msg
1510: (G_PKG_NAME,
1511: l_api_name );

Line 1508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

1504: When OTHERS then
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506: Rollback To change_item_ib_owner;
1507: If FND_MSG_PUB.Check_Msg_Level
1508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1509: FND_MSG_PUB.Add_Exc_Msg
1510: (G_PKG_NAME,
1511: l_api_name );
1512: End If;

Line 1509: FND_MSG_PUB.Add_Exc_Msg

1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506: Rollback To change_item_ib_owner;
1507: If FND_MSG_PUB.Check_Msg_Level
1508: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1509: FND_MSG_PUB.Add_Exc_Msg
1510: (G_PKG_NAME,
1511: l_api_name );
1512: End If;
1513: FND_MSG_PUB.Count_And_Get

Line 1513: FND_MSG_PUB.Count_And_Get

1509: FND_MSG_PUB.Add_Exc_Msg
1510: (G_PKG_NAME,
1511: l_api_name );
1512: End If;
1513: FND_MSG_PUB.Count_And_Get
1514: (p_count => x_msg_count,
1515: p_data => x_msg_data );
1516:
1517: END CHANGE_ITEM_IB_OWNER;

Line 1628: Fnd_Msg_Pub.ADD;

1624: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1625: IF (NVL(l_server_timezone_id,Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM) THEN
1626: Fnd_Message.SET_NAME('CSD','CSD_CANNOT_GET_PROFILE_VALUE');
1627: Fnd_Message.SET_TOKEN('PROFILE',get_user_profile_option_name('SERVER_TIMEZONE_ID'));
1628: Fnd_Msg_Pub.ADD;
1629: RAISE Fnd_Api.G_EXC_ERROR;
1630: END IF;
1631:
1632: l_inp_rec.contract_line_id := p_contract_line_id ;

Line 1663: FND_MSG_PUB.Count_And_Get

1659: EXCEPTION
1660: When FND_API.G_EXC_ERROR then
1661: Rollback To get_contract_resolve_by_date;
1662: x_return_status := FND_API.G_RET_STS_ERROR ;
1663: FND_MSG_PUB.Count_And_Get
1664: (p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1670: FND_MSG_PUB.Count_And_Get

1666:
1667: When FND_API.G_EXC_UNEXPECTED_ERROR then
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: ROLLBACK TO get_contract_resolve_by_date;
1670: FND_MSG_PUB.Count_And_Get
1671: ( p_count => x_msg_count,
1672: p_data => x_msg_data );
1673:
1674: When OTHERS then

Line 1677: If FND_MSG_PUB.Check_Msg_Level

1673:
1674: When OTHERS then
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: Rollback To get_contract_resolve_by_date;
1677: If FND_MSG_PUB.Check_Msg_Level
1678: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1679: FND_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME,
1681: lc_api_name );

Line 1678: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

1674: When OTHERS then
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: Rollback To get_contract_resolve_by_date;
1677: If FND_MSG_PUB.Check_Msg_Level
1678: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1679: FND_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME,
1681: lc_api_name );
1682: End If;

Line 1679: FND_MSG_PUB.Add_Exc_Msg

1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: Rollback To get_contract_resolve_by_date;
1677: If FND_MSG_PUB.Check_Msg_Level
1678: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1679: FND_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME,
1681: lc_api_name );
1682: End If;
1683: FND_MSG_PUB.Count_And_Get

Line 1683: FND_MSG_PUB.Count_And_Get

1679: FND_MSG_PUB.Add_Exc_Msg
1680: (G_PKG_NAME,
1681: lc_api_name );
1682: End If;
1683: FND_MSG_PUB.Count_And_Get
1684: (p_count => x_msg_count,
1685: p_data => x_msg_data );
1686:
1687: END get_contract_resolve_by_date;

Line 1786: fnd_msg_pub.initialize;

1782:
1783: IF fnd_api.to_boolean(p_init_msg_list)
1784: THEN
1785: -- initialize message list
1786: fnd_msg_pub.initialize;
1787: END IF;
1788:
1789: if lc_log_level >= lc_procedure_level then
1790: fnd_log.string(lc_log_level,lc_mod_name,'Begin auto_update_ro_status');

Line 2015: fnd_msg_pub.initialize;

2011: end if;
2012:
2013: if FND_API.to_boolean(p_init_msg_list) then
2014: -- initialize message list
2015: fnd_msg_pub.initialize;
2016: end if;
2017:
2018: if lc_log_level >= lc_procedure_level then
2019: fnd_log.string(lc_log_level,lc_mod_name,'Begin default_ro_attrs_from_rule');

Line 2222: FND_MSG_PUB.Count_And_Get

2218:
2219: EXCEPTION
2220: When FND_API.G_EXC_ERROR then
2221: x_return_status := FND_API.G_RET_STS_ERROR ;
2222: FND_MSG_PUB.Count_And_Get
2223: (p_count => x_msg_count,
2224: p_data => x_msg_data );
2225:
2226: When FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2228: FND_MSG_PUB.Count_And_Get

2224: p_data => x_msg_data );
2225:
2226: When FND_API.G_EXC_UNEXPECTED_ERROR then
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2228: FND_MSG_PUB.Count_And_Get
2229: ( p_count => x_msg_count,
2230: p_data => x_msg_data );
2231:
2232: When OTHERS then

Line 2234: If FND_MSG_PUB.Check_Msg_Level

2230: p_data => x_msg_data );
2231:
2232: When OTHERS then
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2234: If FND_MSG_PUB.Check_Msg_Level
2235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2236: FND_MSG_PUB.Add_Exc_Msg
2237: (G_PKG_NAME,
2238: lc_api_name );

Line 2235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then

2231:
2232: When OTHERS then
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2234: If FND_MSG_PUB.Check_Msg_Level
2235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2236: FND_MSG_PUB.Add_Exc_Msg
2237: (G_PKG_NAME,
2238: lc_api_name );
2239: End If;

Line 2236: FND_MSG_PUB.Add_Exc_Msg

2232: When OTHERS then
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2234: If FND_MSG_PUB.Check_Msg_Level
2235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2236: FND_MSG_PUB.Add_Exc_Msg
2237: (G_PKG_NAME,
2238: lc_api_name );
2239: End If;
2240: FND_MSG_PUB.Count_And_Get

Line 2240: FND_MSG_PUB.Count_And_Get

2236: FND_MSG_PUB.Add_Exc_Msg
2237: (G_PKG_NAME,
2238: lc_api_name );
2239: End If;
2240: FND_MSG_PUB.Count_And_Get
2241: (p_count => x_msg_count,
2242: p_data => x_msg_data );
2243: END DEFAULT_RO_ATTRS_FROM_RULE;
2244:

Line 2322: fnd_msg_pub.initialize;

2318: raise fnd_api.g_exc_unexpected_error;
2319: end if;
2320:
2321: IF fnd_api.to_boolean(p_init_msg_list) THEN
2322: fnd_msg_pub.initialize;
2323: END IF;
2324:
2325: -- initialize return status.
2326: x_return_status := FND_API.g_ret_sts_success;

Line 2349: FND_MSG_PUB.ADD;

2345: l_dummy := to_number(fnd_profile.value('CSD_REQUISITION_LEAD_TIME'));
2346:
2347: if nvl(l_dummy,-1) <= -1 then
2348: FND_MESSAGE.SET_NAME('CSD','CSD_REQ_LEAD_TIME_NOT_SET');
2349: FND_MSG_PUB.ADD;
2350: raise fnd_api.g_exc_error;
2351: end if;
2352:
2353: l_needby_date := sysdate + l_dummy;

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

2762: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2763: lc_mod_name,
2764: 'Execution error in the API');
2765: END IF;
2766: Fnd_Msg_Pub.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data );
2767: x_return_Status := fnd_api.g_ret_sts_error;
2768: rollback to create_requisition;
2769: when fnd_api.g_exc_unexpected_error then
2770: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3171: fnd_msg_pub.initialize;

3167: END IF;
3168:
3169: IF fnd_api.to_boolean(p_init_msg_list)
3170: THEN
3171: fnd_msg_pub.initialize;
3172: END IF;
3173: -- initialize return status.
3174: x_return_status := fnd_api.g_ret_sts_success;
3175:

Line 3508: fnd_msg_pub.get(1,'F',x_msg_data,x_msg_index_out);

3504: if x_msg_count > 1
3505: then
3506: for i in 1 ..x_msg_count
3507: loop
3508: fnd_msg_pub.get(1,'F',x_msg_data,x_msg_index_out);
3509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3510: THEN
3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'msg is :'||x_msg_data);
3512: END IF;

Line 3515: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'msg is :'||x_msg_data);
3512: END IF;
3513: end loop;
3514: else
3515: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3516: p_data => x_msg_data
3517: );
3518: end if;
3519: RAISE fnd_api.g_exc_error;

Line 3664: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3660:
3661: EXCEPTION
3662: WHEN NO_DATA_FOUND THEN
3663: x_return_status := fnd_api.g_ret_sts_error;
3664: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3665: p_data => x_msg_data
3666: );
3667:
3668: WHEN fnd_api.g_exc_error THEN

Line 3670: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3666: );
3667:
3668: WHEN fnd_api.g_exc_error THEN
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3671: p_data => x_msg_data
3672: );
3673:
3674: END create_repair_warranty;

Line 3728: fnd_msg_pub.initialize;

3724: END IF;
3725:
3726: IF fnd_api.to_boolean(p_init_msg_list)
3727: THEN
3728: fnd_msg_pub.initialize;
3729: END IF;
3730:
3731: -- initialize return status.
3732: x_return_status := fnd_api.g_ret_sts_success;