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.AHL_OSP_ORDERS_PUB dependencies on FND_API

Line 21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

17: -- Parameters :
18: --
19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Default 1.0
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: -- Standard OUT Parameters :
25: -- x_return_status OUT VARCHAR2 Required

Line 22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

18: --
19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Default 1.0
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: -- Standard OUT Parameters :
25: -- x_return_status OUT VARCHAR2 Required
26: -- x_msg_count OUT NUMBER Required

Line 23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

19: -- Standard IN Parameters :
20: -- p_api_version IN NUMBER Default 1.0
21: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
22: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
24: -- Standard OUT Parameters :
25: -- x_return_status OUT VARCHAR2 Required
26: -- x_msg_count OUT NUMBER Required
27: -- x_msg_data OUT VARCHAR2 Required

Line 51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

47: -- End of Comments.
48:
49: PROCEDURE process_osp_order(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_module_type IN VARCHAR2 := NULL,
55: p_x_osp_order_rec IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_rec_type,

Line 52: p_commit IN VARCHAR2 := FND_API.G_FALSE,

48:
49: PROCEDURE process_osp_order(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_module_type IN VARCHAR2 := NULL,
55: p_x_osp_order_rec IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_rec_type,
56: p_x_osp_order_lines_tbl IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type,

Line 53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

49: PROCEDURE process_osp_order(
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: p_module_type IN VARCHAR2 := NULL,
55: p_x_osp_order_rec IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_rec_type,
56: p_x_osp_order_lines_tbl IN OUT NOCOPY AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type,
57: p_org_id IN NUMBER := NULL,

Line 73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

69: -- Standard start of API savepoint
70: SAVEPOINT process_osp_order_pub;
71:
72: -- Standard call to check for call compatibility
73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
74: G_PKG_NAME) THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

71:
72: -- Standard call to check for call compatibility
73: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
74: G_PKG_NAME) THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 79: IF FND_API.To_Boolean(p_init_msg_list) THEN

75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.To_Boolean(p_init_msg_list) THEN
80: FND_MSG_PUB.Initialize;
81: END IF;
82:
83: -- Initialize API return status to success

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: FND_MSG_PUB.Initialize;
81: END IF;
82:
83: -- Initialize API return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: /*
87: * R12 MOAC Related Changes
88: * Made by jaramana on 9/9/05

Line 118: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

114: x_msg_data => x_msg_data );
115:
116:
117:
118: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 119: RAISE FND_API.G_EXC_ERROR;

115:
116:
117:
118: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:

Line 120: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

116:
117:
118: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Standard check of p_commit

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117:
118: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Standard check of p_commit
125: IF FND_API.To_Boolean(p_commit) THEN

Line 125: IF FND_API.To_Boolean(p_commit) THEN

121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Standard check of p_commit
125: IF FND_API.To_Boolean(p_commit) THEN
126: COMMIT WORK;
127: END IF;
128:
129: -- Standard call to get message count and if count is 1, get message

Line 133: p_encoded => fnd_api.g_false);

129: -- Standard call to get message count and if count is 1, get message
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data,
133: p_encoded => fnd_api.g_false);
134:
135: --
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133: p_encoded => fnd_api.g_false);
134:
135: --
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: Rollback to process_uf_Pub;
140: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
141: p_data => x_msg_data,

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134:
135: --
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: Rollback to process_uf_Pub;
140: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
141: p_data => x_msg_data,
142: p_encoded => fnd_api.g_false);

Line 142: p_encoded => fnd_api.g_false);

138: x_return_status := FND_API.G_RET_STS_ERROR;
139: Rollback to process_uf_Pub;
140: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
141: p_data => x_msg_data,
142: p_encoded => fnd_api.g_false);
143: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
144:
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

142: p_encoded => fnd_api.g_false);
143: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
144:
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: Rollback to process_uf_Pub;
149: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
150: p_data => x_msg_data,

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
144:
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: Rollback to process_uf_Pub;
149: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
150: p_data => x_msg_data,
151: p_encoded => fnd_api.g_false);

Line 151: p_encoded => fnd_api.g_false);

147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: Rollback to process_uf_Pub;
149: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
150: p_data => x_msg_data,
151: p_encoded => fnd_api.g_false);
152: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
153:
154: WHEN OTHERS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

151: p_encoded => fnd_api.g_false);
152: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
153:
154: WHEN OTHERS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: Rollback to process_osp_order_pub;
157: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
158: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
159: p_procedure_name => 'process_osp_order',

Line 164: p_encoded => fnd_api.g_false);

160: p_error_text => SQLERRM);
161: --END IF;
162: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
163: p_data => x_msg_data,
164: p_encoded => fnd_api.g_false);
165: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
166:
167:
168: END process_osp_order;