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

Line 66: -- Default = FND_API.G_FALSE

62: -- Pre-reqs : None.
63: -- Parameters :
64: -- IN : p_api_version NUMBER Required
65: -- p_init_msg_list VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 68: -- Default = FND_API.G_FALSE

64: -- IN : p_api_version NUMBER Required
65: -- p_init_msg_list VARCHAR2 Optional
66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71:
72: -- OUT : x_return_status VARCHAR2(1)

Line 70: -- Default = FND_API.G_VALID_LEVEL_FULL

66: -- Default = FND_API.G_FALSE
67: -- p_commit VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_validation_level NUMBER Optional
70: -- Default = FND_API.G_VALID_LEVEL_FULL
71:
72: -- OUT : x_return_status VARCHAR2(1)
73: -- x_msg_count NUMBER
74: -- x_msg_data VARCHAR2(2000)

Line 81: -- Default = FND_API.G_MISS_NUM

77: -- p_source_doc_type VARCHAR2 Required
78: -- p_adjusted_flag VARCHAR2 Optional
79: -- Default = 'N'
80: -- p_header_id NUMBER Optional
81: -- Default = FND_API.G_MISS_NUM
82: -- p_org_id NUMBER Optional
83: -- Default = FND_API.G_MISS_NUM
84: --
85: -- OUT : x_loading_status VARCHAR2(4000)

Line 83: -- Default = FND_API.G_MISS_NUM

79: -- Default = 'N'
80: -- p_header_id NUMBER Optional
81: -- Default = FND_API.G_MISS_NUM
82: -- p_org_id NUMBER Optional
83: -- Default = FND_API.G_MISS_NUM
84: --
85: -- OUT : x_loading_status VARCHAR2(4000)
86:
87: -- Version : Current version 1.0

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

96: -- End of comments
97:
98: PROCEDURE Create_Notification
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

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

97:
98: PROCEDURE Create_Notification
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,

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

98: PROCEDURE Create_Notification
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_line_id IN NUMBER,

Line 110: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

106: p_line_id IN NUMBER,
107: p_source_doc_type IN VARCHAR2,
108: p_adjusted_flag IN VARCHAR2 := 'N',
109: p_header_id IN NUMBER := NULL,
110: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
111: x_loading_status OUT NOCOPY VARCHAR2
112: )
113: IS
114:

Line 151: IF NOT FND_API.Compatible_API_Call ( l_api_version,

147: SAVEPOINT Create_Notification;
148: --+
149: -- Standard call to check for call compatibility.
150: --+
151: IF NOT FND_API.Compatible_API_Call ( l_api_version,
152: p_api_version,
153: l_api_name,
154: G_PKG_NAME )
155: THEN

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: p_api_version,
153: l_api_name,
154: G_PKG_NAME )
155: THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF FND_API.to_Boolean( p_init_msg_list )

Line 160: IF FND_API.to_Boolean( p_init_msg_list )

156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF FND_API.to_Boolean( p_init_msg_list )
161: THEN
162: FND_MSG_PUB.initialize;
163: END IF;
164:

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: FND_MSG_PUB.initialize;
163: END IF;
164:
165: -- Initialize API return status to success
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167: x_loading_status := 'CN_INSERTED';
168:
169: --+
170: -- User hooks

Line 194: IF x_return_status = fnd_api.g_ret_sts_error THEN

190: p_header_id => p_header_id,
191: p_org_id => p_org_id,
192: x_loading_status => x_loading_status);
193:
194: IF x_return_status = fnd_api.g_ret_sts_error THEN
195: RAISE fnd_api.g_exc_error;
196: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;

Line 195: RAISE fnd_api.g_exc_error;

191: p_org_id => p_org_id,
192: x_loading_status => x_loading_status);
193:
194: IF x_return_status = fnd_api.g_ret_sts_error THEN
195: RAISE fnd_api.g_exc_error;
196: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199: END IF;

Line 196: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

192: x_loading_status => x_loading_status);
193:
194: IF x_return_status = fnd_api.g_ret_sts_error THEN
195: RAISE fnd_api.g_exc_error;
196: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199: END IF;
200:

