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 3602: FND_MSG_PUB.Initialize;

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

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

4634: -- dbms_output.put_line('Returning table to caller');
4635:
4636: END IF;
4637:
4638: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4639: -- dbms_output.put_line('Finished FETCH_SAMPLES');
4640:
4641: EXCEPTION
4642: WHEN OTHERS

Line 4646: FND_MSG_PUB.Add;

4642: WHEN OTHERS
4643: THEN
4644:
4645: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
4646: FND_MSG_PUB.Add;
4647: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4648: x_return_status := FND_API.G_RET_STS_ERROR;
4649:
4650:

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

4643: THEN
4644:
4645: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
4646: FND_MSG_PUB.Add;
4647: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4648: x_return_status := FND_API.G_RET_STS_ERROR;
4649:
4650:
4651: END fetch_samples;

Line 4768: FND_MSG_PUB.Initialize;

4764:
4765: /* Initialize message list if p_int_msg_list is set TRUE. */
4766: IF FND_API.to_boolean(p_init_msg_list)
4767: THEN
4768: FND_MSG_PUB.Initialize;
4769: END IF;
4770:
4771: -- Start construction for the select.
4772: --dbms_output.put_line('Starting statement construction');

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

5456:
5457: x_sample_groups_table := g_sample_groups_table;
5458: x_return_status := FND_API.G_RET_STS_SUCCESS;
5459:
5460: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5461:
5462: EXCEPTION
5463: WHEN OTHERS THEN
5464:

Line 5466: FND_MSG_PUB.Add;

5462: EXCEPTION
5463: WHEN OTHERS THEN
5464:
5465: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
5466: FND_MSG_PUB.Add;
5467: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5468: x_return_status := FND_API.G_RET_STS_ERROR;
5469: END fetch_sample_groups;
5470:

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

5463: WHEN OTHERS THEN
5464:
5465: FND_MESSAGE.SET_NAME('GMD',SQLCODE);
5466: FND_MSG_PUB.Add;
5467: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5468: x_return_status := FND_API.G_RET_STS_ERROR;
5469: END fetch_sample_groups;
5470:
5471: end gmd_outbound_apis_pub;