DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on FND_MESSAGE

Line 371: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');

367: THEN
368:
369: IF G_FND_MSG_TYPE_ERROR IS NULL
370: THEN
371: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');
372: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;
373: END IF ;
374:
375: l_msg_type_text := G_FND_MSG_TYPE_ERROR ;

Line 372: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;

368:
369: IF G_FND_MSG_TYPE_ERROR IS NULL
370: THEN
371: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_ERROR');
372: G_FND_MSG_TYPE_ERROR := FND_MESSAGE.GET;
373: END IF ;
374:
375: l_msg_type_text := G_FND_MSG_TYPE_ERROR ;
376:

Line 381: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');

377: ELSIF p_msg_type = WARNING
378: THEN
379: IF G_FND_MSG_TYPE_WARNING IS NULL
380: THEN
381: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');
382: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;
383: END IF ;
384:
385: l_msg_type_text := G_FND_MSG_TYPE_WARNING ;

Line 382: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;

378: THEN
379: IF G_FND_MSG_TYPE_WARNING IS NULL
380: THEN
381: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_WARNING');
382: G_FND_MSG_TYPE_WARNING := FND_MESSAGE.GET;
383: END IF ;
384:
385: l_msg_type_text := G_FND_MSG_TYPE_WARNING ;
386:

Line 392: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');

388: ELSIF p_msg_type = INFORMATION
389: THEN
390: IF G_FND_MSG_TYPE_INFORMATION IS NULL
391: THEN
392: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');
393: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;
394: END IF ;
395:
396: l_msg_type_text := G_FND_MSG_TYPE_INFORMATION ;

Line 393: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;

389: THEN
390: IF G_FND_MSG_TYPE_INFORMATION IS NULL
391: THEN
392: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_INFORMATION');
393: G_FND_MSG_TYPE_INFORMATION := FND_MESSAGE.GET;
394: END IF ;
395:
396: l_msg_type_text := G_FND_MSG_TYPE_INFORMATION ;
397:

Line 402: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');

398: ELSIF p_msg_type = CONFIRMATION
399: THEN
400: IF G_FND_MSG_TYPE_CONFIRMATION IS NULL
401: THEN
402: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');
403: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;
404: END IF ;
405:
406: l_msg_type_text := G_FND_MSG_TYPE_CONFIRMATION ;

Line 403: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;

399: THEN
400: IF G_FND_MSG_TYPE_CONFIRMATION IS NULL
401: THEN
402: FND_MESSAGE.SET_NAME('FND','FND_MESSAGE_TYPE_CONFIRMATION');
403: G_FND_MSG_TYPE_CONFIRMATION := FND_MESSAGE.GET;
404: END IF ;
405:
406: l_msg_type_text := G_FND_MSG_TYPE_CONFIRMATION ;
407:

Line 1198: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);

1194: G_NO_BATCH = l_cm_import_option )
1195: THEN
1196:
1197: l_error_msg_name := 'ENG_IMPT_INVALID_BATCH_ID' ;
1198: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1199: l_error_msg_text := FND_MESSAGE.GET;
1200:
1201: ELSIF ( G_NO_CHANGE = l_cm_import_option OR
1202: l_cm_import_option IS NULL )

Line 1199: l_error_msg_text := FND_MESSAGE.GET;

1195: THEN
1196:
1197: l_error_msg_name := 'ENG_IMPT_INVALID_BATCH_ID' ;
1198: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1199: l_error_msg_text := FND_MESSAGE.GET;
1200:
1201: ELSIF ( G_NO_CHANGE = l_cm_import_option OR
1202: l_cm_import_option IS NULL )
1203: THEN

Line 1206: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);

1202: l_cm_import_option IS NULL )
1203: THEN
1204:
1205: l_error_msg_name := 'ENG_IMPT_NO_CM_OPTION' ;
1206: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1207: l_error_msg_text := FND_MESSAGE.GET;
1208:
1209: END IF ;
1210:

Line 1207: l_error_msg_text := FND_MESSAGE.GET;

1203: THEN
1204:
1205: l_error_msg_name := 'ENG_IMPT_NO_CM_OPTION' ;
1206: FND_MESSAGE.SET_NAME('ENG',l_error_msg_name);
1207: l_error_msg_text := FND_MESSAGE.GET;
1208:
1209: END IF ;
1210:
1211:

Line 2376: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');

2372: -- Logic Here
2373: -- Init Local Vars
2374: -- Init Index Text Item Attributes
2375: IF (p_batch_id IS NULL) THEN
2376: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2377: l_msg_data := fnd_msg_pub.get();
2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2380: fnd_message.set_token('VALUE', l_msg_data);

Line 2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');

2374: -- Init Index Text Item Attributes
2375: IF (p_batch_id IS NULL) THEN
2376: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2377: l_msg_data := fnd_msg_pub.get();
2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2380: fnd_message.set_token('VALUE', l_msg_data);
2381: x_msg_data := fnd_message.get();
2382: x_msg_count := 1;

Line 2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);

2375: IF (p_batch_id IS NULL) THEN
2376: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2377: l_msg_data := fnd_msg_pub.get();
2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2380: fnd_message.set_token('VALUE', l_msg_data);
2381: x_msg_data := fnd_message.get();
2382: x_msg_count := 1;
2383: x_return_status := G_RET_STS_ERROR;

Line 2380: fnd_message.set_token('VALUE', l_msg_data);