Line 197: RAISE fnd_api.g_exc_unexpected_error;

193:
194: IF x_return_status = fnd_api.g_ret_sts_error THEN
195: RAISE fnd_api.g_exc_error;
196: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199: END IF;
200:
201: -- vertical industry pre-processing section

Line 222: IF x_return_status = fnd_api.g_ret_sts_error THEN

218: p_header_id => p_header_id,
219: p_org_id => p_org_id,
220: x_loading_status => x_loading_status);
221:
222: IF x_return_status = fnd_api.g_ret_sts_error THEN
223: RAISE fnd_api.g_exc_error;
224: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;

Line 223: RAISE fnd_api.g_exc_error;

219: p_org_id => p_org_id,
220: x_loading_status => x_loading_status);
221:
222: IF x_return_status = fnd_api.g_ret_sts_error THEN
223: RAISE fnd_api.g_exc_error;
224: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227: END IF;

Line 224: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

220: x_loading_status => x_loading_status);
221:
222: IF x_return_status = fnd_api.g_ret_sts_error THEN
223: RAISE fnd_api.g_exc_error;
224: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227: END IF;
228:

Line 225: RAISE fnd_api.g_exc_unexpected_error;

221:
222: IF x_return_status = fnd_api.g_ret_sts_error THEN
223: RAISE fnd_api.g_exc_error;
224: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227: END IF;
228:
229: --+

Line 240: IF l_org_id = FND_API.G_MISS_NUM THEN

236: -- Use the correct org_id. If the user did not specify org_id then
237: -- get the org_id from the client environment. Note that if p_org_id
238: -- is NULL, l_org_id will also be left as NULL.
239: --+
240: IF l_org_id = FND_API.G_MISS_NUM THEN
241: -- The next statement sets l_org_id to be the current ORG_ID from
242: -- the user environment. If there is no ORG_ID set, then l_client_org_id is
243: -- defaulted to -99.
244: SELECT

Line 277: RAISE FND_API.G_EXC_ERROR;

273: fnd_message.set_name('CN', 'CN_INVALID_DATA_SOURCE');
274: fnd_msg_pub.add;
275: END IF;
276: x_loading_status := 'CN_INVALID_DATA_SOURCE';
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: --+
280: -- Derive batch_id and not_trx_id
281: --+

Line 349: IF x_return_status = fnd_api.g_ret_sts_error THEN

345: p_header_id => p_header_id,
346: p_org_id => p_org_id,
347: x_loading_status => x_loading_status);
348:
349: IF x_return_status = fnd_api.g_ret_sts_error THEN
350: RAISE fnd_api.g_exc_error;
351: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
352: RAISE fnd_api.g_exc_unexpected_error;
353: END IF;

Line 350: RAISE fnd_api.g_exc_error;

346: p_org_id => p_org_id,
347: x_loading_status => x_loading_status);
348:
349: IF x_return_status = fnd_api.g_ret_sts_error THEN
350: RAISE fnd_api.g_exc_error;
351: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
352: RAISE fnd_api.g_exc_unexpected_error;
353: END IF;
354: END IF;

Line 351: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

347: x_loading_status => x_loading_status);
348:
349: IF x_return_status = fnd_api.g_ret_sts_error THEN
350: RAISE fnd_api.g_exc_error;
351: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
352: RAISE fnd_api.g_exc_unexpected_error;
353: END IF;
354: END IF;
355:

Line 352: RAISE fnd_api.g_exc_unexpected_error;

348:
349: IF x_return_status = fnd_api.g_ret_sts_error THEN
350: RAISE fnd_api.g_exc_error;
351: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
352: RAISE fnd_api.g_exc_unexpected_error;
353: END IF;
354: END IF;
355:
356: -- customer post processing section

Line 377: IF x_return_status = fnd_api.g_ret_sts_error THEN

373: p_header_id => p_header_id,
374: p_org_id => p_org_id,
375: x_loading_status => x_loading_status);
376:
377: IF x_return_status = fnd_api.g_ret_sts_error THEN
378: RAISE fnd_api.g_exc_error;
379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;

Line 378: RAISE fnd_api.g_exc_error;

