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

Line 29: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

25:
26: /* Local variable section */
27: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_RESOURCES';
28: l_row_id ROWID;
29: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30:
31:
32: /* get a record type */
33: l_resources_rec cr_rsrc_mst%ROWTYPE;

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: SAVEPOINT create_resources;
43: gmd_debug.log_initialize('CreateResourcesPub');
44:
45: /* Set the return status to success initially */
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: l_resources_rec := p_resources;
48:
49: /* Initialize message list and count if needed */
50: IF p_init_msg_list THEN

Line 55: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

51: fnd_msg_pub.initialize;
52: END IF;
53:
54: /* Make sure we are call compatible */
55: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
56: ,p_api_version
57: ,'INSERT_RESOURCES'
58: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;

Line 59: x_return_status := FND_API.G_RET_STS_ERROR;

55: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
56: ,p_api_version
57: ,'INSERT_RESOURCES'
58: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
59: x_return_status := FND_API.G_RET_STS_ERROR;
60: RAISE invalid_version;
61: END IF;
62:
63: v_insert_flag := 'Y';

Line 129: ,p_encoded => FND_API.g_false

125: END IF; /* p_resources.resources IS NOT NULL */
126:
127: fnd_msg_pub.count_and_get (
128: p_count => x_message_count
129: ,p_encoded => FND_API.g_false
130: ,p_data => x_message_list);
131:
132: IF x_message_count = 0 THEN
133: gmd_debug.put_line('Resource Header was created successfully');

Line 144: ,p_encoded => FND_API.g_false

140: WHEN resource_creation_failure OR invalid_version THEN
141: ROLLBACK TO SAVEPOINT create_resources;
142: fnd_msg_pub.count_and_get (
143: p_count => x_message_count
144: ,p_encoded => FND_API.g_false
145: ,p_data => x_message_list);
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: WHEN RESOURCE_REQUIRED THEN

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142: fnd_msg_pub.count_and_get (
143: p_count => x_message_count
144: ,p_encoded => FND_API.g_false
145: ,p_data => x_message_list);
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: WHEN RESOURCE_REQUIRED THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: ,p_data => x_message_list);
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: WHEN RESOURCE_REQUIRED THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
152: FND_MSG_PUB.ADD;
153: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

Line 162: ,p_encoded => FND_API.g_false

158: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
159: FND_MSG_PUB.ADD;
160: fnd_msg_pub.count_and_get (
161: p_count => x_message_count
162: ,p_encoded => FND_API.g_false
163: ,p_data => x_message_list);
164: x_return_status := FND_API.g_ret_sts_unexp_error;
165: END insert_resources;
166:

Line 164: x_return_status := FND_API.g_ret_sts_unexp_error;

160: fnd_msg_pub.count_and_get (
161: p_count => x_message_count
162: ,p_encoded => FND_API.g_false
163: ,p_data => x_message_list);
164: x_return_status := FND_API.g_ret_sts_unexp_error;
165: END insert_resources;
166:
167: /* =============================================================== */
168: /* Procedure: */

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: END IF ;
331: --
332: EXCEPTION
333: WHEN INVALID_MIN_MAX THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MESSAGE.SET_NAME('GMP','GMP_MIN_MAX_CAPACITY');
336: FND_MSG_PUB.ADD;
337: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
338: --

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: FND_MSG_PUB.ADD;
337: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
338: --
339: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
342: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
343: FND_MSG_PUB.ADD;
344: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: FND_MSG_PUB.ADD;
344: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
345: --
346: WHEN PS_DUP_REC THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
349: FND_MSG_PUB.ADD;
350: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
351: --

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: FND_MSG_PUB.ADD;
350: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
351: --
352: WHEN INVALID_VALUE THEN
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
355: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
356: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
357: FND_MSG_PUB.ADD;

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: FND_MSG_PUB.ADD;
358: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
359: --
360: WHEN RESOURCE_DESC_REQUIRED THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
366: --
367: WHEN INVALID_USAGE_UM THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
372: --

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
372: --
373: WHEN INVALID_RSRC_CLASS THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');
376: FND_MSG_PUB.ADD;
377: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
378:

Line 406: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

402:
403: /* Local variable section */
404: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_RESOURCES';
405: l_row_id ROWID;
406: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
407:
408: /* Define Exceptions */
409: resource_update_failure EXCEPTION;
410: invalid_version EXCEPTION;

Line 417: x_return_status := FND_API.G_RET_STS_SUCCESS;

413: SAVEPOINT update_resources;
414: gmd_debug.log_initialize('UpdateResourcePub');
415:
416: /* Set the return status to success initially */
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: /* Initialize message list and count if needed */
420: IF p_init_msg_list THEN
421: fnd_msg_pub.initialize;

Line 425: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

421: fnd_msg_pub.initialize;
422: END IF;
423:
424: /* Make sure we are call compatible */
425: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
426: ,p_api_version
427: ,l_api_name
428: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
426: ,p_api_version
427: ,l_api_name
428: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: RAISE invalid_version;
431: END IF;
432:
433: IF p_resources.resources IS NOT NULL THEN

