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

Line 96: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

92: END initialized_ok;
93:
94: PROCEDURE fetch_test_methods
95: ( p_api_version IN NUMBER
96: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
97: , p_user_name IN VARCHAR2
98: , p_from_test_method_code IN VARCHAR2 DEFAULT NULL
99: , p_to_test_method_code IN VARCHAR2 DEFAULT NULL
100: , p_test_method_id IN NUMBER DEFAULT NULL

Line 128: IF NOT FND_API.Compatible_API_CALL

124: l_api_name VARCHAR2(100) := 'fetch_test_methods';
125: BEGIN
126:
127:
128: IF NOT FND_API.Compatible_API_CALL
129: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
130: OR NOT initialized_ok(p_user_name)
131: THEN
132: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 132: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

128: IF NOT FND_API.Compatible_API_CALL
129: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
130: OR NOT initialized_ok(p_user_name)
131: THEN
132: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
133: ELSE
134: gme_debug.put_line('Starting FETCH_TESTS');
135:
136: /* Initialize message list if p_int_msg_list is set TRUE. */

Line 138: IF FND_API.to_boolean(p_init_msg_list)

134: gme_debug.put_line('Starting FETCH_TESTS');
135:
136: /* Initialize message list if p_int_msg_list is set TRUE. */
137:
138: IF FND_API.to_boolean(p_init_msg_list)
139: THEN
140: FND_MSG_PUB.Initialize;
141: END IF;
142:

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294: END IF;
295:
296: --gme_debug.put_line('Returning table to caller');
297: x_test_methods_table := gmd_outbound_apis_pub.g_test_methods_table;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: END IF;
301:
302: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: THEN
307: gme_debug.put_line('EXCEPTION : '||substr(SQLERRM,1,100));
308: gmd_api_pub.log_message('GMD_API_ERROR','Fetch_Test_Methods', 'Exception',substr(SQLERRM,1,100));
309: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: END fetch_test_methods;
313:
314:

Line 317: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

313:
314:
315: PROCEDURE fetch_tests
316: ( p_api_version IN NUMBER
317: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
318: , p_user_name IN VARCHAR2
319: , p_from_test_code IN VARCHAR2 DEFAULT NULL
320: , p_to_test_code IN VARCHAR2 DEFAULT NULL
321: , p_from_test_method_code IN VARCHAR2 DEFAULT NULL

Line 378: IF NOT FND_API.Compatible_API_CALL

374: i NUMBER;
375: l_api_name VARCHAR2(100) := 'fetch_tests';
376: BEGIN
377:
378: IF NOT FND_API.Compatible_API_CALL
379: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
380: OR NOT initialized_ok(p_user_name)
381: THEN
382: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 382: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

378: IF NOT FND_API.Compatible_API_CALL
379: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
380: OR NOT initialized_ok(p_user_name)
381: THEN
382: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSE
384: /* Initialize message list if p_int_msg_list is set TRUE. */
385: IF FND_API.to_boolean(p_init_msg_list)
386: THEN

Line 385: IF FND_API.to_boolean(p_init_msg_list)

381: THEN
382: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSE
384: /* Initialize message list if p_int_msg_list is set TRUE. */
385: IF FND_API.to_boolean(p_init_msg_list)
386: THEN
387: FND_MSG_PUB.Initialize;
388: END IF;
389:

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: END LOOP;
536: END IF;
537:
538: x_tests_table := gmd_outbound_apis_pub.g_tests_table;
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540: END IF;
541:
542: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
543:

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: THEN
547: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
548: FND_MSG_PUB.Add;
549: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: x_return_status := FND_API.G_RET_STS_ERROR;
551:
552: END fetch_tests;
553:
554:

Line 557: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

553:
554:
555: PROCEDURE FETCH_SPEC_VRS
556: ( p_api_version IN NUMBER
557: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
558: , p_user_name IN VARCHAR2
559:
560: -- Parameters relating to specifications
561:

Line 772: IF NOT FND_API.Compatible_API_CALL

768:
769: BEGIN
770:
771:
772: IF NOT FND_API.Compatible_API_CALL
773: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
774: OR NOT initialized_ok(p_user_name)
775: THEN
776:

Line 777: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

773: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
774: OR NOT initialized_ok(p_user_name)
775: THEN
776:
777: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
778: ELSE
779:
780: /* Initialize message list if p_int_msg_list is set TRUE. */
781: IF FND_API.to_boolean(p_init_msg_list)

Line 781: IF FND_API.to_boolean(p_init_msg_list)

777: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
778: ELSE
779:
780: /* Initialize message list if p_int_msg_list is set TRUE. */
781: IF FND_API.to_boolean(p_init_msg_list)
782: THEN
783: FND_MSG_PUB.Initialize;
784: END IF;
785:

Line 2720: x_return_status := FND_API.G_RET_STS_SUCCESS;

2716: END LOOP;
2717: END IF;
2718:
2719: x_specifications_tbl := gmd_outbound_apis_pub.g_specifications_table;
2720: x_return_status := FND_API.G_RET_STS_SUCCESS;
2721:
2722: END IF;
2723: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2724:

Line 2732: x_return_status := FND_API.G_RET_STS_ERROR;

2728:
2729: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
2730: FND_MSG_PUB.Add;
2731: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733: END fetch_spec_vrs;
2734:
2735:
2736: PROCEDURE fetch_results

Line 2738: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2734:
2735:
2736: PROCEDURE fetch_results
2737: ( p_api_version IN NUMBER
2738: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2739: , p_user_name IN VARCHAR2
2740: , p_orgn_code IN VARCHAR2 DEFAULT NULL
2741: , p_from_sample_no IN VARCHAR2 DEFAULT NULL
2742: , p_to_sample_no IN VARCHAR2 DEFAULT NULL

Line 2793: IF NOT FND_API.Compatible_API_CALL

2789: BEGIN
2790:
2791: gme_debug.put_line('Enter GMD_OUTBOUND_APIS_PUB.FETCH_RESULTS API');
2792:
2793: IF NOT FND_API.Compatible_API_CALL
2794: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
2795: OR NOT initialized_ok(p_user_name)
2796: THEN
2797: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2797: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2793: IF NOT FND_API.Compatible_API_CALL
2794: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
2795: OR NOT initialized_ok(p_user_name)
2796: THEN
2797: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSE
2799: gme_debug.put_line('Starting FETCH_RESULTS processing');
2800: /* Initialize message list if p_int_msg_list is set TRUE. */
2801: IF FND_API.to_boolean(p_init_msg_list)

Line 2801: IF FND_API.to_boolean(p_init_msg_list)

2797: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSE
2799: gme_debug.put_line('Starting FETCH_RESULTS processing');
2800: /* Initialize message list if p_int_msg_list is set TRUE. */
2801: IF FND_API.to_boolean(p_init_msg_list)
2802: THEN
2803: FND_MSG_PUB.Initialize;
2804: END IF;
2805:

Line 3095: x_return_status := FND_API.G_RET_STS_SUCCESS;

3091:
3092:
3093: gme_debug.put_line('Returning table to caller');
3094: x_results_table := gmd_outbound_apis_pub.g_results_table;
3095: x_return_status := FND_API.G_RET_STS_SUCCESS;
3096:
3097: END IF;
3098:
3099: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3108: x_return_status := FND_API.G_RET_STS_ERROR;

3104: THEN
3105: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
3106: FND_MSG_PUB.Add;
3107: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109:
3110: END fetch_results;
3111:
3112:

Line 3115: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

3111:
3112:
3113: PROCEDURE fetch_composite_results
3114: ( p_api_version IN NUMBER
3115: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3116: , p_user_name IN VARCHAR2
3117: , p_sampling_event_id IN NUMBER DEFAULT NULL
3118: , p_composite_result_disposition IN VARCHAR2 DEFAULT NULL
3119: , p_from_item_number IN VARCHAR2 DEFAULT NULL /*NSRIVAST, INVCONV*/

Line 3150: IF NOT FND_API.Compatible_API_CALL

3146: BEGIN
3147:
3148: gme_debug.put_line('Enter GMD_OUTBOUND_APIS_PUB.FETCH_COMPOSITE_RESULTS API');
3149:
3150: IF NOT FND_API.Compatible_API_CALL
3151: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
3152: OR NOT initialized_ok(p_user_name)
3153: THEN
3154: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3154: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

3150: IF NOT FND_API.Compatible_API_CALL
3151: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
3152: OR NOT initialized_ok(p_user_name)
3153: THEN
3154: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3155: ELSE
3156:
3157: gme_debug.put_line('Starting FETCH_COMPOSITE_RESULTS processing');
3158: /* Initialize message list if p_int_msg_list is set TRUE. */

Line 3159: IF FND_API.to_boolean(p_init_msg_list)

3155: ELSE
3156:
3157: gme_debug.put_line('Starting FETCH_COMPOSITE_RESULTS processing');
3158: /* Initialize message list if p_int_msg_list is set TRUE. */
3159: IF FND_API.to_boolean(p_init_msg_list)
3160: THEN
3161: FND_MSG_PUB.Initialize;
3162: END IF;
3163:

Line 3442: x_return_status := FND_API.G_RET_STS_SUCCESS;

3438:
3439:
3440: gme_debug.put_line('Returning table to caller');
3441: x_composite_results_table := gmd_outbound_apis_pub.g_composite_results_table;
3442: x_return_status := FND_API.G_RET_STS_SUCCESS;
3443:
3444: END IF;
3445:
3446:

Line 3456: x_return_status := FND_API.G_RET_STS_ERROR;

3452: THEN
3453: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
3454: FND_MSG_PUB.Add;
3455: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3456: x_return_status := FND_API.G_RET_STS_ERROR;
3457:
3458: END fetch_composite_results;
3459:
3460:

Line 3463: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

3459:
3460:
3461: PROCEDURE fetch_samples
3462: ( p_api_version IN NUMBER
3463: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
3464: , p_user_name IN VARCHAR2
3465: , p_organization_id IN NUMBER DEFAULT NULL
3466: , p_from_sample_no IN VARCHAR2 DEFAULT NULL
3467: , p_to_sample_no IN VARCHAR2 DEFAULT NULL

Line 3584: IF NOT FND_API.Compatible_API_CALL

3580: BEGIN
3581: gme_debug.put_line('Starting FETCH_SAMPLES');
3582: -- dbms_output.put_line('Enter GMD_OUTBOUND_APIS_PUB.FETCH_SAMPLES API');
3583: -- (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
3584: IF NOT FND_API.Compatible_API_CALL
3585: (gmd_outbound_apis_pub.api_version, p_api_version , l_api_name , G_PKG_NAME)
3586: THEN
3587:
3588: -- dbms_output.put_line('api version error');

Line 3589: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

3585: (gmd_outbound_apis_pub.api_version, p_api_version , l_api_name , G_PKG_NAME)
3586: THEN
3587:
3588: -- dbms_output.put_line('api version error');
3589: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3590:
3591: ELSIF NOT initialized_ok(p_user_name)
3592:
3593: THEN

Line 3596: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

3592:
3593: THEN
3594:
3595: -- dbms_output.put_line('user name error');
3596: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3597: ELSE
3598:
3599: -- dbms_output.put_line('Starting FETCH_SAMPLES processing');
3600: gme_debug.put_line('Starting FETCH_SAMPLES processing');

Line 3602: IF FND_API.to_boolean(p_init_msg_list)

3598:
3599: -- dbms_output.put_line('Starting FETCH_SAMPLES processing');
3600: gme_debug.put_line('Starting FETCH_SAMPLES processing');
3601: /* Initialize message list if p_int_msg_list is set TRUE. */
3602: IF FND_API.to_boolean(p_init_msg_list)
3603: THEN
3604: FND_MSG_PUB.Initialize;
3605: END IF;
3606:

Line 4672: x_return_status := FND_API.G_RET_STS_SUCCESS;

4668:
4669: END LOOP;
4670:
4671: x_samples_table := gmd_outbound_apis_pub.g_samples_table;
4672: x_return_status := FND_API.G_RET_STS_SUCCESS;
4673: -- dbms_output.put_line('Returning table to caller');
4674:
4675: gme_debug.put_line('Returning table to caller');
4676:

Line 4696: x_return_status := FND_API.G_RET_STS_ERROR;

4692: FND_MSG_PUB.Add;
4693: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4694: gme_debug.put_line('exception sqlcode = '
4695: || SQLCODE );
4696: x_return_status := FND_API.G_RET_STS_ERROR;
4697:
4698:
4699: END fetch_samples;
4700:

Line 4704: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

4700:
4701:
4702: PROCEDURE fetch_sample_groups
4703: ( p_api_version IN NUMBER
4704: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
4705: , p_user_name IN VARCHAR2
4706: , p_organization_id IN VARCHAR2 DEFAULT NULL
4707: , p_from_sample_no IN VARCHAR2 DEFAULT NULL
4708: , p_to_sample_no IN VARCHAR2 DEFAULT NULL

Line 4805: IF NOT FND_API.Compatible_API_CALL

4801: l_ss_table_included VARCHAR2(10);
4802:
4803: BEGIN
4804:
4805: IF NOT FND_API.Compatible_API_CALL
4806: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
4807: OR NOT initialized_ok(p_user_name)
4808: THEN
4809: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4809: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

4805: IF NOT FND_API.Compatible_API_CALL
4806: (gmd_outbound_apis_pub.api_version, p_api_version, l_api_name,'GMD_OUTBOUND_APIS_PUB')
4807: OR NOT initialized_ok(p_user_name)
4808: THEN
4809: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
4810: ELSE
4811: --dbms_output.put_line('Starting Fetch_Sample_Groups');
4812:
4813: /* Initialize message list if p_int_msg_list is set TRUE. */

Line 4814: IF FND_API.to_boolean(p_init_msg_list)

4810: ELSE
4811: --dbms_output.put_line('Starting Fetch_Sample_Groups');
4812:
4813: /* Initialize message list if p_int_msg_list is set TRUE. */
4814: IF FND_API.to_boolean(p_init_msg_list)
4815: THEN
4816: FND_MSG_PUB.Initialize;
4817: END IF;
4818:

Line 5506: x_return_status := FND_API.G_RET_STS_SUCCESS;

5502:
5503: END IF;
5504:
5505: x_sample_groups_table := g_sample_groups_table;
5506: x_return_status := FND_API.G_RET_STS_SUCCESS;
5507:
5508: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5509:
5510: EXCEPTION

Line 5516: x_return_status := FND_API.G_RET_STS_ERROR;

5512:
5513: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
5514: FND_MSG_PUB.Add;
5515: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5516: x_return_status := FND_API.G_RET_STS_ERROR;
5517: END fetch_sample_groups;
5518:
5519: end gmd_outbound_apis_pub;