374: p_org_id => p_org_id,
375: x_loading_status => x_loading_status);
376:
377: IF x_return_status = fnd_api.g_ret_sts_error THEN
378: RAISE fnd_api.g_exc_error;
379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382: END IF;

Line 379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

375: x_loading_status => x_loading_status);
376:
377: IF x_return_status = fnd_api.g_ret_sts_error THEN
378: RAISE fnd_api.g_exc_error;
379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382: END IF;
383: -- SK End of post processing hooks

Line 380: RAISE fnd_api.g_exc_unexpected_error;

376:
377: IF x_return_status = fnd_api.g_ret_sts_error THEN
378: RAISE fnd_api.g_exc_error;
379: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382: END IF;
383: -- SK End of post processing hooks
384:

Line 416: IF (l_return_code = FND_API.G_RET_STS_ERROR)

412: p_OAI_param => NULL,
413: p_OAI_array => l_OAI_array,
414: x_return_code => l_return_code);
415:
416: IF (l_return_code = FND_API.G_RET_STS_ERROR)
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN

Line 418: RAISE FND_API.G_EXC_ERROR;

414: x_return_code => l_return_code);
415:
416: IF (l_return_code = FND_API.G_RET_STS_ERROR)
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;

Line 419: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

415:
416: IF (l_return_code = FND_API.G_RET_STS_ERROR)
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: /*
425: -- Message generation API

Line 435: IF (x_return_status = FND_API.G_RET_STS_ERROR)

431: p_oai_param => null,
432: p_oai_array => l_oai_array,
433: x_return_code => x_return_status) ;
434:
435: IF (x_return_status = FND_API.G_RET_STS_ERROR)
436: THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
439: THEN

Line 437: RAISE FND_API.G_EXC_ERROR;

433: x_return_code => x_return_status) ;
434:
435: IF (x_return_status = FND_API.G_RET_STS_ERROR)
436: THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
439: THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;

Line 438: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

434:
435: IF (x_return_status = FND_API.G_RET_STS_ERROR)
436: THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
439: THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:

Line 440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

436: THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
439: THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443: */
444: END IF;

Line 449: IF FND_API.To_Boolean( p_commit )

445: END IF; --message generation section
446:
447:
448: -- Standard check of p_commit.
449: IF FND_API.To_Boolean( p_commit )
450: THEN
451: COMMIT WORK;
452: END IF;
453:

Line 460: WHEN FND_API.G_EXC_ERROR THEN

456: (p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459: EXCEPTION
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO Create_Notification;
462: x_return_status := FND_API.G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count,

Line 462: x_return_status := FND_API.G_RET_STS_ERROR ;

458: );
459: EXCEPTION
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO Create_Notification;
462: x_return_status := FND_API.G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => fnd_api.g_false

Line 466: p_encoded => fnd_api.g_false

462: x_return_status := FND_API.G_RET_STS_ERROR ;
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => fnd_api.g_false
467: );
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO Create_Notification;
470: x_loading_status := 'UNEXPECTED_ERR';

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: (p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => fnd_api.g_false
467: );
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO Create_Notification;
470: x_loading_status := 'UNEXPECTED_ERR';
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

467: );
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO Create_Notification;
470: x_loading_status := 'UNEXPECTED_ERR';
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get
473: (p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => fnd_api.g_false

Line 475: p_encoded => fnd_api.g_false

471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: FND_MSG_PUB.Count_And_Get
473: (p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => fnd_api.g_false
476: );
477: WHEN OTHERS THEN
478: ROLLBACK TO Create_Notification;
479: x_loading_status := 'UNEXPECTED_ERR';

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

476: );
477: WHEN OTHERS THEN
478: ROLLBACK TO Create_Notification;
479: x_loading_status := 'UNEXPECTED_ERR';
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: IF FND_MSG_PUB.Check_Msg_Level
482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg

Line 490: p_encoded => fnd_api.g_false

486: END IF;
487: FND_MSG_PUB.Count_And_Get
488: (p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => fnd_api.g_false
491: );
492: END Create_Notification;
493:
494: END CN_Notification_PUB;