Line 481: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

477: END IF;
478: END IF;
479:
480: /* Check if work was done */
481: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: RAISE resource_update_failure;
483: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
484:
485: fnd_msg_pub.count_and_get (

Line 483: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

479:
480: /* Check if work was done */
481: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: RAISE resource_update_failure;
483: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
484:
485: fnd_msg_pub.count_and_get (
486: p_count => x_message_count
487: ,p_encoded => FND_API.g_false

Line 487: ,p_encoded => FND_API.g_false

483: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
484:
485: fnd_msg_pub.count_and_get (
486: p_count => x_message_count
487: ,p_encoded => FND_API.g_false
488: ,p_data => x_message_list);
489:
490: IF x_message_count = 0 THEN
491: gmd_debug.put_line('Resource was Updated successfullly');

Line 502: ,p_encoded => FND_API.g_false

498: ROLLBACK TO SAVEPOINT update_resources;
499: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
500: fnd_msg_pub.count_and_get (
501: p_count => x_message_count
502: ,p_encoded => FND_API.g_false
503: ,p_data => x_message_list);
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT update_resources;

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: fnd_msg_pub.count_and_get (
501: p_count => x_message_count
502: ,p_encoded => FND_API.g_false
503: ,p_data => x_message_list);
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT update_resources;
507: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
508: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 513: ,p_encoded => FND_API.g_false

509: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
510: FND_MSG_PUB.ADD;
511: fnd_msg_pub.count_and_get (
512: p_count => x_message_count
513: ,p_encoded => FND_API.g_false
514: ,p_data => x_message_list);
515: x_return_status := FND_API.g_ret_sts_unexp_error;
516: END update_resources;
517:

Line 515: x_return_status := FND_API.g_ret_sts_unexp_error;

511: fnd_msg_pub.count_and_get (
512: p_count => x_message_count
513: ,p_encoded => FND_API.g_false
514: ,p_data => x_message_list);
515: x_return_status := FND_API.g_ret_sts_unexp_error;
516: END update_resources;
517:
518: /* =============================================================== */
519: /* Procedure: */

Line 548: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

544: l_counter number;
545:
546: /* Local variable section */
547: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCES';
548: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
549:
550: /* Define Exceptions */
551: resource_delete_failure EXCEPTION;
552: invalid_version EXCEPTION;

Line 558: x_return_status := FND_API.G_RET_STS_SUCCESS;

554: SAVEPOINT delete_resources;
555: gmd_debug.log_initialize('DeleteResourcePub');
556:
557: /* Set the return status to success initially */
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: /* Initialize message list and count if needed */
561: IF p_init_msg_list THEN
562: fnd_msg_pub.initialize;

Line 566: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

562: fnd_msg_pub.initialize;
563: END IF;
564:
565: /* Make sure we are call compatible */
566: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
567: ,p_api_version
568: ,l_api_name
569: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version
567: ,p_api_version
568: ,l_api_name
569: ,GMP_RESOURCES_PUB.m_pkg_name) THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: RAISE invalid_version;
572: END IF;
573:
574: OPEN Cur_resources;

Line 594: ,p_encoded => FND_API.g_false

590: END IF;
591: --
592: fnd_msg_pub.count_and_get (
593: p_count => x_message_count
594: ,p_encoded => FND_API.g_false
595: ,p_data => x_message_list);
596:
597: IF x_message_count = 0 THEN
598: gmd_debug.put_line('Resource was deleted successfully');

Line 609: ,p_encoded => FND_API.g_false

605: ROLLBACK TO SAVEPOINT delete_resources;
606: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
607: fnd_msg_pub.count_and_get (
608: p_count => x_message_count
609: ,p_encoded => FND_API.g_false
610: ,p_data => x_message_list);
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: WHEN OTHERS THEN
613: ROLLBACK TO SAVEPOINT delete_resources;

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607: fnd_msg_pub.count_and_get (
608: p_count => x_message_count
609: ,p_encoded => FND_API.g_false
610: ,p_data => x_message_list);
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: WHEN OTHERS THEN
613: ROLLBACK TO SAVEPOINT delete_resources;
614: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
615: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 620: ,p_encoded => FND_API.g_false

616: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
617: FND_MSG_PUB.ADD;
618: fnd_msg_pub.count_and_get (
619: p_count => x_message_count
620: ,p_encoded => FND_API.g_false
621: ,p_data => x_message_list);
622: x_return_status := FND_API.g_ret_sts_unexp_error;
623: END delete_resources;
624:

Line 622: x_return_status := FND_API.g_ret_sts_unexp_error;

618: fnd_msg_pub.count_and_get (
619: p_count => x_message_count
620: ,p_encoded => FND_API.g_false
621: ,p_data => x_message_list);
622: x_return_status := FND_API.g_ret_sts_unexp_error;
623: END delete_resources;
624:
625: END GMP_RESOURCES_PUB;