DBA Data[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on FND_MSG_PUB

Line 140: FND_MSG_PUB.Initialize;

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:
143: -- Start construction the select.
144:

Line 302: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);
303: gme_debug.put_line('Finished');
304: EXCEPTION
305: WHEN OTHERS
306: THEN

Line 309: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

305: WHEN OTHERS
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:

Line 387: FND_MSG_PUB.Initialize;

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:
390: sql_statement := 'SELECT ';
391:

Line 542: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:
544: EXCEPTION
545: WHEN OTHERS
546: THEN

Line 548: FND_MSG_PUB.Add;

544: EXCEPTION
545: WHEN OTHERS
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;

Line 549: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

545: WHEN OTHERS
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:

Line 783: FND_MSG_PUB.Initialize;

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:
786: -- Build the query to retrieve all base rows from gmd_specifications together with
787: -- linked nested rowsets from all of the other tables..

Line 2723: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:
2725: EXCEPTION
2726: WHEN OTHERS
2727: THEN

Line 2730: FND_MSG_PUB.Add;

2726: WHEN OTHERS
2727: THEN
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:

Line 2731: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2727: THEN
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:

Line 2803: FND_MSG_PUB.Initialize;

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:
2806: -- Start construction the select.
2807:

Line 3099: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);
3100: gme_debug.put_line('Finished FETCH_RESULTS');
3101:
3102: EXCEPTION
3103: WHEN OTHERS

Line 3106: FND_MSG_PUB.Add;

3102: EXCEPTION
3103: WHEN OTHERS
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;

Line 3107: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3103: WHEN OTHERS
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:

Line 3161: FND_MSG_PUB.Initialize;

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:
3164: -- Start construction the select.
3165:

Line 3447: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3443:
3444: END IF;
3445:
3446:
3447: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3448: gme_debug.put_line('Finished FETCH_COMPOSITE_RESULTS');
3449:
3450: EXCEPTION
3451: WHEN OTHERS

Line 3454: FND_MSG_PUB.Add;

3450: EXCEPTION
3451: WHEN OTHERS
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;

Line 3455: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3451: WHEN OTHERS
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:

Line 3604: FND_MSG_PUB.Initialize;

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:
3607: -- Start construction for the select.
3608:

Line 4684: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4680:
4681:
4682: END IF;
4683:
4684: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4685: -- dbms_output.put_line('Finished FETCH_SAMPLES');
4686:
4687: EXCEPTION
4688: WHEN OTHERS

Line 4692: FND_MSG_PUB.Add;

4688: WHEN OTHERS
4689: THEN
4690:
4691: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
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;

Line 4693: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4689: THEN
4690:
4691: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
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:

Line 4816: FND_MSG_PUB.Initialize;

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:
4819: -- Start construction for the select.
4820: --dbms_output.put_line('Starting statement construction');

Line 5508: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
5511: WHEN OTHERS THEN
5512:

Line 5514: FND_MSG_PUB.Add;

5510: EXCEPTION
5511: WHEN OTHERS THEN
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:

Line 5515: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

5511: WHEN OTHERS THEN
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;