2376: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2377: l_msg_data := fnd_msg_pub.get();
2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2380: fnd_message.set_token('VALUE', l_msg_data);
2381: x_msg_data := fnd_message.get();
2382: x_msg_count := 1;
2383: x_return_status := G_RET_STS_ERROR;
2384: RETURN;

Line 2381: x_msg_data := fnd_message.get();

2377: l_msg_data := fnd_msg_pub.get();
2378: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2379: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2380: fnd_message.set_token('VALUE', l_msg_data);
2381: x_msg_data := fnd_message.get();
2382: x_msg_count := 1;
2383: x_return_status := G_RET_STS_ERROR;
2384: RETURN;
2385: END IF;

Line 2396: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');

2392: AND PROCESS_FLAG = G_CM_TO_BE_PROCESSED
2393: AND ROWNUM = 1;
2394: EXCEPTION
2395: WHEN NO_DATA_FOUND THEN
2396: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2397: x_msg_count := 1;
2398: x_msg_data := fnd_message.get();
2399: x_return_status := G_RET_STS_SUCCESS;
2400: RAISE NO_ROWS_IN_INTF_TABLE;

Line 2398: x_msg_data := fnd_message.get();

2394: EXCEPTION
2395: WHEN NO_DATA_FOUND THEN
2396: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2397: x_msg_count := 1;
2398: x_msg_data := fnd_message.get();
2399: x_return_status := G_RET_STS_SUCCESS;
2400: RAISE NO_ROWS_IN_INTF_TABLE;
2401: END;
2402:

Line 3018: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');

3014: THEN
3015:
3016: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3017:
3018: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
3019: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3021: l_error_msg := FND_MESSAGE.GET;
3022:

Line 3019: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);

3015:
3016: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3017:
3018: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
3019: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3021: l_error_msg := FND_MESSAGE.GET;
3022:
3023: l_dyn_sql := '';

Line 3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

3016: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3017:
3018: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
3019: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3021: l_error_msg := FND_MESSAGE.GET;
3022:
3023: l_dyn_sql := '';
3024: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';

Line 3021: l_error_msg := FND_MESSAGE.GET;

3017:
3018: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_CO_NOT_FOUND');
3019: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', p_change_number);
3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3021: l_error_msg := FND_MESSAGE.GET;
3022:
3023: l_dyn_sql := '';
3024: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3025: l_dyn_sql := l_dyn_sql || '( ';

Line 3422: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');

3418: IF FND_API.to_Boolean(l_write_msg_to_intftbl) THEN
3419:
3420: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3421:
3422: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3423: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3424: l_error_msg := FND_MESSAGE.GET;
3425:
3426: l_dyn_sql := '';

Line 3423: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

3419:
3420: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3421:
3422: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3423: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3424: l_error_msg := FND_MESSAGE.GET;
3425:
3426: l_dyn_sql := '';
3427: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';

Line 3424: l_error_msg := FND_MESSAGE.GET;

3420: Write_Debug('Insert Error Message for the records which can not find CO for the Org. . .' );
3421:
3422: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_RI_NOT_FOUND');
3423: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3424: l_error_msg := FND_MESSAGE.GET;
3425:
3426: l_dyn_sql := '';
3427: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3428: l_dyn_sql := l_dyn_sql || '( ';

Line 5450: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');

5446: CLOSE get_change_number;
5447: END IF;
5448: --End code change for bug 9398720
5449:
5450: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5451: --Begin code change for bug 9398720, use change number to replace change id in this message.
5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));
5454: --End code change for bug 9398720

Line 5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));

5448: --End code change for bug 9398720
5449:
5450: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5451: --Begin code change for bug 9398720, use change number to replace change id in this message.
5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));
5454: --End code change for bug 9398720
5455: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5456: l_msg_text := FND_MESSAGE.GET;

Line 5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));

5449:
5450: FND_MESSAGE.SET_NAME('ENG','ENG_IMPT_INS_HIST');
5451: --Begin code change for bug 9398720, use change number to replace change id in this message.
5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));
5454: --End code change for bug 9398720
5455: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5456: l_msg_text := FND_MESSAGE.GET;
5457:

Line 5455: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));

5451: --Begin code change for bug 9398720, use change number to replace change id in this message.
5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));
5454: --End code change for bug 9398720
5455: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5456: l_msg_text := FND_MESSAGE.GET;
5457:
5458: Insert_Mtl_Intf_Err
5459: ( p_transaction_id => null

Line 5456: l_msg_text := FND_MESSAGE.GET;

5452: --FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', to_char(l_change_id));
5453: FND_MESSAGE.SET_TOKEN('CHANGE_NUMBER', NVL(l_change_number, to_char(l_change_id)));
5454: --End code change for bug 9398720
5455: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
5456: l_msg_text := FND_MESSAGE.GET;
5457:
5458: Insert_Mtl_Intf_Err
5459: ( p_transaction_id => null
5460: , p_bo_identifier => G_BO_IDENTIFIER

Line 5593: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

5589: open c;
5590: fetch c into recinfo;
5591: if (c%notfound) then
5592: close c;
5593: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
5594: app_exception.raise_exception;
5595: end if;
5596: close c;
5597:

Line 5603: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

5599: OR ((recinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
5600: ) then
5601: null;
5602: else
5603: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
5604: app_exception.raise_exception;
5605: end if;
5606:
5607: return;